Starting MySQL.The server quit without updating PID file (/var/lib/mysql/localhost.jeep.pid)
来源:互联网 发布:怎么联系淘宝小二 编辑:程序博客网 时间:2024/05/16 22:11
项目中的用户角色不知道为什么无缘无故甘丢失了,所以就决定更改一下数据库密码,但好不幸更改后,重启时报出这个异常,
于是去查看mysql日志(在/var/lib/mysql目录下有个err文件的)
于是打算杀死进程再重启,lsof -i:3306,没有进程,后来上网google一翻参考了几篇文章都不能实现有些说修改my.cnf文件等等的,都没效,后来看到一篇文章说:
于是打上ps -ef|grep mysqld,真的发现有一个进程号,kill于就能正常启动了
- Starting MySQL..The server quit without updating PID file (/var/lib/mysql/localhost.localdomain.pid
于是去查看mysql日志(在/var/lib/mysql目录下有个err文件的)
- InnoDB: using the same InnoDB data or log files.
- InnoDB: Unable to lock ./ibdata1, error: 11
于是打算杀死进程再重启,lsof -i:3306,没有进程,后来上网google一翻参考了几篇文章都不能实现有些说修改my.cnf文件等等的,都没效,后来看到一篇文章说:
- 今天启动mysql出现了这个错误,很奇怪,按照提示,
- ps -ef|grep mysqld ,居然发现服务器里有一个僵尸进程mysqld,启动kill -9 进程号,
- 然后重新启动mysql,一切恢复正常。
于是打上ps -ef|grep mysqld,真的发现有一个进程号,kill于就能正常启动了
0 0
- Starting MySQL.The server quit without updating PID file (/var/lib/mysql/localhost.jeep.pid)
- Starting MySQL.. ERROR! The server quit without updating PID file (/var/lib/mysql/localhost.localdom
- 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 [失败]lib/mysql/localhost.localdomain.pid).
- The server quit without updating PID file (/var/lib/mysql/localhost.pid)的解决办法
- The server quit without updating PID file (/var/lib/mysql/localhost.pid)
- ERROR! The server quit without updating PID file (/var/lib/mysql//localhost.localdomain.pid
- ERROR! The server quit without updating PID file (/var/lib/mysql//localhost.localdomain.pid
- ERROR! The server quit without updating PID file (/var/lib/mysql/localhost.localdomain.pid)
- fedora20 Starting MySQL. ERROR! The server quit without updating PID file /var/lib/mysql/Master.Hado
- The server quit without updating PID file (/[FAILED]l/mysql/var/localhost.localdomain.pid)
- ERROR! The server quit without updating PID file (/var/lib/mysql/service.pid).
- 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 (/usr/local/mysql/data/localhost.l
- js控制页面返回和刷新
- 即时通讯解决方案参考
- Jquery post 供以后使用复制粘贴就行
- 图片的剪裁处理
- android 的多媒体系统
- Starting MySQL.The server quit without updating PID file (/var/lib/mysql/localhost.jeep.pid)
- jquery插件开发
- wget命令详解
- OM LINE_BOOKED 改成awaiting Shipping(往回推workflow)
- timer.Elapsed += (o, e) =>
- 如何在onclick事件中使用<c:out>标签传参
- MySQL err[1005]错误的解决总结
- 20140619
- Linux查看系统cpu个数、核心书、线程数