ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘39.103.234.27:3306‘ (10061)

报错：

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';

不报错了。