mysql 用户权限管理

创建用户：

1.

grant all on *.*  to 'yrt'@'localhost' identified by '123456'

2.

grant select,update on db.* to 'yrt'@'www.lulu.info' identified by '123456;

3.

grant select on * to 'yrt' identified by '123456';

查看用户权限

1.

show grants for 'yrt';

2.

show grants for 'yrt'@'localhost';

更改用户权限

1.

revoke select on db.* from yrt;

3.

revoke all on db.* from 'yrt'@'localhost';