Host 'xx' is not allowed to connect to this MySQL server 的解决方法

最新推荐文章于 2024-05-07 14:14:37 发布

jerome_wang

最新推荐文章于 2024-05-07 14:14:37 发布

阅读量174

点赞数

分类专栏： mysql 文章标签：数据库

本文链接：https://blog.csdn.net/jerome_wang/article/details/84131606

版权

mysql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

Host 'xx' is not allowed to connect to this MySQL server 的解决方法

2009/03/16 11:47

如果你想连接你的mysql的时候发生这个错误：
ERROR 1130: Host '210.13.92.66' is not allowed to connect to this MySQL server
请按照如下方法解决:

login as: root ///登陆系统
root@tqwm.cn's password: ///输入密码
Last login: Tue Apr 15 14:06:54 2008 from 210.13.92.66
[root@myserver ~]# /usr/local/mysql/bin/mysql -uroot -hlocalhost -p ///登入mysql
Enter password: ///输入mysql对应用户的密码
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 431
Server version: 5.0.58-enterprise-gpl-log Source

Type 'help;' or '\h' for help. Type '\c' to clear the buffer. ///登入成功的提示信息

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'rootpasswd' WITH GRANT OPTION; ///输入这段指令并回车后允许所有用root用户并且输入rootpasswd密码的主机登入该mysql Server 如果将'%'换成'10.1.1.1'那么只有10.1.1.1的主机可以登陆.
Query OK, 0 rows affected (0.07 sec)

mysql> \q ///退出mysql