报错:
ERROR 2003 (HY000): Can't connect to MySQL server on '39.103.234.27:3306' (10061)
修改/etc/mysql/mysql.conf.d/mysqld.cnf
,注释掉如下行,从而允许从外部ip访问服务器:
#bind-address = 127.0.0.1
又报错:
ERROR 1130 (HY000): Host '58.219.110.161' is not allowed to connect to this MySQL server
查看mysql.user,发现是因为root只允许从localhost访问
select user, plugin from mysql.user;
修改localhost
为%
,表示允许任何host使用root登录
update mysql.user set host = '%' where user = 'root';
修改结果:
还报错:
ERROR 1698 (28000): Access denied for user 'root'@'58.219.110.161'
查看发现root是使用auth_socket插件认证,即只允许在linux本地使用socket登录:
将认证插件修改为caching_sha2_password
,允许使用密码登录,同时设置密码
alter user 'root'@'%' identified with caching_sha2_password by 'xxxxxx';