当使用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作为密码
当使用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作为密码
转载于:https://www.cnblogs.com/boguse/p/8624356.html