MySQL said: Host 'XXX' is not allowed to connect to this MySQL server

itodouble

于 2017-02-11 14:07:40 发布

阅读量569

点赞数

文章标签： mysql

12 篇文章

订阅专栏

本文介绍了解决MySQL服务器不允许远程主机连接的问题，并提供了详细的步骤来配置特定IP地址或所有IP地址对root用户的访问权限。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

MySQL said: Host 'XXX' is not allowed to connect to this MySQL server

MySQL不允许远程登录
解决方法：

允许root用户从任何主机连接MySQL服务器

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
FLUSH   PRIVILEGES;

允许root用户从“192.168.2.1”主机连接MySQL服务器

GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.2.1' IDENTIFIED BY '123456' WITH GRANT OPTION;
FLUSH   PRIVILEGES;

允许root用户从“192.168.2.1”主机连接MySQL服务器中的test数据库

GRANT ALL PRIVILEGES ON db.test TO 'root'@'192.168.2.1' IDENTIFIED BY '123456' WITH GRANT OPTION;
FLUSH   PRIVILEGES;