使用telnet 192.168.x.x无法连接mysql (Unable to connect to remote host: Connection refused)，开启mysql远程连接的方式

问题

端口telnet不通

root@admin1-virtual-machine:~# telnet 192.168.63.129 3306
Trying 192.168.63.129... 
telnet: Unable to connect to remote host: Connection refused

首先确认mysql是否开启对外端口

netstat -nltp | grep mysql

结果如下

Proto Recv-Q Send-Q   Local Address   Foreign Address State   PID/Program name
tcp        0      0   127.0.0.1:3306     0.0.0.0:*    LISTEN   2717/mysqld

解析：
Local Address的地址为127.0.0.1 说明该端口对本地可见，对外不可见
##开启对外端口

vim /etc/mysql/mysql.conf.d/mysqld.cnf

把如下行注释掉