20121211 mysqld.sock丢失无法启动mysql和登陆

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.socket'

mysql无法启动

1,查看mysql的错误日志,到/etc/mysql/my.cnf中找到日志的路径log_error=/var/log/mysql;

121211 12:32:14 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
121211 12:32:14 [ERROR] Do you already have another mysqld server running on port: 3306
121211 12:32:14 [ERROR] Aborting

发现:端口3306被占用,

用命令:sudo netstat -anp | grep 3306

把占用端口的程序干掉,启动mysql:service mysql start ,好了

原文地址:https://www.cnblogs.com/tangtianfly/p/2812707.html