1130 - Host'XX-xx' is not allowed to connect to this MySQL server

MySQL常见的错误码讲解: https://www.cnblogs.com/henrylinux/p/9746867.html

  • 密码错误: 1130 - Host'XX-xx' is not allowed to connect to this MySQL server

  • MySQL服务所在主机IP地址错误: 1130 - Host'XX-xx' is not allowed to connect to this MySQL server

出现上述连接错误主要从以下几个步骤解决

确定目的连接服务器的IP地址

1130 - Host'XX-xx' is not allowed to connect to this MySQL server

保证目的服务器上的MySQL提供远程连接服务

授权远程访问 :(A->B,则再B计算机的Mysql中以root账户执行以下命令)
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
FLUSH PRIVILEGES;

--> 
上一篇:MYSQL ERROR 1130 (HY000) 的错误解决方案(转)


下一篇:【算法千题案例】每日一练LeetCode打卡——103.亲密字符串