每当我尝试启动SQLD服务时,MySQL守护进程都无法启动。事实上,我试图通过执行以下操作来“启动”服务:

[root@www1 ~]# service mysqld restart
mysqld stopped:                                            [  OK  ]
MySQL Daemon failed to start.
mysqld started:                                            [FAILED]
[root@www1 ~]#

在MySQL错误日志中没有任何信息,最后一个条目是:
170314  3:24:59 [Note] /usr/libexec/mysqld: Normal shutdown

170314  3:24:59 [Note] Event Scheduler: Purging the queue. 0 events
170314  3:25:01 [Warning] /usr/libexec/mysqld: Forcing close of thread 1605619  user: 'admin'

170314  3:25:01 [Warning] /usr/libexec/mysqld: Forcing close of thread 1605617  user: 'admin'
170314  3:25:01 [Warning] /usr/libexec/mysqld: Forcing close of thread 13  user: 'admin'

170314  3:25:06  InnoDB: Starting shutdown...
170314  3:25:08  InnoDB: Waiting for 35 pages to be flushed
170314  3:25:46  InnoDB: Shutdown completed; log sequence number 26624434202
170314  3:25:47 [Note] /usr/libexec/mysqld: Shutdown complete

170314 03:25:50 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

我试着用安全模式启动mysql
[root@www1 log]# mysqld_safe
170314 09:36:39 mysqld_safe Logging to '/var/log/mysqld.log'.
170314 09:36:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170314 09:36:39 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
[root@www1 log]#

在我的centos maschine上禁用了SELinux。有人能帮我吗?
编辑:昨晚没有更新。

最佳答案

这个问题与Plesk的一个坏的更新有关。
请阅读文章https://support.plesk.com/hc/en-us/articles/115001906725
可以通过运行以下命令修复:
install -m 0700 -o mysql -g mysql -d /var/lib/mysql-files
启动mysql
service mysqld start

关于mysql - MySQL守护程序无法在CentOS 6服务器上启动,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/42781217/

10-15 01:53
查看更多