mysql怎么给数据库添加用户 – 数据库 – 前端，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、授权

a)、user01管理db01全部权限

GRANT ALL PRIVILEGES ON db01.* TO user01;

b)、user02查看权限，并修改密码

GRANT SELECT ON *.* TO ‘user02’@’%’ IDENTIFIED by ‘password2’;

mysql的数据库类型，mysql 命令 单引号，mysql每日订单 补0，mysql实验调试和总结，mysql pdo 更新，mysql执行提权命令