mysql笔记五：权限管理

1、新建用户

 insert into mysql.user(Host,User,Password)values("localhost","leon",password("123456"));

2、为某用户授权访问某数据库

 grant all privileges on test.* to leon@localhost identified by '123456';  #所有权限

 grant select on test.* to leon@localhost identified by '123456';  #所有权限

3、刷新权限表

flush privileges;

 

4、更新用户密码

update mysql.user set password=password('123456') where user='leon-1' and host='localhost';

 

5、删除用户

delete from user mysql.user where user='leon-1' and host='localhost';

 

6、查看用户权限

 show grants for leon@'localhost';