解决MySQL远程登录时出现ERROR 1130错误问题_MySQL
[root@openfire ~]# mysql -u root -h mysql.clvn.com.cn -p
Enter password:
ERROR 1130 (HY000): Host '192.168.0.15' is not allowed to connect to this MySQL server
解决方法:
[root@mysql ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or /g.
Your MySQL connection id is 10
Server version: 5.1.71 Source distribution
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.
mysql> GRANT ALL PRIVILEGES ON openfire.* TO 'root'@'192.168.0.15' IDENTIFIED BY 'redhat' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
再次进行登录测试
[root@openfire ~]# mysql -u root -h mysql.clvn.com.cn -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or /g.
Your MySQL connection id is 22
Server version: 5.1.71 Source distribution
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.
mysql> exit
Bye
问题解决
推荐阅读
-
解决mysql安装时出现error Nr.1045问题的方法
-
解决MySQL安装重装时出现could not start the service mysql error:0问题的方法
-
mysql启动时出现ERROR 2003 (HY000)问题的解决方法
-
mysql启动时出现ERROR 2003 (HY000)问题的解决方法
-
Ubuntu Server 16.04安装MySQL设置远程访问出现问题的完美解决方案(error:10061)
-
主机Natcivat远程连接服务器Mysql报1130错误问题的解决办法
-
关于对连接数据库时出现1130-host “**” is not allowed to connect to this MySql/mariadb server 的错误解决方法
-
Navicat连接本地Mysql出现10061错误,但链接远程没有问题的解决方_MySQL
-
解决MySQL远程登录时出现ERROR 1130错误问题_MySQL
-
Navicat连接本地Mysql出现10061错误,但链接远程没有问题的解决方_MySQL