mysql添加授权用户
更改root密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 's*utuip12d+2Z-';
mysql8以上新增
创建用户
创建一个用户study,密码为study123456
create user 'study'@'%' identified by 'study123456';
赋予用户权限
赋予study所有数据库所有权限
grant all on *.* to 'study'@'%';
Mysql 8.0以下授权命令
grant all on *.* to 'study'@'%' identified by 'study@123456';