大佬教程收集整理的这篇文章主要介绍了php – MySQL守护程序无法启动 – centos 6,大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。
每当我尝试启动SQLD服务,我得到MySQL守护程序无法启动.我试图通过执行以下操作“开始”服务:
service mysqld start
也
当我输入:mysql
我得到:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
我知道该目录中应该有一个mysql.sock文件,所以我创建一个.但文件只是自动删除自己,我继续得到错误2002.
由于错误,我也无法登录phpR_159_11845@yAdmin.我可以访问phpR_159_11845@yadmin页面,但登录时我得到:#2002无法登录到MySQL服务器
编辑:
这是我的mysql.log文件:
131201 13:05:07 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 131201 13:18:18 mysqld_safe StarTing mysqld daemon with databases from /var/lib/mysql 131201 13:18:18 [Note] Plugin 'FEDERATED' is disabled. /usr/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13) 131201 13:18:18 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 131201 13:18:18 InnoDB: The InnoDB memory heap is disabled 131201 13:18:18 InnoDB: Mutexes and rw_locks use GCC atomic builTins 131201 13:18:18 InnoDB: Compressed tables use zlib 1.2.3 131201 13:18:18 InnoDB: Using Linux native AIO 131201 13:18:18 InnoDB: Initializing buffer pool,size = 128.0M 131201 13:18:18 InnoDB: Completed initialization of buffer pool 131201 13:18:18 InnoDB: OperaTing system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'open'. InnoDB: CAnnot conTinue operation. 131201 13:18:18 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
我跑了mysql_upgrade并得到
Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck FATAL ERROR: Upgrade failed
以上是大佬教程为你收集整理的php – MySQL守护程序无法启动 – centos 6全部内容,希望文章能够帮你解决php – MySQL守护程序无法启动 – centos 6所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。