mysql resolves a remote client connection not possible

1. Change the table method. It may be that your account is not allowed to log on remotely, only on localhost. This time, as long as the computer on the localhost, log in to MySQL, change the "MySQL" Database in the "User" table "host", from "localhost" to "%"

Mysql-u root-pvmwaremysql>use mysql;mysql>update User Set host = '% ' where user = ' root '; Mysql>select host, use R from user;

2. Authorization law. For example, if you want to myuser use MyPassword to connect to a MySQL server from any host.

GRANT all privileges on * * to ' myuser ' @ ' percent ' identified by ' MyPassword ' with GRANT OPTION;

If you want to allow users to connect to the MySQL server from a host myuser IP 192.168.1.3 and use MyPassword as the password

GRANT all privileges on * * to ' myuser ' @ ' 192.168.1.3 ' identified by ' MyPassword ' with GRANT OPTION;

My mysql.user root user's host is localhost, first with the change table method to localhost to "%", or not, still reported 1130 error, and press "from any host connected to MySQL server" method authorization, or reported the same mistake, Finally to their own IP authorization, finally logged on ....

MySQL 1130 Error Resolution Method:
This error occurs when you connect to MySQL via Mysql-front or MySQL administrator

Indicates that the connected user account does not have remote connection permissions and can only log on natively (localhost).
You need to change the host entry in the user table in the MySQL database
Rename localhost to%

Specific steps: Login to MySQL
First use MySQL;
There was an error when the update was provided in the other way.

The host information for the following database is then viewed as follows:

+-----------------------+
| Host |
+-----------------------+
| % |
| 127.0.0.1 |
| Localhost.localdomain |
+-----------------------+
3 Rows in Set (0.00 sec)
The host already has the% value, so run the command directly:

mysql resolves a remote client connection not possible