Navicat for MySQL connection MySQL database tip 1130 Error

Navicat for MySQL connection MySQL database tip 1130 Error

Error code is 1130:error 1130:host xxx.xxx.xxx.xxx are not allowed to connect to this MySQL server

Error code reason: is a user permission issue that cannot be given to a remote connection

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6E/4F/wKioL1V5HAmT9Qf-AACSaQmDI54917.jpg "title=" Qq20150611131552.png "alt=" Wkiol1v5hamt9qf-aacsaqmdi54917.jpg "/>

error code Resolution: is to give the user authorization permissions I use the user is the root password 123456

Enter the MySQL database to execute the following code:

GRANT all privileges on * * to ' root ' @ '% ' identified by ' 123456 ' with GRANT OPTION;

Flush privileges;

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6E/4F/wKioL1V5HVzS3mHkAADZdDhlIe0199.jpg "title=" Qq20150611132444.png "alt=" Wkiol1v5hvzs3mhkaadzddhlie0199.jpg "/>

Test: Using Navicat for MySQL to connect to the MySQL database, the connection will be successful.

Navicat for MySQL connection MySQL database tip 1130 Error