ERROR 1130: Host '192.168.1.3' is not allowed to connect to this MySQL

当使用Mysql帐号远程登陆的时候,出现类似如下错误:
ERROR 1130: Host '     ' is not allowed to connect to this MySQL 

 

解决办法:授权法

GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

 

允许用户myuser从%(任何地方)的主机连接到mysql服务器,并使用mypassword作为密码

posted @ 2018-03-22 15:52  九月彭于晏  阅读(512)  评论(0编辑  收藏  举报