VPS侦探论坛

 找回密码
 注册
查看: 4098|回复: 5

求救,Mysql故障启动不了

[复制链接]
发表于 2016-1-11 11:26:06 | 显示全部楼层 |阅读模式

阿里云服务器

启动时候错误代码:
Starting MySQL
[FAIL.] The server quit without updating PID file (/var/run/mysqld/mysqld.pid). ... failed!



日志:151119 12:42:26 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
151119 12:42:26 [Note] Plugin 'InnoDB' is disabled.
151119 12:42:26 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
151119 12:42:26 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
151119 12:42:26 [Note] Server socket created on IP: '0.0.0.0'.
151119 12:42:26 [Note] Event Scheduler: Loaded 0 events
151119 12:42:26 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.42-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
151119 12:42:27 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

151119 12:42:27 [Note] Event Scheduler: Purging the queue. 0 events
151119 12:42:27 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

151119 12:42:27 mysqld_safe mysqld from pid file /usr/local/mysql/var/iZ94n2rt2brZ.pid ended
151119 12:42:28 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
151119 12:42:28 [Note] Plugin 'InnoDB' is disabled.
151119 12:42:28 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
151119 12:42:28 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
151119 12:42:28 [Note] Server socket created on IP: '0.0.0.0'.
151119 12:42:28 [Note] Event Scheduler: Loaded 0 events
151119 12:42:28 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.42-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
151119 12:42:29 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

151119 12:42:29 [Note] Event Scheduler: Purging the queue. 0 events
151119 12:42:29 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

151119 12:42:29 mysqld_safe mysqld from pid file /usr/local/mysql/var/iZ94n2rt2brZ.pid ended
151119 12:53:41 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
151119 12:53:41 [Note] Plugin 'InnoDB' is disabled.
151119 12:53:41 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
151119 12:53:41 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
151119 12:53:41 [Note] Server socket created on IP: '0.0.0.0'.
151119 12:53:41 [Note] Event Scheduler: Loaded 0 events
151119 12:53:41 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.42-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
151119 14:24:10 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

151119 14:24:10 [Note] Event Scheduler: Purging the queue. 0 events
151119 14:24:10 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

151119 14:24:10 mysqld_safe mysqld from pid file /usr/local/mysql/var/iZ94n2rt2brZ.pid ended
151119 14:24:12 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
151119 14:24:12 [Note] Plugin 'InnoDB' is disabled.
151119 14:24:12 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
151119 14:24:12 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
151119 14:24:12 [Note] Server socket created on IP: '0.0.0.0'.
151119 14:24:12 [Note] Event Scheduler: Loaded 0 events
151119 14:24:12 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.42-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
151119 14:53:46 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

151119 14:53:46 [Note] Event Scheduler: Purging the queue. 0 events
151119 14:53:46 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

151119 14:53:46 mysqld_safe mysqld from pid file /usr/local/mysql/var/iZ94n2rt2brZ.pid ended
151119 14:53:48 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
151119 14:53:48 [Note] Plugin 'InnoDB' is disabled.
151119 14:53:48 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
151119 14:53:48 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
151119 14:53:48 [Note] Server socket created on IP: '0.0.0.0'.
151119 14:53:48 [Note] Event Scheduler: Loaded 0 events
151119 14:53:48 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.42-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
151119 15:00:49 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

151119 15:00:49 [Note] Event Scheduler: Purging the queue. 0 events
151119 15:00:49 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

151119 15:00:49 mysqld_safe mysqld from pid file /usr/local/mysql/var/iZ94n2rt2brZ.pid ended
151119 15:00:51 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
151119 15:00:51 [Note] Plugin 'InnoDB' is disabled.
151119 15:00:51 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
151119 15:00:51 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
151119 15:00:51 [Note] Server socket created on IP: '0.0.0.0'.
151119 15:00:51 [Note] Event Scheduler: Loaded 0 events
151119 15:00:51 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.42-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
151119 15:55:49 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

151119 15:55:49 [Note] Event Scheduler: Purging the queue. 0 events
151119 15:55:49 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

151119 15:55:49 mysqld_safe mysqld from pid file /usr/local/mysql/var/iZ94n2rt2brZ.pid ended
151119 15:55:51 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
151119 15:55:51 [Note] Plugin 'InnoDB' is disabled.
151119 15:55:51 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
151119 15:55:51 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
151119 15:55:51 [Note] Server socket created on IP: '0.0.0.0'.
151119 15:55:51 [Note] Event Scheduler: Loaded 0 events
151119 15:55:51 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.42-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
160109 13:08:01 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

160109 13:08:01 [Note] Event Scheduler: Purging the queue. 0 events
160109 13:08:01 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

160109 13:08:01 mysqld_safe mysqld from pid file /usr/local/mysql/var/iZ94n2rt2brZ.pid ended
美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2016-1-11 11:54:05 | 显示全部楼层


这里面没有任何错误信息,按[FAIL.] The server quit without updating PID file (/var/run/mysqld/mysqld.pid 这个看可能又另外安装了mysql或存在其他的配置文件导致的,你可以检查是否多了 /etc/mysql/my.cnf 和 另外的mysl,可以find 命令查找一下看看
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
 楼主| 发表于 2016-1-11 12:00:05 | 显示全部楼层

找到原因了,谢谢
美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
 楼主| 发表于 2016-1-11 12:01:53 | 显示全部楼层

回复 2# 的帖子




的确是多了 /etc/mysql/my.cnf 这个配置文件,当初安装的时候就是直接一键安装的,并没有再次安装,不知为何会多了一个配置文件。
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
发表于 2016-1-11 13:53:03 | 显示全部楼层

这个不是lnmp的配置文件,一般都是通过apt-get或yum安装上的

军哥运维代购:http://shop63846532.taobao.com/

 楼主| 发表于 2016-1-11 15:58:19 | 显示全部楼层

回复 5# 的帖子


谢谢军哥,万分感谢...
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|VPS侦探 ( 鲁ICP备16040043号-1 )

GMT+8, 2024-9-28 19:25 , Processed in 0.026737 second(s), 17 queries .

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

快速回复 返回顶部 返回列表