下文来为各位介绍解决mysqld_safe无法启动问题的方法,如果你碰到mysqld safe无法启动问题可以进入本站来参考解决方案.
启动mysql时报错:
- 14122007:50:59mysqld_safemysqldfrompidfile/usr/local/mysql/data/vps.cbo999.com.pidended
- 14122007:54:30mysqld_safeStartingmysqlddaemonwithdatabasesfrom/usr/local/mysql/data--phpfensi.com
- 1412207:54:30[Note]Plugin‘InnoDB’isdisabled.
- 1412207:54:30[Note]Serverhostname(bind-address):‘0.0.0.0’;port:3306
- 1412207:54:30[Note]–‘0.0.0.0’resolvesto‘0.0.0.0’;
- 1412207:54:30[Note]ServersocketcreatedonIP:‘0.0.0.0’.
- 1412207:54:30[Note]EventScheduler:Loaded0events
- 1412207:54:30[Note]/usr/local/mysql/bin/mysqld:readyforconnections.
- Version:‘5.5.34-log’socket:‘/tmp/mysql.sock’port:3306Sourcedistribution
- 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,搞定.