关于linux上的mysql异常:Starting MySQL. ERROR! The server quit without updating PID file ……

环境:centos+mysql5.5

启动报异常:

[root@shizhanmini init.d]# /etc/init.d/mysql start
Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/shizhanmini.pid).

查看错误日志((/var/lib/mysql/*.err):

160921 10:04:43 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160921 10:04:43 [Note] /usr/sbin/mysqld (mysqld 5.5.48) starting as process 1794 ...
160921 10:04:43 [Note] Plugin 'FEDERATED' is disabled.
160921 10:04:43 InnoDB: The InnoDB memory heap is disabled
160921 10:04:43 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160921 10:04:43 InnoDB: Compressed tables use zlib 1.2.3
160921 10:04:43 InnoDB: Using Linux native AIO
160921 10:04:43 InnoDB: Initializing buffer pool, size = 128.0M
160921 10:04:43 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file ./ibdata1
160921 10:04:43 InnoDB: Could not open or create data files.
160921 10:04:43 InnoDB: If you tried to add new data files, and it failed here,
160921 10:04:43 InnoDB: you should now edit innodb_data_file_path in my.cnf back
160921 10:04:43 InnoDB: to what it was, and remove the new ibdata files InnoDB created
160921 10:04:43 InnoDB: in this failed attempt. InnoDB only wrote those files full of
160921 10:04:43 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
160921 10:04:43 InnoDB: remove old data files which contain your precious data!
160921 10:04:43 [ERROR] Plugin 'InnoDB' init function returned error.
160921 10:04:43 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
160921 10:04:43 [ERROR] Unknown/unsupported storage engine: InnoDB
160921 10:04:43 [ERROR] Aborting

解决方法:

1.进入cd /var/lib/mysql/

2.rm -rf ib*

3.service mysql start

注意:

/var/lib/mysql/ 权限问题

如下图(ll)

drwxr-xr-x. 12 mysql mysql 4096 9月  29 09:27 mysql

提示:

[root@shizhanmini mysql]# service mysql start
Starting MySQL... SUCCESS! 


评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

小努蛋

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值