It ninja turtle MySQL remote connection: ERROR 1130 (HY000): Host ' *.*.*.* ' is not allowed to connect to this MySQL server resolves

After the installation of MySQL, the remote connection to the database, the error 1130 (HY000): Host ' 192.168.0.1 ' is not allowed to connect to this MySQL server prompt information, can not connect data remotely Library. Consider probably because the system database MySQL in the user table host is localhost, so, I try to change this value to their own server IP, sure enough, but with Mysql-u root-p command is not connected to the database, need to use mysql-h Server Ip-u root-p Because of the default connection to the MySQL database user table in the value of host, and the default host for this command is localhost, it is not connected.

How to do it:

After MySQL is connected with localhost,
Use MySQL;
Update user set host= ' 123.456.789.254 '; (IP for the IP of the local machine you want to remotely connect to the database)
\q;

Quit MySQL, and then restart MySQL on the go.

Other Solutions

2.  Change 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" entry, from "localhost" to "%"
Mysql-u root-pvmware
Mysql>use MySQL;
Mysql>update User Set host = '% ' where user = ' root ';
Mysql>flush privileges;
Mysql>select Host, user from user;

3.  Authorization method . For example, if you want to myuser use MyPassword to connect to a MySQL server from any host.
GRANT all privileges on *. * to ' myuser ' @ '% ' identified by ' MyPassword ' with GRANT OPTION;
If you want to allow the user to connect to the MySQL server myuser from the IP-192.168.1.3 host and use MyPassword as the password
GRANT all privileges on *. * to ' myuser ' @ ' 192.168.0.1 ' identified by ' MyPassword ' with GRANT OPTION;

***********************************************************************
phpMyAdmin said that is the user name password problem, it is strange that the root username password is certainly not a problem, and through the command line connection is not a problem. Check the configuration file again, or there is no problem. Then went to search, find this solution.

Log in to the MySQL server with root and execute
Mysql>set password for you to use the username @ "localhost" =old_password (' password of this user ');

The reason is because you use the MySQL server version of the new password authentication mechanism, which requires the client version to be above 4.0, the original password function was changed to Old_password (), so that the use of password () generated by the password in the old version can solve the problem .

It ninja turtle MySQL remote connection: ERROR 1130 (HY000): Host ' *.*.*.* ' is not allowed to connect to this MySQL server resolves