MYSQL远程连接被拒绝

问题描述

Caused by: java.net.ConnectException: 拒绝连接 (Connection refused)
    at java.net.PlainSocketImpl.socketConnect(Native Method)
    at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
    at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
    at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
    at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
    at java.net.Socket.connect(Socket.java:606)
    at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
    at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
    ... 21 more

重置远程连接密码

# 查看mysql的连接权限
SELECT USER, HOST FROM mysql.user WHERE USER = 'root';



设置之前需要先调整密码策略
修改 /etc/my.cnf 文件 添加如下内容
[mysqld]
validate_password.policy=LOW
validate_password.length=6

# 重置密码
ALTER USER 'root'@'%' IDENTIFIED BY '123456';

# 重置密码后需要重启mysql
service mysqld restart
# 或
service mysql restart

# 查看mysql允许状态
service mysqld status
# 或
service mysql status