php – MySQL守护程序无法启动 – centos 6

发布时间：2020-12-13 13:52:47 所属栏目：PHP教程来源：网络整理

导读：编辑：查看已签名的答案评论,以解决您的问题. 每当我尝试启动SQLD服务,我得到MySQL守护程序无法启动.我试图通过执行以下操作“开始”服务： service mysqld start 也当我输入：mysql 我得到： ERROR 2002 (HY000): Can't connect to local MySQL server thr

编辑：查看已签名的答案评论,以解决您的问题.

每当我尝试启动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.

由于错误,我也无法登录PHPMyAdmin.我可以访问phpmyadmin页面,但登录时我得到：#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

这个错误的最可能的原因是你的mysql服务器没有运行.当您输入mysql时,您正在执行mysql客户端.

尝试：

# sudo service mysql start
# mysql

更新(在OP包括登录问题后;从以下评论)：

Thanks,saw your log. The log is saying the mysql user doesn’t have
proper access rights. I’m assuming your mysql user is mysql(this can
be verified in /etc/my.cnf,execute

chown -R mysql:mysql /var/lib/mysql

and try starting mysqld again.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!