mysql连接linux系统提示“登录出现1130 is not allowed to connect to this MySql server”问题,解决方法

时间:2022-09-22 19:09:15

你想root用户名使用root密码从任何主机连接到MySQL服务器的话。

运行命令:mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

mysql连接linux系统提示“登录出现1130 is not allowed to connect to this MySql server”问题,解决方法

命令: GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'ekanet321' WITH GRANT OPTION;