mysql启动失败,错误信息
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
解决方法,vi /etc/mysql/my.cnf,找到bind-address:
原来 bind-address=127.0.0.1
改为 bind-address=192.168.1.110 #具体的ip,如果设置了回环地址(lo),则不必如此改
启动 sudo /etc/init.d/mysql start ... [OK]
检查 netstat -nat | grep 3306
晕吧!
------------------------------
要允许远程访问:bind-address=0.0.0.0
用netstat -nat检查,监听0.0.0.0:3306则正确,如果监听127.0.0.1:3306,则只能本地访问,远程不能连接。
----------------------------------------------------
加快远程连接:在/etc/mysql/my.cnf[mysqld]段添加一行skip-name-resolve,表跳过dns反向解析。
查看进程mysql>show processlist;