mysql用户授权

grant select，insert，update，delete on db_name.table_name to user_name@'%';

 

/*rds*/
drop user user_name;
drop user user_name@'%';

create user user_name;
create user user_name@'%';

grant select on db_name.table_name to user_name @'%'; 

grant select,insert,update,delete on db_name.table_name to username @'%' identified by 'new_password'; 
flush privileges; 
show grants for user_name;

 

/**/
select user ,`Password` from `user`;

SET PASSWORD FOR root=PASSWORD('sxh-=0911.');

DROP user shengxianghui FROM `user`;

create user shengxianghui IDENTIFIED BY '';
create user shengxianghui_1 IDENTIFIED BY '032794';
create user shengxianghui_2  AND PASSWORD is '032794';
RENAME user shengxianghui TO lipan;
UPDATE user shengxianghui IDENTIFIED BY '032794';
UPDATE user lipan IDENTIFIED BY '032794';

REVOKE user shengxianghui_1;

DROP user mysql.`user` ON shengxiangui_1@'%';

show GRANTS FOR shengxianghui_1;

REVOKE SELECT ON mysql.* to shengxianghui;

GRANT select on mysql.* to shengxianghui_1;

DROP user shengxianghui,lipan;

CREATE user shengxianghui,lipan,caisiheng;

set PASSWORD FOR shengxianghui = PASSWORD('0327')

GRANT select , UPDATE on mysql.* TO shengxianghui;

REVOKE USER shengxianghui; 

SHOW GRANTS FOR shengxianghui;




SELECT * FROM `t_user`;

INSERT INTO t_user(username,password,age,phone,email) SELECT username,password,age,phone,email FROM t_user;

ANALYZE TABLE t_user;

CHECK TABLE t_user;

show status;

show VARIABLES;

show PROCESSLIST;