其实这个是之后我才想起来写的博客,现在不知道行不行,当时因为做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