mysql创建用户并授权

1、用管理员登陆mysql

2、创建数据库

create database db01;

3、创建用户

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

4、修改user01密码

SET PASSWORD FOR 'user01'@'localhost' = PASSWORD('password2');

5、授权

user01管理db01全部权限
GRANT ALL PRIVILEGES ON db01.* TO user01;
user02查看权限，并修改密码
GRANT SELECT  ON *.* TO 'user02'@'%' IDENTIFIED by 'password2';