debian mysql安装以及navicat连接遇到的一个问题。

1.安装mysql

apt-get install mysql-server mysql-client

2.启动mysql服务

Debian / Ubuntu Linux 
1.启动：/etc/init.d/mysql start
2.停止：/etc/init.d/mysql stop
3.重启：/etc/init.d/mysql restart

3.navicat连接
发现出现报错 Can't connect to MySQL server on '*.*.*.*' .

这时候使用winscp 打开mysql的文件目录里面的my.cnf文件，

#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
#


调整成这样。



4.重启mysql服务

  连接成功