ubuntu云端服务器MySQL更改本地循环监听

其实这个是之后我才想起来写的博客，现在不知道行不行，当时因为做Java项目把数据库放云端了，死活连不上

不行请留言，我改

0，先去把服务器的3306端口开了

1，去etc/mysql/mysql.conf.d

2, 把mysqld.cnf里的port改成3306

bind-adress=0.0.0.0

界面大致如下：

user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= /var/lib/mysql
tmpdir		= /tmp
lc-messages-dir	= /usr/share/mysql
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address		= 0.0.0.0

3，重启mysql

/etc/init.d/mysql restart

4，检查

netstat -l