Solve the error ERROR1130 during MySQL remote logon. the following error occurs when mysql is used for remote connection.
[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
Solution:
[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,201 3, 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)
Log on again
[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,201 3, 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
Problem solving