Host is not allowed to connect to this MySQL Server

If you want to connect to your MySQL instance, this error occurs:
Error 1130: Host '192. 13.92.66 'is not allowed to connect to this MySQL Server
Follow these steps:

Login as: Root // log on to the system
Root@tqwm.cn's password: // enter the 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 // log on to MySQL
Enter Password: // enter the password of the MySQL user
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. // message indicating Successful Logon

Mysql> grant all privileges on *. * To 'root' @ '%' identified by 'rootpasswd' with grant option; /// enter this command and press enter to allow all hosts that use the root user and enter the rootpasswd password to log on to the MySQL server. If '%' is changed to '10. 1.1.1 'only hosts of 10.1.1.1 can log on.
Query OK, 0 rows affected (0.07 Sec)

Mysql> \ q // exit MySQL
Bye
[Root @ myserver ~] #

Another way is to transfer data from other places.

Change the table. It may be that your account is not allowed to log on remotely, but only on localhost. At this time, you only need to log in to MySQL on the computer of localhost, and change the "host" entry in the "user" table in the "MySQL" database to "%" from "localhost"

Mysql-u root-pvmwaremysql> use MySQL; mysql> Update user set host = '%' where user = 'root'; mysql> select host, user from user;

Solution:

Run grant all privileges on *. * To 'root' @ '% 'identified by 'Password' with grant option directly under MySQL \ bin in cmd.