CentOS   发布时间:2022-04-02  发布网站:大佬教程  code.js-code.com
大佬教程收集整理的这篇文章主要介绍了Centos6 下 Mysql启动提示 Starting MySQL. ERROR! The server quit without updating PID file大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。

概述

环境说明 Centos6.5  mysql  5.5.37 问题描述 查看mysql服务,提示mysql没有启动,手动启动后,提示如下: [root@LNMP ~]# /etc/init.d/mysql start StarTing MySQl. ERROR! The server quit without updating PID file (/usr/local/mysql/var/LNMP.

环境说明

Centos6.5

MysqL 5.5.37

问题描述

查看MysqL服务,提示MysqL没有启动,手动启动后,提示如下:

[root@LNMP ~]# /etc/init.d/MysqL start
StarTing MysqL. ERROR! The server quit without updating PID file (/usr/local/MysqL/var/LNMp.pid).

查看错误日志

root@LNMP var]# tail -f /usr/local/MysqL/var/LNMP.err 
/usr/local/MysqL/bin/MysqLd: Can't create/write to file '/tmp/ibJb9vcs' (Errcode: 13)
161201  8:45:41  InnoDB: Error: unable to create temporary file; errno: 13
161201  8:45:41 [ERROR] Plugin 'InnoDB' init function returned error.
161201  8:45:41 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE Failed.
161201  8:45:41 [ERROR] UnkNown/unsupported storage ENGIne: InnoDB
161201  8:45:41 [ERROR] AborTing

161201  8:45:41 [Note] /usr/local/MysqL/bin/MysqLd: Shutdown complete

161201 08:45:41 MysqLd_safe MysqLd from pid file /usr/local/MysqL/var/LNMp.pid ended

错误日志提示13错误,innodb不能创建临时文件

解决办法

给临时文件加777权限

root@LNMP var]# chmod 777 /tmp

再次启动MysqLMysqL正常启动!

[root@LNMP var]# /etc/init.d/MysqL restart
 ERROR! MysqL server PID file Could not be found!
StarTing MysqL.. succesS! 
[root@LNMP var]# ps -ef | grep MysqL
root      5305     1  0 08:49 pts/0    00:00:00 /bin/sh /usr/local/MysqL/bin/MysqLd_safe --datadir=/usr/local/MysqL/var --pid-file=/usr/local/MysqL/var/LNMp.pid
MysqL     5690  5305  1 08:49 pts/0    00:00:00 /usr/local/MysqL/bin/MysqLd --basedir=/usr/local/MysqL --datadir=/usr/local/MysqL/var --plugin-dir=/usr/local/MysqL/lib/plugin --user=MysqL --log-error=/usr/local/MysqL/var/LNMP.err --pid-file=/usr/local/MysqL/var/LNMp.pid --socket=/tmp/MysqL.sock --port=3306
root      5712  1969  0 08:49 pts/0    00:00:00 grep MysqL

大佬总结

以上是大佬教程为你收集整理的Centos6 下 Mysql启动提示 Starting MySQL. ERROR! The server quit without updating PID file全部内容,希望文章能够帮你解决Centos6 下 Mysql启动提示 Starting MySQL. ERROR! The server quit without updating PID file所遇到的程序开发问题。

如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。

本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。