When mysql 1130 is remotely connected through Navicat for MySQL, an error is returned.

When mysql 1130 is remotely connected through Navicat for MySQL, the ERROR code is 1130, ERROR 1130: Host xxx. xxx. xxx. xxx is not allowed to connect to this MySQL server is unable to give remote connection to the user permission problem www.2cto.com to authorize the user I use the user is the root password 123456 preferred syntax is: SQL code GRANT ALL PRIVILEGES ON *. * TO 'myuser' @ '%' identified by 'mypassword' with grant option; example: SQL code GRANT ALL PRIVILEGES ON *. * TO 'root' @ '%' identified by '000000' with grant option; after www.2cto.com is executed, mysql: flush privileges; refresh the permission, you do not need to restart the entire operation: Start-> Run-> cmd cd \ cd mysql installation directory \ bin mysql-u root-p123456; mysql grant all privileges on *. * TO 'root' @ '%' identified by '000000' with grant option; mysql flush privileges; Author: heisetoufa