zengyuhua 发表于 2017-10-16 22:52:42

【已按照置顶帖要求 Mysql问题】ERROR! MySQL server PID file could not be found!

1. ERR 日志如下：
# cat localhost.localdomain.err
170901 14:07:27 Plugin 'FEDERATED' is disabled.
170901 14:07:27 Plugin 'InnoDB' is disabled.
170901 14:07:27 Server hostname (bind-address): '0.0.0.0'; port: 3306
170901 14:07:27    - '0.0.0.0' resolves to '0.0.0.0';
170901 14:07:27 Server socket created on IP: '0.0.0.0'.
170901 14:07:27 Event Scheduler: Loaded 0 events
170901 14:07:27 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.56-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
170901 14:07:28 /usr/local/mysql/bin/mysqld: Normal shutdown

170901 14:07:28 Event Scheduler: Purging the queue. 0 events
170901 14:07:28 /usr/local/mysql/bin/mysqld: Shutdown complete

170901 14:07:29 Plugin 'FEDERATED' is disabled.
170901 14:07:29 Plugin 'InnoDB' is disabled.
170901 14:07:29 Server hostname (bind-address): '0.0.0.0'; port: 3306
170901 14:07:29    - '0.0.0.0' resolves to '0.0.0.0';
170901 14:07:29 Server socket created on IP: '0.0.0.0'.
170901 14:07:29 Event Scheduler: Loaded 0 events
170901 14:07:29 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.56-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
170901 14:07:30 /usr/local/mysql/bin/mysqld: Normal shutdown

170901 14:07:30 Event Scheduler: Purging the queue. 0 events
170901 14:07:30 /usr/local/mysql/bin/mysqld: Shutdown complete

170901 14:07:31 Plugin 'FEDERATED' is disabled.
170901 14:07:31 Plugin 'InnoDB' is disabled.
170901 14:07:31 Server hostname (bind-address): '0.0.0.0'; port: 3306
170901 14:07:31    - '0.0.0.0' resolves to '0.0.0.0';
170901 14:07:31 Server socket created on IP: '0.0.0.0'.
170901 14:07:31 Event Scheduler: Loaded 0 events
170901 14:07:31 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.56-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
170901 14:07:32 /usr/local/mysql/bin/mysqld: Normal shutdown

170901 14:07:32 Event Scheduler: Purging the queue. 0 events
170901 14:07:32 /usr/local/mysql/bin/mysqld: Shutdown complete

170901 14:23:29 Plugin 'FEDERATED' is disabled.
170901 14:23:29 Plugin 'InnoDB' is disabled.
170901 14:23:29 Server hostname (bind-address): '0.0.0.0'; port: 3306
170901 14:23:29    - '0.0.0.0' resolves to '0.0.0.0';
170901 14:23:29 Server socket created on IP: '0.0.0.0'.
170901 14:23:29 Event Scheduler: Loaded 0 events
170901 14:23:29 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.56-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
170901 17:00:11 /usr/local/mysql/bin/mysqld: Normal shutdown

170901 17:00:11 Event Scheduler: Purging the queue. 0 events
170901 17:00:11 /usr/local/mysql/bin/mysqld: Shutdown complete

170901 17:00:13 Plugin 'FEDERATED' is disabled.
170901 17:00:13 Plugin 'InnoDB' is disabled.
170901 17:00:13 Server hostname (bind-address): '0.0.0.0'; port: 3306
170901 17:00:13    - '0.0.0.0' resolves to '0.0.0.0';
170901 17:00:13 Server socket created on IP: '0.0.0.0'.
170901 17:00:13 Event Scheduler: Loaded 0 events
170901 17:00:13 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.56-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
170925 21:10:22 /usr/local/mysql/bin/mysqld: Normal shutdown

170925 21:10:22 Event Scheduler: Purging the queue. 0 events
170925 21:10:22 /usr/local/mysql/bin/mysqld: Shutdown complete

170925 21:10:30 Plugin 'FEDERATED' is disabled.
170925 21:10:30 Plugin 'InnoDB' is disabled.
170925 21:10:30 Server hostname (bind-address): '0.0.0.0'; port: 3306
170925 21:10:30    - '0.0.0.0' resolves to '0.0.0.0';
170925 21:10:30 Server socket created on IP: '0.0.0.0'.
170925 21:10:30 Event Scheduler: Loaded 0 events
170925 21:10:30 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.56-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
170925 21:52:29 /usr/local/mysql/bin/mysqld: Normal shutdown

170925 21:52:29 Event Scheduler: Purging the queue. 0 events
170925 21:52:29 /usr/local/mysql/bin/mysqld: Shutdown complete




2.一开机后的 lnmp status如附件1

求军哥 解答 谢谢

licess 发表于 2017-10-17 12:08:48

可能有通过apt-get或yum安装的mysql包，参考：https://bbs.vpser.net/thread-15119-1-1.html 进行查询
然后卸载一般就可以了

zengyuhua 发表于 2017-10-18 15:25:43

查mysql没有 ，查sql 就有一个 包

# rpm -qa | grep sql
sqlite-3.6.20-1.el6.x86_64

这个东西 能删掉吗》？

licess 发表于 2017-10-18 20:29:48

回复 3# 的帖子

和sqlite没关系，你mysql日志都是之前的，发一下现在的

再执行 find / -name my.cnf 看一下

zengyuhua 发表于 2017-10-18 20:42:46

现在的 ERR日志 和

170901 14:07:27 Plugin 'FEDERATED' is disabled.
170901 14:07:27 Plugin 'InnoDB' is disabled.
170901 14:07:27 Server hostname (bind-address): '0.0.0.0'; port: 3306
170901 14:07:27    - '0.0.0.0' resolves to '0.0.0.0';
170901 14:07:27 Server socket created on IP: '0.0.0.0'.
170901 14:07:27 Event Scheduler: Loaded 0 events
170901 14:07:27 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.56-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
170901 14:07:28 /usr/local/mysql/bin/mysqld: Normal shutdown

170901 14:07:28 Event Scheduler: Purging the queue. 0 events
170901 14:07:28 /usr/local/mysql/bin/mysqld: Shutdown complete

170901 14:07:29 Plugin 'FEDERATED' is disabled.
170901 14:07:29 Plugin 'InnoDB' is disabled.
170901 14:07:29 Server hostname (bind-address): '0.0.0.0'; port: 3306
170901 14:07:29    - '0.0.0.0' resolves to '0.0.0.0';
170901 14:07:29 Server socket created on IP: '0.0.0.0'.
170901 14:07:29 Event Scheduler: Loaded 0 events
170901 14:07:29 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.56-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
170901 14:07:30 /usr/local/mysql/bin/mysqld: Normal shutdown

170901 14:07:30 Event Scheduler: Purging the queue. 0 events
170901 14:07:30 /usr/local/mysql/bin/mysqld: Shutdown complete

170901 14:07:31 Plugin 'FEDERATED' is disabled.
170901 14:07:31 Plugin 'InnoDB' is disabled.
170901 14:07:31 Server hostname (bind-address): '0.0.0.0'; port: 3306
170901 14:07:31    - '0.0.0.0' resolves to '0.0.0.0';
170901 14:07:31 Server socket created on IP: '0.0.0.0'.
170901 14:07:31 Event Scheduler: Loaded 0 events
170901 14:07:31 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.56-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
170901 14:07:32 /usr/local/mysql/bin/mysqld: Normal shutdown

170901 14:07:32 Event Scheduler: Purging the queue. 0 events
170901 14:07:32 /usr/local/mysql/bin/mysqld: Shutdown complete

170901 14:23:29 Plugin 'FEDERATED' is disabled.
170901 14:23:29 Plugin 'InnoDB' is disabled.
170901 14:23:29 Server hostname (bind-address): '0.0.0.0'; port: 3306
170901 14:23:29    - '0.0.0.0' resolves to '0.0.0.0';
170901 14:23:29 Server socket created on IP: '0.0.0.0'.
170901 14:23:29 Event Scheduler: Loaded 0 events
170901 14:23:29 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.56-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
170901 17:00:11 /usr/local/mysql/bin/mysqld: Normal shutdown

170901 17:00:11 Event Scheduler: Purging the queue. 0 events
170901 17:00:11 /usr/local/mysql/bin/mysqld: Shutdown complete

170901 17:00:13 Plugin 'FEDERATED' is disabled.
170901 17:00:13 Plugin 'InnoDB' is disabled.
170901 17:00:13 Server hostname (bind-address): '0.0.0.0'; port: 3306
170901 17:00:13    - '0.0.0.0' resolves to '0.0.0.0';
170901 17:00:13 Server socket created on IP: '0.0.0.0'.
170901 17:00:13 Event Scheduler: Loaded 0 events
170901 17:00:13 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.56-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
170925 21:10:22 /usr/local/mysql/bin/mysqld: Normal shutdown

170925 21:10:22 Event Scheduler: Purging the queue. 0 events
170925 21:10:22 /usr/local/mysql/bin/mysqld: Shutdown complete

170925 21:10:30 Plugin 'FEDERATED' is disabled.
170925 21:10:30 Plugin 'InnoDB' is disabled.
170925 21:10:30 Server hostname (bind-address): '0.0.0.0'; port: 3306
170925 21:10:30    - '0.0.0.0' resolves to '0.0.0.0';
170925 21:10:30 Server socket created on IP: '0.0.0.0'.
170925 21:10:30 Event Scheduler: Loaded 0 events
170925 21:10:30 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.56-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
170925 21:52:29 /usr/local/mysql/bin/mysqld: Normal shutdown

170925 21:52:29 Event Scheduler: Purging the queue. 0 events
170925 21:52:29 /usr/local/mysql/bin/mysqld: Shutdown complete




执行find / -name my.cnf结果如下：
# find / -name my.cnf
/root/amh/modules/mysql-generic-5.5/my.cnf
/usr/local/mysql-generic-5.5/mysql-test/suite/federated/my.cnf
/usr/local/mysql-generic-5.5/mysql-test/suite/rpl/my.cnf
/usr/local/mysql-generic-5.5/my.cnf
/usr/local/mysql/mysql-test/suite/federated/my.cnf
/usr/local/mysql/mysql-test/suite/rpl/my.cnf

zengyuhua 发表于 2017-10-18 20:43:40

回复 4# 的帖子

现在的 ERR日志 和

170901 14:07:27 Plugin 'FEDERATED' is disabled.
170901 14:07:27 Plugin 'InnoDB' is disabled.
170901 14:07:27 Server hostname (bind-address): '0.0.0.0'; port: 3306
170901 14:07:27    - '0.0.0.0' resolves to '0.0.0.0';
170901 14:07:27 Server socket created on IP: '0.0.0.0'.
170901 14:07:27 Event Scheduler: Loaded 0 events
170901 14:07:27 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.56-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
170901 14:07:28 /usr/local/mysql/bin/mysqld: Normal shutdown

170901 14:07:28 Event Scheduler: Purging the queue. 0 events
170901 14:07:28 /usr/local/mysql/bin/mysqld: Shutdown complete

170901 14:07:29 Plugin 'FEDERATED' is disabled.
170901 14:07:29 Plugin 'InnoDB' is disabled.
170901 14:07:29 Server hostname (bind-address): '0.0.0.0'; port: 3306
170901 14:07:29    - '0.0.0.0' resolves to '0.0.0.0';
170901 14:07:29 Server socket created on IP: '0.0.0.0'.
170901 14:07:29 Event Scheduler: Loaded 0 events
170901 14:07:29 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.56-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
170901 14:07:30 /usr/local/mysql/bin/mysqld: Normal shutdown

170901 14:07:30 Event Scheduler: Purging the queue. 0 events
170901 14:07:30 /usr/local/mysql/bin/mysqld: Shutdown complete

170901 14:07:31 Plugin 'FEDERATED' is disabled.
170901 14:07:31 Plugin 'InnoDB' is disabled.
170901 14:07:31 Server hostname (bind-address): '0.0.0.0'; port: 3306
170901 14:07:31    - '0.0.0.0' resolves to '0.0.0.0';
170901 14:07:31 Server socket created on IP: '0.0.0.0'.
170901 14:07:31 Event Scheduler: Loaded 0 events
170901 14:07:31 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.56-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
170901 14:07:32 /usr/local/mysql/bin/mysqld: Normal shutdown

170901 14:07:32 Event Scheduler: Purging the queue. 0 events
170901 14:07:32 /usr/local/mysql/bin/mysqld: Shutdown complete

170901 14:23:29 Plugin 'FEDERATED' is disabled.
170901 14:23:29 Plugin 'InnoDB' is disabled.
170901 14:23:29 Server hostname (bind-address): '0.0.0.0'; port: 3306
170901 14:23:29    - '0.0.0.0' resolves to '0.0.0.0';
170901 14:23:29 Server socket created on IP: '0.0.0.0'.
170901 14:23:29 Event Scheduler: Loaded 0 events
170901 14:23:29 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.56-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
170901 17:00:11 /usr/local/mysql/bin/mysqld: Normal shutdown

170901 17:00:11 Event Scheduler: Purging the queue. 0 events
170901 17:00:11 /usr/local/mysql/bin/mysqld: Shutdown complete

170901 17:00:13 Plugin 'FEDERATED' is disabled.
170901 17:00:13 Plugin 'InnoDB' is disabled.
170901 17:00:13 Server hostname (bind-address): '0.0.0.0'; port: 3306
170901 17:00:13    - '0.0.0.0' resolves to '0.0.0.0';
170901 17:00:13 Server socket created on IP: '0.0.0.0'.
170901 17:00:13 Event Scheduler: Loaded 0 events
170901 17:00:13 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.56-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
170925 21:10:22 /usr/local/mysql/bin/mysqld: Normal shutdown

170925 21:10:22 Event Scheduler: Purging the queue. 0 events
170925 21:10:22 /usr/local/mysql/bin/mysqld: Shutdown complete

170925 21:10:30 Plugin 'FEDERATED' is disabled.
170925 21:10:30 Plugin 'InnoDB' is disabled.
170925 21:10:30 Server hostname (bind-address): '0.0.0.0'; port: 3306
170925 21:10:30    - '0.0.0.0' resolves to '0.0.0.0';
170925 21:10:30 Server socket created on IP: '0.0.0.0'.
170925 21:10:30 Event Scheduler: Loaded 0 events
170925 21:10:30 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.56-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
170925 21:52:29 /usr/local/mysql/bin/mysqld: Normal shutdown

170925 21:52:29 Event Scheduler: Purging the queue. 0 events
170925 21:52:29 /usr/local/mysql/bin/mysqld: Shutdown complete




执行find / -name my.cnf结果如下：
# find / -name my.cnf
/root/amh/modules/mysql-generic-5.5/my.cnf
/usr/local/mysql-generic-5.5/mysql-test/suite/federated/my.cnf
/usr/local/mysql-generic-5.5/mysql-test/suite/rpl/my.cnf
/usr/local/mysql-generic-5.5/my.cnf
/usr/local/mysql/mysql-test/suite/federated/my.cnf
/usr/local/mysql/mysql-test/suite/rpl/my.cnf

zengyuhua 发表于 2017-10-18 20:51:53

回复 4# 的帖子 这是我 lnmp restart 之后的新日志

# cat localhost.localdomain.err
170901 14:07:27 Plugin 'FEDERATED' is disabled.
170901 14:07:27 Plugin 'InnoDB' is disabled.
170901 14:07:27 Server hostname (bind-address): '0.0.0.0'; port: 3306
170901 14:07:27    - '0.0.0.0' resolves to '0.0.0.0';
170901 14:07:27 Server socket created on IP: '0.0.0.0'.
170901 14:07:27 Event Scheduler: Loaded 0 events
170901 14:07:27 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.56-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
170901 14:07:28 /usr/local/mysql/bin/mysqld: Normal shutdown

170901 14:07:28 Event Scheduler: Purging the queue. 0 events
170901 14:07:28 /usr/local/mysql/bin/mysqld: Shutdown complete

170901 14:07:29 Plugin 'FEDERATED' is disabled.
170901 14:07:29 Plugin 'InnoDB' is disabled.
170901 14:07:29 Server hostname (bind-address): '0.0.0.0'; port: 3306
170901 14:07:29    - '0.0.0.0' resolves to '0.0.0.0';
170901 14:07:29 Server socket created on IP: '0.0.0.0'.
170901 14:07:29 Event Scheduler: Loaded 0 events
170901 14:07:29 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.56-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
170901 14:07:30 /usr/local/mysql/bin/mysqld: Normal shutdown

170901 14:07:30 Event Scheduler: Purging the queue. 0 events
170901 14:07:30 /usr/local/mysql/bin/mysqld: Shutdown complete

170901 14:07:31 Plugin 'FEDERATED' is disabled.
170901 14:07:31 Plugin 'InnoDB' is disabled.
170901 14:07:31 Server hostname (bind-address): '0.0.0.0'; port: 3306
170901 14:07:31    - '0.0.0.0' resolves to '0.0.0.0';
170901 14:07:31 Server socket created on IP: '0.0.0.0'.
170901 14:07:31 Event Scheduler: Loaded 0 events
170901 14:07:31 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.56-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
170901 14:07:32 /usr/local/mysql/bin/mysqld: Normal shutdown

170901 14:07:32 Event Scheduler: Purging the queue. 0 events
170901 14:07:32 /usr/local/mysql/bin/mysqld: Shutdown complete

170901 14:23:29 Plugin 'FEDERATED' is disabled.
170901 14:23:29 Plugin 'InnoDB' is disabled.
170901 14:23:29 Server hostname (bind-address): '0.0.0.0'; port: 3306
170901 14:23:29    - '0.0.0.0' resolves to '0.0.0.0';
170901 14:23:29 Server socket created on IP: '0.0.0.0'.
170901 14:23:29 Event Scheduler: Loaded 0 events
170901 14:23:29 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.56-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
170901 17:00:11 /usr/local/mysql/bin/mysqld: Normal shutdown

170901 17:00:11 Event Scheduler: Purging the queue. 0 events
170901 17:00:11 /usr/local/mysql/bin/mysqld: Shutdown complete

170901 17:00:13 Plugin 'FEDERATED' is disabled.
170901 17:00:13 Plugin 'InnoDB' is disabled.
170901 17:00:13 Server hostname (bind-address): '0.0.0.0'; port: 3306
170901 17:00:13    - '0.0.0.0' resolves to '0.0.0.0';
170901 17:00:13 Server socket created on IP: '0.0.0.0'.
170901 17:00:13 Event Scheduler: Loaded 0 events
170901 17:00:13 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.56-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
170925 21:10:22 /usr/local/mysql/bin/mysqld: Normal shutdown

170925 21:10:22 Event Scheduler: Purging the queue. 0 events
170925 21:10:22 /usr/local/mysql/bin/mysqld: Shutdown complete

170925 21:10:30 Plugin 'FEDERATED' is disabled.
170925 21:10:30 Plugin 'InnoDB' is disabled.
170925 21:10:30 Server hostname (bind-address): '0.0.0.0'; port: 3306
170925 21:10:30    - '0.0.0.0' resolves to '0.0.0.0';
170925 21:10:30 Server socket created on IP: '0.0.0.0'.
170925 21:10:30 Event Scheduler: Loaded 0 events
170925 21:10:30 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.56-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
170925 21:52:29 /usr/local/mysql/bin/mysqld: Normal shutdown

170925 21:52:29 Event Scheduler: Purging the queue. 0 events
170925 21:52:29 /usr/local/mysql/bin/mysqld: Shutdown complete

zengyuhua 发表于 2017-10-19 09:34:36

补一个图

这是安装了一个 AMH的面板，给我这个提示

licess 发表于 2017-10-19 13:11:25

回复 7# 的帖子

你自己没发现你发几次的日志连时间都一样
2个月前的日志没错误信息
页: [1]
查看完整版本: 【已按照置顶帖要求 Mysql问题】ERROR! MySQL server PID file could not be found!