MySQL数据库出现The server quit without updating PID file._MySQL

php中文网
发布: 2016-06-01 13:14:25
原创
1335人浏览过

lnmp1.0可以在linux系统下快速搭建php环境,以前操作其它服务器也用过lnmp环境,重未出现过类似错误,现将解决过程记录一下。

一、服务器环境

  操作系统:CentOS-6.4

  服务器环境:集成环境LNMP1.0

二、步骤重现

  1、安装LNMP1.0,具体操作方法见这里,安装成功;

  2、因个人需求,现将MySQL数据库存放在/data/mysql/var,修改/etc/my.cnf的datadir=/data/mysql/var,别忘了将/var目录的权限设置为chown -R mysql.mysql /data/mysql; 

  3、重启服务,/root/lnmp restart;

  4、提示错误:Starting MySQL...The server quit without updating PID file [失败]/mysql/var/localhost.localdomain.pid).;

三、解决错误

MacsMind
MacsMind

电商AI超级智能客服

MacsMind 192
查看详情 MacsMind

  1、根据提示可能是PID的错误,按照常规解决方法kill相关进程、清除selinux,问题仍然存在;

  2、查看错误日志,/usr/local/mysql/var/localhost.localdomain.pid

140513 11:59:34 mysqld_safe Starting mysqld daemon with databases from /data/mysql/var/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist140513 11:59:34 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.140513 11:59:34 InnoDB: The InnoDB memory heap is disabled140513 11:59:34 InnoDB: Mutexes and rw_locks use GCC atomic builtins140513 11:59:34 InnoDB: Compressed tables use zlib 1.2.3140513 11:59:34 InnoDB: Initializing buffer pool, size = 16.0M140513 11:59:34 InnoDB: Completed initialization of buffer poolInnoDB: The first specified data file /data/mysql/var/ibdata1 did not exist:InnoDB: a new database to be created!140513 11:59:34  InnoDB: Setting file /data/mysql/var/ibdata1 size to 10 MBInnoDB: Database physically writes the file full: wait...140513 11:59:34  InnoDB: Log file /data/mysql/var/ib_logfile0 did not exist: new to be createdInnoDB: Setting log file /data/mysql/var/ib_logfile0 size to 5 MBInnoDB: Database physically writes the file full: wait...140513 11:59:34  InnoDB: Log file /data/mysql/var/ib_logfile1 did not exist: new to be createdInnoDB: Setting log file /data/mysql/var/ib_logfile1 size to 5 MBInnoDB: Database physically writes the file full: wait...InnoDB: Doublewrite buffer not found: creating newInnoDB: Doublewrite buffer createdInnoDB: 127 rollback segment(s) active.InnoDB: Creating foreign key constraint system tablesInnoDB: Foreign key constraint system tables created140513 11:59:35  InnoDB: Waiting for the background threads to start140513 11:59:36 InnoDB: 1.1.8 started; log sequence number 0140513 11:59:36 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306140513 11:59:36 [Note]   - '0.0.0.0' resolves to '0.0.0.0';140513 11:59:36 [Note] Server socket created on IP: '0.0.0.0'.140513 11:59:36 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist140513 11:59:36 mysqld_safe mysqld from pid file /data/mysql/var/localhost.localdomain.pid ended
登录后复制

  3、根据日志提示,可能是mysql.plugin数据表不存在,拷贝原数据库目录/usr/local/mysql/var/*到/data/mysql/var/,重启mysql服务/etc/init.d/mysql start,发现问题仍然存在;

  4、返回数据库目录查看数据权限发现全是root.root,重新设置数据权限:chown mysql.mysql /data/mysql/,重启mysql服务/etc/init.d/mysql start,问题解决。

四、总结

  在配置Linux环境出现错误再所难免,MySQL故障的错误日志不是很清晰,需要经验和对错误日志分析把控。那啥,数据一定要作好日常备份,发生数据灾难时也有可以恢复的源。

 

相关标签:
最佳 Windows 性能的顶级免费优化软件
最佳 Windows 性能的顶级免费优化软件

每个人都需要一台速度更快、更稳定的 PC。随着时间的推移,垃圾文件、旧注册表数据和不必要的后台进程会占用资源并降低性能。幸运的是,许多工具可以让 Windows 保持平稳运行。

下载
来源:php中文网
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn
最新问题
开源免费商场系统广告
热门教程
更多>
最新下载
更多>
网站特效
网站源码
网站素材
前端模板
关于我们 免责申明 举报中心 意见反馈 讲师合作 广告合作 最新更新
php中文网:公益在线php培训,帮助PHP学习者快速成长!
关注服务号 技术交流群
PHP中文网订阅号
每天精选资源文章推送

Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号