Starting MySQL...The server quit without updating PID file (/usr/local/mysql/data/rekfan.pid)
来源:互联网 发布:淘宝星级 编辑:程序博客网 时间:2024/04/24 17:20
启动mysql服务时,报错:
Starting MySQL...The server quit without updating PID file (/usr/local/mysql/data/rekfan.pid)。
1.可能是/usr/local/mysql/data/rekfan.pid文件没有写的权限
解决方法 :给予权限,执行 “chown -R mysql:mysql /var/data” “chmod -R 755 /usr/local/mysql/data” 然后重新启动mysqld!
2.可能进程里已经存在mysql进程
解决方法:用命令“ps -ef|grep mysqld”查看是否有mysqld进程,如果有使用“kill -9 进程号”杀死,然后重新启动mysqld!
3.可能是第二次在机器上安装mysql,有残余数据影响了服务的启动。
解决方法:去mysql的数据目录/data看看,如果存在mysql-bin.index,就赶快把它删除掉吧,它就是罪魁祸首了。本人就是使用第三条方法解决的 !http://blog.rekfan.com/?p=186
4.mysql在启动时没有指定配置文件时会使用/etc/my.cnf配置文件,请打开这个文件查看在[mysqld]节下有没有指定数据目录(datadir),或者是该配置文件哪里写的有问题。
解决方法:请在[mysqld]下设置这一行:datadir = /usr/local/mysql/data
5.skip-federated字段问题
解决方法:检查一下/etc/my.cnf文件中有没有没被注释掉的skip-federated字段,如果有就立即注释掉吧。
6.错误日志目录不存在
解决方法:使用“chown” “chmod”命令赋予mysql所有者及权限
7.selinux惹的祸,如果是centos系统,默认会开启selinux
解决方法:关闭它,打开/etc/selinux/config,把SELINUX=enforcing改为SELINUX=disabled后存盘退出重启机器试试。
--本篇文章转自:http://blog.csdn.net/zalion/article/details/9274263
- Starting MySQL...The server quit without updating PID file (/usr/local/mysql/data/rekfan.pid)
- 启动mysql服务失败The server quit without updating PID file (/usr/local/mysql/data/rekfan.pid).[失败]
- Starting MySQL.. ERROR! The server quit without updating PID file (/usr/local/mysql/data/localhost.l
- 数据库报错 Starting MySQL.The server quit without updating PID file (/usr/local/mysql/data/hostname.pid)
- mysql的错误:The server quit without updating PID file /usr/local/mysql/data/door.pid).
- Starting MySQL.The server quit without updating PID file (/usr/local/mysql/iZ28z
- ERROR! The server quit without updating PID file (/usr/local/mysql-5.5.32/data/zexi.pid).
- The server quit without updating PID file (/usr/local/mysql/data/centos7.pid).
- mysql起动报错The server quit without updating PID file /usr/local/mysql/data/
- The server quit without updating PID file (/usr/local/mysql/data/AY140308085
- ERROR! The server quit without updating PID file (/usr/local/var/mysql/andy.local.pid)
- macOS The server quit without updating PID file (/usr/local/var/mysql/XXX.local.pid)
- mysql 启动报错:The server quit without updating PID file (/usr/local/mysql/data/ubuntu.pid)
- Starting MySQL.The server quit without updating PID file (/[失败]ysql/datadir/3306/data/mysql.pid).
- ERROR! The server quit without updating PID file (/usr/local/var/mysql/ericliu.pid).
- The server quit without updating PID file (/usr/local/mysql[失败]localhost.localdomain.pid).
- Starting MySQL.The server quit without updating PID file (/[FAILED]qldata/3306/data/test.com.pid).
- Starting MySQL...The server quit without updating PID file (/opt/mysql1/data/dev-132.pid)
- HDU 5192 [迷之WA!]
- java 验证邮箱格式正确性、验证字符串是否为数字
- 安装unbuntu
- hdu 1717 小数化分数2(数学)
- HDU 1754 I hate it 【线段树--单点更新,区间最值】
- Starting MySQL...The server quit without updating PID file (/usr/local/mysql/data/rekfan.pid)
- C/C++中const关键字详解(四)
- iOS开发内存警告Memory Warning和ViewController的生命周期的问题
- HttpURLConnection用法详解
- SQL update 用另外一个表更新一列
- 系统调用过程的理解
- IO包中的其他类2和字符编码
- HTTP 缓存
- 网络编程练习-TCP socket