Mysql 远程访问出现 “SQL Error (1130): Host 'X.X.X.X' is not allowed to connect to this MySQL server“

mac2025-06-04  17

Mysql 远程访问出现 “SQL Error (1130): Host ‘X.X.X.X’ is not allowed to connect to this MySQL server“

1.命令登录mysql管理

2.进入mysql数据库

3.查看user表(select host,user from user; )

4.修改 user表( update user set host=’%’ where user=‘root’; ) 修改后结果如下:

5.重启mysql服务

最新回复(0)