In the development in order to make development more convenient, in the local configuration environment, you want to have direct access to the MySQL database on the server, more convenient management database,
You need to remotely connect to the local database of the Linux server, directly connected with the database management tool, the following error 1130-host 127.0.0.1 is not allowed to connect to this MySQL server:
This error indicates that MySQL does not allow remote logins, as long as the authorization can telnet on OK.
Log on to the server, Mysql-u root-p return, Password: (enter your password), enter the command after MySQL:
GRANT All Privileges on *. * to ' Root '@ '%' by'yourpassword' with GRANT OPTION; /* replace ' yourpassword ' in the command with your database password */
Modify and then type the refresh using permissions command:
Privileges
If you do not enter the Refresh Permission command, you can also restart the mysqld command:
Service mysqld Restart
Connect to the server using the database management tool when you are finished everything is fine!
MySQL 1130-host 127.0.0.1 isn't allowed to connect to this MySQL server