解决mysqld_safe无法启动问题的方法

下文来为各位介绍解决mysqld_safe无法启动问题的方法,如果你碰到mysqld safe无法启动问题可以进入本站来参考解决方案.

启动mysql时报错:

1. 14122007:50:59mysqld_safemysqldfrompidfile/usr/local/mysql/data/vps.cbo999.com.pidended
2. 14122007:54:30mysqld_safeStartingmysqlddaemonwithdatabasesfrom/usr/local/mysql/data--phpfensi.com
3. 1412207:54:30[Note]Plugin‘InnoDB’isdisabled.
4. 1412207:54:30[Note]Serverhostname(bind-address):‘0.0.0.0’;port:3306
5. 1412207:54:30[Note]–‘0.0.0.0’resolvesto‘0.0.0.0’;
6. 1412207:54:30[Note]ServersocketcreatedonIP:‘0.0.0.0’.
7. 1412207:54:30[Note]EventScheduler:Loaded0events
8. 1412207:54:30[Note]/usr/local/mysql/bin/mysqld:readyforconnections.
9. Version:‘5.5.34-log’socket:‘/tmp/mysql.sock’port:3306Sourcedistribution
10. 1412207:54:48[Note]/usr/local/mysql/bin/mysqld:Normalshutdown

分析:是/tmp/mysql.sock 不存在

由于mysql 默认的mysql.sock 是在/var/lib/mysql/mysql.sock,创建符号连接.

ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

然后启动mysql,搞定.