解决Navicat 出错:1130-host . is not allowed to connect to this MySql server,MySQL

具体原理是localhost改成%。

mysql -u root -p password

mysql>use mysql;

mysql>update user set host ='%'where user ='root' and host ='localhost';

mysql>flush privileges;

注：这时候连接此服务器的mysql客户端需要重新启动下，然后再连接此服务器