Starting MySQL....The server quit without updating PID file 处理方法
来源:互联网 发布:数据恢复后照片打不开 编辑:程序博客网 时间:2024/05/21 04:19
报错:
Starting MySQL....The server quit without updating PID file ...
查看错误日志
情景1:
120217 15:09:57[ERROR] Can't start server : Bind on unix socket: No such file or directory
120217 15:09:57[ERROR] Do you already have another mysqld server running on socket: /mysql/mysqldir/data/mysql.sock ?
120217 15:09:57[ERROR] Aborting
于是ps -ef | grep mysql 一把.未发现有mysqld.
netstat -an | grep 3306 一把.也未发现异常.
检查/etc/my.cnf中的socket的配置项,确定mysql.sock的文件位置是否正确。
最后从mysql安装目录下重新复制一个配置文件到/etc/my.cnf
修改相应参数.于是问题解决
情景2:
/mysql/mysqldir/bin/mysqld: Table 'mysql.plugin' doesn't exist
[ERROR] Can't open the mysql.plugin table. Please run my sql_upgrade to create it.
原因:编译安装后忘记初始化表.
解决:运行mysql_install_db
- Starting MySQL....The server quit without updating PID file 处理方法
- Starting MySQL.The server quit without updating PID file
- Starting MySQL. ERROR! The server quit without updating PID file
- Starting MySQL.... ERROR! The server quit without updating PID file
- Starting MySQL.. ERROR! The server quit without updating PID file
- Starting MySQL. ERROR! The server quit without updating PID file......
- Starting MySQL. ERROR! The server quit without updating PID file (/longxibendi/mysql/mysql.pid).
- Starting MySQL.The server quit without updating PID file (/var/lib/mysql/localhost.jeep.pid)
- Starting MySQL...The server quit without updating PID file [失败]lib/mysql/localhost.localdomain.pid).
- Starting MySQL...The server quit without updating PID file (/usr/local/mysql/data/rekfan.pid)
- mysql启动失败Starting MySQL.The server quit without updating PID file ([失败]ysqllnmp.pid)
- Starting MySQL... ERROR! The server quit without updating PID file (/var/lib/mysql/obcit-test.pid).
- Starting MySQL.The server quit without updating PID file (/[失败]ysql/datadir/3306/data/mysql.pid).
- Starting MySQL.The server quit without updating PID file (datamysqllinux.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)
- Starting MySQL... ERROR! The server quit without updating PID file (/mydata/data/t1.pid).
- Starting MySQL.. ERROR! The server quit without updating PID file (/usr/local/mysql/data/localhost.l
- the first it security saas marketplace
- Jackrabbit OCM(二)——ObjectContentManager对象
- jackrabbit OCM(三)——映射应用1
- RegExp 对象
- Springle+EHCache 分布式缓存开发(三)
- Starting MySQL....The server quit without updating PID file 处理方法
- XML应用系列:XSLT入门
- Activity生命周期
- 数据库SQL自动执行脚本
- 抓取iframe内数据(C#)
- 数据库中聚簇索引与非聚簇索引的区别
- MyEclipse Sub Code Generator
- 在BSP 中修改LCD 类型及串口输出功能
- 吉利吉利2/KAGeXpress 的游戏通过cocos2d-x 移植 ios/android的可行性