Centos8远程连接mysql报You are not allowed to create a user with GRANT错误
解决办法
#1. 修改root去配置
mysql -uroot -p
use mysql
# 修改链接权限
update user set host='%' where user ='root';
# 更改加密方式
update user set plugin='mysql_native_password' where user ='root';
# 允许所有IP链接
grant all on ...
原创
2020-04-27 14:47:07 ·
424 阅读 ·
0 评论