mysql操作笔记

 user01只能本地访问
CREATE USER user01@'localhost' IDENTIFIED BY 'password1';
user02可以远程访问
CREATE USER user02@'%' IDENTIFIED BY 'password1';

创建数据库
CREATE DATABASE db01;

修改user01密码
SET PASSWORD FOR 'user01'@'localhost' = PASSWORD('password2');
授权
a)、user01管理db01全部权限
GRANT ALL PRIVILEGES ON db01.* TO user01;
b)、user02查看权限，并修改密码
GRANT SELECT ON *.* TO 'user02'@'%' IDENTIFIED by 'password2';

 GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY 'root_pwd' WITH GRANT OPTION;

FLUSH PRIVILEGES;


 


执行完后，可以在mysql数据库user表里看到新增了一条记录，并且远程可以访问了


 


revoke ALL PRIVILEGES ON *.* FROM'root'@'%';可以看到新增表项里的权限都更新为‘N’;


 


这时远程连接没有问题，但没有任何权限了。如果禁止远程连接则删除这条新增的记录即可.


 


delete from user where host='%';