sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf# 原始,只允许本机连接
bind-address = 127.0.0.1
# 修改为 ::,允许 IPv4 和 IPv6 远程连接 修改认证插件# 修改认证插件为 mysql_native_password,原始是 caching_sha2_password
ALTER USER 'xxx'@'%' IDENTIFIED WITH mysql_native_password BY '你的密码';
FLUSH PRIVILEGES;修改后重启 sudo systemctl restart mysql