MySQL启动错误ERROR! MySQL server PID file could not be found的解决办法 - 推酷
MySQL启动错误ERROR! MySQL server PID file could not be found的解决办法
/etc/init.d/mysql start无法启动
mysql错误信息如下：
ERROR! MySQL server PID file could not be found!
Starting MySQL.. ERROR! The server quit without updating PID file (/usr/local/mysql/var/AYXXXXXXXXXXX.pid).&
完整日志信息如下：
:11:33 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
:11:33 InnoDB: The InnoDB memory heap is disabled
:11:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins
:11:33 InnoDB: Compressed tables use zlib 1.2.3
:11:33 InnoDB: Initializing buffer pool, size = 16.0M
:11:33 InnoDB: Completed initialization of buffer pool
:11:33 InnoDB: highest supported file format is Barracuda.
InnoDB: Waiting for the background threads to start
:11:34 InnoDB: 5.5.37 log sequence number
/usr/local/mysql/bin/mysqld: File './mysql-bin.000035' not found (Errcode: 2)
:11:34 [ERROR] Failed to open log (file './mysql-bin.000035', errno 2)
:11:34 [ERROR] Could not open log file
:11:34 [ERROR] Can't init tc log
:11:34 [ERROR] Aborting
InnoDB: Starting shutdown...
InnoDB: S log sequence number
:11:35 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
:11:35 mysqld_safe mysqld from pid file /usr/local/mysql/var/AYZ.pid ended
:12:55 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
:12:56 InnoDB: The InnoDB memory heap is disabled
:12:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins
:12:56 InnoDB: Compressed tables use zlib 1.2.3
:12:56 InnoDB: Initializing buffer pool, size = 16.0M
:12:56 InnoDB: Completed initialization of buffer pool
:12:56 InnoDB: highest supported file format is Barracuda.
InnoDB: Waiting for the background threads to start
:12:58 InnoDB: 5.5.37 log sequence number
/usr/local/mysql/bin/mysqld: File './mysql-bin.000035' not found (Errcode: 2)
:12:58 [ERROR] Failed to open log (file './mysql-bin.000035', errno 2)
:12:58 [ERROR] Could not open log file
:12:58 [ERROR] Can't init tc log
:12:58 [ERROR] Aborting
InnoDB: Starting shutdown...
InnoDB: S log sequence number
:12:58 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
:12:58 mysqld_safe mysqld from pid file /usr/local/mysql/var/AYZ.pid ended
:30:59 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
:30:59 InnoDB: The InnoDB memory heap is disabled
:30:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins
:30:59 InnoDB: Compressed tables use zlib 1.2.3
:30:59 InnoDB: Initializing buffer pool, size = 16.0M
:30:59 InnoDB: Completed initialization of buffer pool
:30:59 InnoDB: highest supported file format is Barracuda.
InnoDB: Waiting for the background threads to start
:31:01 InnoDB: 5.5.37 log sequence number
/usr/local/mysql/bin/mysqld: File './mysql-bin.000035' not found (Errcode: 2)
:31:01 [ERROR] Failed to open log (file './mysql-bin.000035', errno 2)
:31:01 [ERROR] Could not open log file
:31:01 [ERROR] Can't init tc log
:31:01 [ERROR] Aborting
InnoDB: Starting shutdown...
InnoDB: S log sequence number
:31:01 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
:31:01 mysqld_safe mysqld from pid file /usr/local/mysql/var/AYZ.pid ended
:32:10 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
:32:10 InnoDB: The InnoDB memory heap is disabled
:32:10 InnoDB: Mutexes and rw_locks use GCC atomic builtins
:32:10 InnoDB: Compressed tables use zlib 1.2.3
:32:10 InnoDB: Initializing buffer pool, size = 16.0M
:32:10 InnoDB: Completed initialization of buffer pool
:32:10 InnoDB: highest supported file format is Barracuda.
InnoDB: Waiting for the background threads to start
:32:11 InnoDB: 5.5.37 log sequence number
/usr/local/mysql/bin/mysqld: File './mysql-bin.000035' not found (Errcode: 2)
:32:11 [ERROR] Failed to open log (file './mysql-bin.000035', errno 2)
:32:11 [ERROR] Could not open log file
:32:11 [ERROR] Can't init tc log
:32:11 [ERROR] Aborting
InnoDB: Starting shutdown...
InnoDB: S log sequence number
:32:11 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
:32:11 mysqld_safe mysqld from pid file /usr/local/mysql/var/AYZ.pid ended
:32:14 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
:32:14 InnoDB: The InnoDB memory heap is disabled
:32:14 InnoDB: Mutexes and rw_locks use GCC atomic builtins
:32:14 InnoDB: Compressed tables use zlib 1.2.3
:32:14 InnoDB: Initializing buffer pool, size = 16.0M
:32:14 InnoDB: Completed initialization of buffer pool
:32:14 InnoDB: highest supported file format is Barracuda.
InnoDB: Waiting for the background threads to start
:32:15 InnoDB: 5.5.37 log sequence number
/usr/local/mysql/bin/mysqld: File './mysql-bin.000035' not found (Errcode: 2)
:32:15 [ERROR] Failed to open log (file './mysql-bin.000035', errno 2)
:32:15 [ERROR] Could not open log file
:32:15 [ERROR] Can't init tc log
:32:15 [ERROR] Aborting
InnoDB: Starting shutdown...
InnoDB: S log sequence number
:32:15 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
:32:15 mysqld_safe mysqld from pid file /usr/local/mysql/var/AYZ.pid ended
:33:15 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
:33:15 InnoDB: The InnoDB memory heap is disabled
:33:15 InnoDB: Mutexes and rw_locks use GCC atomic builtins
:33:15 InnoDB: Compressed tables use zlib 1.2.3
:33:15 InnoDB: Initializing buffer pool, size = 16.0M
:33:15 InnoDB: Completed initialization of buffer pool
:33:15 InnoDB: highest supported file format is Barracuda.
InnoDB: Waiting for the background threads to start
:33:16 InnoDB: 5.5.37 log sequence number
/usr/local/mysql/bin/mysqld: File './mysql-bin.000035' not found (Errcode: 2)
:33:16 [ERROR] Failed to open log (file './mysql-bin.000035', errno 2)
:33:16 [ERROR] Could not open log file
:33:16 [ERROR] Can't init tc log
:33:16 [ERROR] Aborting
InnoDB: Starting shutdown...
InnoDB: S log sequence number
:33:17 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
:33:17 mysqld_safe mysqld from pid file /usr/local/mysql/var/AYZ.pid ended
:34:05 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
:34:05 [Warning] You need to use --log-bin to make --binlog-format work.
:34:05 InnoDB: The InnoDB memory heap is disabled
:34:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins
:34:05 InnoDB: Compressed tables use zlib 1.2.3
:34:05 InnoDB: Initializing buffer pool, size = 16.0M
:34:05 InnoDB: Completed initialization of buffer pool
:34:05 InnoDB: highest supported file format is Barracuda.
InnoDB: Waiting for the background threads to start
:34:06 InnoDB: 5.5.37 log sequence number
:34:06 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
:34:06 [Note]
- '0.0.0.0' resolves to '0.0.0.0';
:34:06 [Note] Server socket created on IP: '0.0.0.0'.
:34:07 [Note] Event Scheduler: Loaded 0 events
:34:07 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.37'
socket: '/tmp/mysql.sock'
port: 3306
Source distribution
:34:30 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown
:34:30 [Note] Event Scheduler: Purging the queue. 0 events
InnoDB: Starting shutdown...
InnoDB: S log sequence number
:34:30 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
:34:30 mysqld_safe mysqld from pid file /usr/local/mysql/var/AYZ.pid ended
:34:31 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
:34:31 [Warning] You need to use --log-bin to make --binlog-format work.
:34:31 InnoDB: The InnoDB memory heap is disabled
:34:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins
:34:31 InnoDB: Compressed tables use zlib 1.2.3
:34:31 InnoDB: Initializing buffer pool, size = 16.0M
:34:31 InnoDB: Completed initialization of buffer pool
:34:31 InnoDB: highest supported file format is Barracuda.
InnoDB: Waiting for the background threads to start
:34:32 InnoDB: 5.5.37 log sequence number
:34:32 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
:34:32 [Note]
- '0.0.0.0' resolves to '0.0.0.0';
:34:32 [Note] Server socket created on IP: '0.0.0.0'.
:34:32 [Note] Event Scheduler: Loaded 0 events
:34:32 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.37'
socket: '/tmp/mysql.sock'
port: 3306
Source distribution
启动会报错Starting MySQL.. ERROR! The server quit without updating PID file (/var/local/mysql/var/AYxxxxxxx.pid)原因是因为 mysql-bin.0000*的文件占满系统盘，磁盘空间不足导致无法写入。
解决方法：
1：删除所有
mysql-bin.0000*
日志文件全部rm掉
2：修改在my.cnf 文件，找到 log-bin=mysql-bin 将其启注释掉，以后就不会产生2进制的mysql-bin.0000*的日志文件
已发表评论数()
请填写推刊名
描述不能大于100个字符!
权限设置： 公开
仅自己可见
正文不准确
标题不准确
排版有问题
主题不准确
没有分页内容
图片无法显示
视频无法显示
与原文不一致MySQL启动错误ERROR! MySQL server PID file could not be found的解决办法
/etc/init.d/mysql start无法启动mysql错误信息如下：ERROR! MySQL server PID file could not be found!Starting MySQL.. ERROR! The server quit without updating PID file (/usr/local/mysql/var/AYXXXXXXXXXXX.pid).&完整日志信息如下：:11:33 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var:11:33 InnoDB: The InnoDB memory heap is disabled:11:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins:11:33 InnoDB: Compressed tables use zlib 1.2.:11:33 InnoDB: Initializing buffer pool, size = 16.0M:11:33 InnoDB: Completed initialization of buffer pool:11:33 InnoDB: highest supported file format is Barracuda.:11:33InnoDB: Waiting for the background threads to start:11:34 InnoDB: 5.5.37 log sequence number /usr/local/mysql/bin/mysqld: File './mysql-bin.000035' not found (Errcode: 2):11:34 [ERROR] Failed to open log (file './mysql-bin.000035', errno 2):11:34 [ERROR] Could not open log file:11:34 [ERROR] Can't init tc log:11:34 [ERROR] Aborting:11:34InnoDB: Starting shutdown...:11:35InnoDB: S log sequence number :35 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete:11:35 mysqld_safe mysqld from pid file /usr/local/mysql/var/AYZ.pid ended:12:55 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var:12:56 InnoDB: The InnoDB memory heap is disabled:12:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins:12:56 InnoDB: Compressed tables use zlib 1.2.:12:56 InnoDB: Initializing buffer pool, size = 16.0M:12:56 InnoDB: Completed initialization of buffer pool:12:56 InnoDB: highest supported file format is Barracuda.:12:57InnoDB: Waiting for the background threads to start:12:58 InnoDB: 5.5.37 log sequence number /usr/local/mysql/bin/mysqld: File './mysql-bin.000035' not found (Errcode: 2):12:58 [ERROR] Failed to open log (file './mysql-bin.000035', errno 2):12:58 [ERROR] Could not open log file:12:58 [ERROR] Can't init tc log:12:58 [ERROR] Aborting:12:58InnoDB: Starting shutdown...:12:58InnoDB: S log sequence number :58 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete:12:58 mysqld_safe mysqld from pid file /usr/local/mysql/var/AYZ.pid ended:30:59 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var:30:59 InnoDB: The InnoDB memory heap is disabled:30:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins:30:59 InnoDB: Compressed tables use zlib 1.2.:30:59 InnoDB: Initializing buffer pool, size = 16.0M:30:59 InnoDB: Completed initialization of buffer pool:30:59 InnoDB: highest supported file format is Barracuda.:31:00InnoDB: Waiting for the background threads to start:31:01 InnoDB: 5.5.37 log sequence number /usr/local/mysql/bin/mysqld: File './mysql-bin.000035' not found (Errcode: 2):31:01 [ERROR] Failed to open log (file './mysql-bin.000035', errno 2):31:01 [ERROR] Could not open log file:31:01 [ERROR] Can't init tc log:31:01 [ERROR] Aborting:31:01InnoDB: Starting shutdown...:31:01InnoDB: S log sequence number :01 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete:31:01 mysqld_safe mysqld from pid file /usr/local/mysql/var/AYZ.pid ended:32:10 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var:32:10 InnoDB: The InnoDB memory heap is disabled:32:10 InnoDB: Mutexes and rw_locks use GCC atomic builtins:32:10 InnoDB: Compressed tables use zlib 1.2.:32:10 InnoDB: Initializing buffer pool, size = 16.0M:32:10 InnoDB: Completed initialization of buffer pool:32:10 InnoDB: highest supported file format is Barracuda.:32:10InnoDB: Waiting for the background threads to start:32:11 InnoDB: 5.5.37 log sequence number /usr/local/mysql/bin/mysqld: File './mysql-bin.000035' not found (Errcode: 2):32:11 [ERROR] Failed to open log (file './mysql-bin.000035', errno 2):32:11 [ERROR] Could not open log file:32:11 [ERROR] Can't init tc log:32:11 [ERROR] Aborting:32:11InnoDB: Starting shutdown...:32:11InnoDB: S log sequence number :11 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete:32:11 mysqld_safe mysqld from pid file /usr/local/mysql/var/AYZ.pid ended:32:14 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var:32:14 InnoDB: The InnoDB memory heap is disabled:32:14 InnoDB: Mutexes and rw_locks use GCC atomic builtins:32:14 InnoDB: Compressed tables use zlib 1.2.:32:14 InnoDB: Initializing buffer pool, size = 16.0M:32:14 InnoDB: Completed initialization of buffer pool:32:14 InnoDB: highest supported file format is Barracuda.:32:14InnoDB: Waiting for the background threads to start:32:15 InnoDB: 5.5.37 log sequence number /usr/local/mysql/bin/mysqld: File './mysql-bin.000035' not found (Errcode: 2):32:15 [ERROR] Failed to open log (file './mysql-bin.000035', errno 2):32:15 [ERROR] Could not open log file:32:15 [ERROR] Can't init tc log:32:15 [ERROR] Aborting:32:15InnoDB: Starting shutdown...:32:15InnoDB: S log sequence number :15 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete:32:15 mysqld_safe mysqld from pid file /usr/local/mysql/var/AYZ.pid ended:33:15 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var:33:15 InnoDB: The InnoDB memory heap is disabled:33:15 InnoDB: Mutexes and rw_locks use GCC atomic builtins:33:15 InnoDB: Compressed tables use zlib 1.2.:33:15 InnoDB: Initializing buffer pool, size = 16.0M:33:15 InnoDB: Completed initialization of buffer pool:33:15 InnoDB: highest supported file format is Barracuda.:33:15InnoDB: Waiting for the background threads to start:33:16 InnoDB: 5.5.37 log sequence number /usr/local/mysql/bin/mysqld: File './mysql-bin.000035' not found (Errcode: 2):33:16 [ERROR] Failed to open log (file './mysql-bin.000035', errno 2):33:16 [ERROR] Could not open log file:33:16 [ERROR] Can't init tc log:33:16 [ERROR] Aborting:33:16InnoDB: Starting shutdown...:33:17InnoDB: S log sequence number :17 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete:33:17 mysqld_safe mysqld from pid file /usr/local/mysql/var/AYZ.pid ended:34:05 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var:34:05 [Warning] You need to use --log-bin to make --binlog-format work.:34:05 InnoDB: The InnoDB memory heap is disabled:34:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins:34:05 InnoDB: Compressed tables use zlib 1.2.:34:05 InnoDB: Initializing buffer pool, size = 16.0M:34:05 InnoDB: Completed initialization of buffer pool:34:05 InnoDB: highest supported file format is Barracuda.:34:05InnoDB: Waiting for the background threads to start:34:06 InnoDB: 5.5.37 log sequence number :06 [Note] Server hostname (bind-address): '0.0.0.0'; port:
18:34:06 [Note] - '0.0.0.0' resolves to '0.0.0.0';:34:06 [Note] Server socket created on IP: '0.0.0.0'.:34:07 [Note] Event Scheduler: Loaded 0 events:34:07 [Note] /usr/local/mysql/bin/mysqld: ready for connections.Version: '5.5.37'socket: '/tmp/mysql.sock'port: 3306Source distribution:34:30 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown:34:30 [Note] Event Scheduler: Purging the queue. 0 events:34:30InnoDB: Starting shutdown...:34:30InnoDB: S log sequence number :30 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete:34:30 mysqld_safe mysqld from pid file /usr/local/mysql/var/AYZ.pid ended:34:31 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var:34:31 [Warning] You need to use --log-bin to make --binlog-format work.:34:31 InnoDB: The InnoDB memory heap is disabled:34:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins:34:31 InnoDB: Compressed tables use zlib 1.2.:34:31 InnoDB: Initializing buffer pool, size = 16.0M:34:31 InnoDB: Completed initialization of buffer pool:34:31 InnoDB: highest supported file format is Barracuda.:34:31InnoDB: Waiting for the background threads to start:34:32 InnoDB: 5.5.37 log sequence number :32 [Note] Server hostname (bind-address): '0.0.0.0'; port:
18:34:32 [Note] - '0.0.0.0' resolves to '0.0.0.0';:34:32 [Note] Server socket created on IP: '0.0.0.0'.:34:32 [Note] Event Scheduler: Loaded 0 events:34:32 [Note] /usr/local/mysql/bin/mysqld: ready for connections.Version: '5.5.37'socket: '/tmp/mysql.sock'port: 3306Source distribution启动会报错Starting MySQL.. ERROR! The server quit without updating PID file (/var/local/mysql/var/AYxxxxxxx.pid)原因是因为 mysql-bin.0000*的文件占满系统盘，磁盘空间不足导致无法写入。解决方法：1：删除所有mysql-bin.0000*日志文件全部rm掉2：修改在my.cnf 文件，找到 log-bin=mysql-bin 将其启注释掉，以后就不会产生2进制的mysql-bin.0000*的日志文件
最新教程周点击榜
微信扫一扫mysql（18）
CentOS6.5 安装完Mysql5.6，在启动时出现一下错误：
[root@localhost bin]# service mysql restart
ERROR! MySQL server PID file could not be found!
Starting MySQL... SUCCESS!
[root@localhost bin]#
解决办法：
ps &-ef & | &grep & mysql
[root@localhost bin]# ps aux |grep mysq
0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/home/mysql/data --pid-file=/home/mysql/data/localhost.localdomain.pid
6.5 0324 pts/0 Sl
0:01 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/home/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/home/mysql/data/localhost.localdomain.err --pid-file=/home/mysql/data/localhost.localdomain.pid --socket=/var/lib/mysql/mysql.sock --port=3306
0.0 103252
0:00 grep mysq
[root@localhost bin]#将进程杀死再启动就OK！
参考知识库
* 以上用户言论只代表其个人观点，不代表CSDN网站的观点或立场
访问：101783次
积分：1759
积分：1759
排名：第17819名
原创：51篇
转载：157篇
评论：10条
(3)(11)(1)(1)(2)(2)(3)(4)(18)(3)(3)(3)(2)(1)(4)(2)(3)(9)(1)(1)(1)(3)(3)(1)(1)(5)(7)(13)(3)(11)(13)(4)(66)}