MySQL启动报错

/ 0评 / 0

服务器重启mysql启动不了了,报错如下

Starting MySQL.The server quit without updating PID file (/var/lib/mysql/tserver.pid).[FAILED]

检查发现mysql的目录下有如下文件:

[root@server mysql]# ls
ibdata1  ib_logfile0  ib_logfile1  mysql  RPM_UPGRADE_HISTORY  RPM_UPGRADE_MARKER-LAST  test  server.err

删除了如下三个文件:

[root@server mysql]# rm ibdata1  ib_logfile0  ib_logfile1 
rm: remove regular file `ibdata1'? yes      
rm: remove regular file `ib_logfile0'? yes
rm: remove regular file `ib_logfile1'? yes

重新启动mysql server就可以了:

[root@server mysql]# /etc/init.d/mysql start
Starting MySQL.[  OK  ]
[root@server mysql]# ps -ef|grep mysql
root    15166    1  0 06:12 pts/0    00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/tserver.pid
mysql    15257 15166  9 06:12 pts/0    00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/tserver.err --pid-file=/var/lib/mysql/tserver.pid
root    15284 14224  0 06:12 pts/0    00:00:00 grep mysql

评论已关闭。