求救，Mysql故障启动不了
阿里云服务器启动时候错误代码：
Starting MySQL
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 Plugin 'InnoDB' is disabled.
151119 12:42:26 Server hostname (bind-address): '0.0.0.0'; port: 3306
151119 12:42:26 - '0.0.0.0' resolves to '0.0.0.0';
151119 12:42:26 Server socket created on IP: '0.0.0.0'.
151119 12:42:26 Event Scheduler: Loaded 0 events
151119 12:42:26 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.42-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
151119 12:42:27 /usr/local/mysql/bin/mysqld: Normal shutdown
151119 12:42:27 Event Scheduler: Purging the queue. 0 events
151119 12:42:27 /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 Plugin 'InnoDB' is disabled.
151119 12:42:28 Server hostname (bind-address): '0.0.0.0'; port: 3306
151119 12:42:28 - '0.0.0.0' resolves to '0.0.0.0';
151119 12:42:28 Server socket created on IP: '0.0.0.0'.
151119 12:42:28 Event Scheduler: Loaded 0 events
151119 12:42:28 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.42-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
151119 12:42:29 /usr/local/mysql/bin/mysqld: Normal shutdown
151119 12:42:29 Event Scheduler: Purging the queue. 0 events
151119 12:42:29 /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 Plugin 'InnoDB' is disabled.
151119 12:53:41 Server hostname (bind-address): '0.0.0.0'; port: 3306
151119 12:53:41 - '0.0.0.0' resolves to '0.0.0.0';
151119 12:53:41 Server socket created on IP: '0.0.0.0'.
151119 12:53:41 Event Scheduler: Loaded 0 events
151119 12:53:41 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.42-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
151119 14:24:10 /usr/local/mysql/bin/mysqld: Normal shutdown
151119 14:24:10 Event Scheduler: Purging the queue. 0 events
151119 14:24:10 /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 Plugin 'InnoDB' is disabled.
151119 14:24:12 Server hostname (bind-address): '0.0.0.0'; port: 3306
151119 14:24:12 - '0.0.0.0' resolves to '0.0.0.0';
151119 14:24:12 Server socket created on IP: '0.0.0.0'.
151119 14:24:12 Event Scheduler: Loaded 0 events
151119 14:24:12 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.42-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
151119 14:53:46 /usr/local/mysql/bin/mysqld: Normal shutdown
151119 14:53:46 Event Scheduler: Purging the queue. 0 events
151119 14:53:46 /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 Plugin 'InnoDB' is disabled.
151119 14:53:48 Server hostname (bind-address): '0.0.0.0'; port: 3306
151119 14:53:48 - '0.0.0.0' resolves to '0.0.0.0';
151119 14:53:48 Server socket created on IP: '0.0.0.0'.
151119 14:53:48 Event Scheduler: Loaded 0 events
151119 14:53:48 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.42-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
151119 15:00:49 /usr/local/mysql/bin/mysqld: Normal shutdown
151119 15:00:49 Event Scheduler: Purging the queue. 0 events
151119 15:00:49 /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 Plugin 'InnoDB' is disabled.
151119 15:00:51 Server hostname (bind-address): '0.0.0.0'; port: 3306
151119 15:00:51 - '0.0.0.0' resolves to '0.0.0.0';
151119 15:00:51 Server socket created on IP: '0.0.0.0'.
151119 15:00:51 Event Scheduler: Loaded 0 events
151119 15:00:51 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.42-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
151119 15:55:49 /usr/local/mysql/bin/mysqld: Normal shutdown
151119 15:55:49 Event Scheduler: Purging the queue. 0 events
151119 15:55:49 /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 Plugin 'InnoDB' is disabled.
151119 15:55:51 Server hostname (bind-address): '0.0.0.0'; port: 3306
151119 15:55:51 - '0.0.0.0' resolves to '0.0.0.0';
151119 15:55:51 Server socket created on IP: '0.0.0.0'.
151119 15:55:51 Event Scheduler: Loaded 0 events
151119 15:55:51 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.42-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
160109 13:08:01 /usr/local/mysql/bin/mysqld: Normal shutdown
160109 13:08:01 Event Scheduler: Purging the queue. 0 events
160109 13:08:01 /usr/local/mysql/bin/mysqld: Shutdown complete
160109 13:08:01 mysqld_safe mysqld from pid file /usr/local/mysql/var/iZ94n2rt2brZ.pid ended 这里面没有任何错误信息，按 The server quit without updating PID file (/var/run/mysqld/mysqld.pid 这个看可能又另外安装了mysql或存在其他的配置文件导致的，你可以检查是否多了 /etc/mysql/my.cnf 和 另外的mysl，可以find 命令查找一下看看 找到原因了，谢谢
回复 2# 的帖子
的确是多了 /etc/mysql/my.cnf 这个配置文件，当初安装的时候就是直接一键安装的，并没有再次安装，不知为何会多了一个配置文件。 这个不是lnmp的配置文件，一般都是通过apt-get或yum安装上的回复 5# 的帖子
谢谢军哥，万分感谢...
页:
[1]