记录:不允许1130连接mysql_解决Navicat 报错:1130-host ... is not allowed to connect to this MySql server

可能是你的账号不允许远程登录

进行以下操作

mysql -u root -pvmwaremysql>use mysql;进入mysql数据库

mysql>update user set host = ‘%’ where user = ‘root’;修改地址为任意

mysql>select host, user from user;查看是否修改成功

mysql>FLUSH PRIVILEGES //修改生效