Resolve Error 1130 (HY000): Host ' 192.168.1.9 ' is not allowed to connect to this MySQL server

This machine is MySQL database, want to use another IP for 192.168.1.9 connection this MySQL database, but reported this error.

2 ways to get a query

The first is to change the localhost to% in the user table, I do not have to solve the problem, the local connection to [e-mail protected]% to do so (now think of it as if the error has changed all localhost).

The second method is in effect.

Terminal login MySQL, execute a sentence of sql:

GRANT All privileges on * * to ' root ' @ ' 192.168.1.9 ' identified by ' Chaojimima ' with GRANT OPTION;

Where ' Chaojimima ' is the setting of the connection password, and then 192.168.1.9 can be connected, simple and effective, not any host can be connected, but also a bit safer.

Resolve Error 1130 (HY000): Host ' 192.168.1.9 ' is not allowed to connect to this MySQL server