《Mysql入門解決MySQL因不能創(chuàng)建 PID 導(dǎo)致無法啟動(dòng)的方法》要點(diǎn)：
本文介紹了Mysql入門解決MySQL因不能創(chuàng)建 PID 導(dǎo)致無法啟動(dòng)的方法，希望對(duì)您有用。如果有疑問，可以聯(lián)系我們。
問題描述MYSQL應(yīng)用
MySQL 啟動(dòng)報(bào)錯(cuò)信息如下：MYSQL應(yīng)用
Starting mysqld (via systemctl): Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details、 [FAILED]
根據(jù)提示,使用 systemctl status mysqld.service 和 journalctl -xe 查看服務(wù)啟動(dòng)失敗的原因.MYSQL應(yīng)用
[root@ ~]# systemctl status mysqld.servicemysqld.service - SYSV: MySQL database server.Loaded: loaded (/etc/rc.d/init.d/mysqld)Active: failed (Result: exit-code) since Wed 2016-01-20 18:26:57 CST; 40s agoDocs: man:systemd-sysv-generator(8)Process: 2979 ExecStart=/etc/rc.d/init.d/mysqld start (code=exited, status=1/FAILURE)Jan 20 18:26:56 spark01 systemd[1]: Starting SYSV: MySQL database server….Jan 20 18:26:57 spark01 mysqld[2979]: MySQL Daemon failed to start.Jan 20 18:26:57 spark01 mysqld[2979]: Starting mysqld: [FAILED]Jan 20 18:26:57 spark01 systemd[1]: mysqld.service: control process exited, code=exited status=1Jan 20 18:26:57 spark01 systemd[1]: Failed to start SYSV: MySQL database server..Jan 20 18:26:57 spark01 systemd[1]: Unit mysqld.service entered failed state.Jan 20 18:26:57 spark01 systemd[1]: mysqld.service failed.[root@ ~]# journalctl -xeUnit session-2.scope has begun starting up.Jan 20 18:26:48 spark01 sshd[2916]: pam_unix(sshd:session): session opened for user spark by (uid=0)Jan 20 18:26:52 spark01 su[2944]: (to root) spark on pts/1Jan 20 18:26:52 spark01 su[2944]: pam_unix(su-l:session): session opened for user root by spark(uid=1000)Jan 20 18:26:56 spark01 polkitd[909]: Registered Authentication Agent for unix-process:2974:117137 (system bus name :1.25Jan 20 18:26:56 spark01 systemd[1]: Starting SYSV: MySQL database server….― Subject: Unit mysqld.service has begun start-up― Defined-By: systemd― Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel―― Unit mysqld.service has begun starting up.Jan 20 18:26:57 spark01 mysqld[2979]: MySQL Daemon failed to start.Jan 20 18:26:57 spark01 mysqld[2979]: Starting mysqld: [FAILED]Jan 20 18:26:57 spark01 systemd[1]: mysqld.service: control process exited, code=exited status=1Jan 20 18:26:57 spark01 systemd[1]: Failed to start SYSV: MySQL database server..― Subject: Unit mysqld.service has failed― Defined-By: systemd― Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel―― Unit mysqld.service has failed.―― The result is failed.Jan 20 18:26:57 spark01 systemd[1]: Unit mysqld.service entered failed state.Jan 20 18:26:57 spark01 systemd[1]: mysqld.service failed.Jan 20 18:26:57 spark01 polkitd[909]: Unregistered Authentication Agent for unix-process:2974:117137 (system bus name :1.
這些信息并不能提供服務(wù)啟動(dòng)失敗的真正原因.
MYSQL應(yīng)用
查看 MySQL 的告警日志：MYSQL應(yīng)用
2016-01-20T10:00:19.935771Z 0 [ERROR] /usr/sbin/mysqld: Can't create/write to file ‘/var/run/mysqld/mysqld.pid' (Errcode: 2 - No such file or directory)2016-01-20T10:00:19.935795Z 0 [ERROR] Can't start server: can't create PID file: No such file or directory160120 18:00:20 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
解決方法MYSQL應(yīng)用
MySQL 服務(wù)在啟動(dòng)的時(shí)候,不能創(chuàng)建 pid 文件.
MYSQL應(yīng)用
在終端看一下該目錄是否存在,如果不存在,手動(dòng)創(chuàng)建：MYSQL應(yīng)用
[root@ ~]# mkdir -p /var/run/mysqld/
再次嘗試啟動(dòng) MySQL 服務(wù),報(bào)錯(cuò)如下:MYSQL應(yīng)用
Starting mysqld (via systemctl): Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details. [FAILED]
查看 MySQL 的告警日志：MYSQL應(yīng)用
2016-01-20T10:28:37.183387Z 0 [ERROR] /usr/sbin/mysqld: Can't create/write to file ‘/var/run/mysqld/mysqld.pid' (Errcode: 13 - Permission denied)2016-01-20T10:28:37.183431Z 0 [ERROR] Can't start server: can't create PID file: Permission denied160120 18:28:37 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended160120 18:32:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
權(quán)限不正確,/var/run/mysqld/ 的屬主和屬組還是 root,MySQL 并不能在其中創(chuàng)建文件后修改該目錄的屬主和屬組MYSQL應(yīng)用
[root@ ~]# ls -ld /var/run/mysqld/drwxr-xr-x 2 root root 40 Jan 20 18:28 /var/run/mysqld/ [root@ ~]# chown mysql.mysql /var/run/mysqld/ [root@ ~]# /etc/init.d/mysqld startStarting mysqld (via systemctl): [ OK ]
總結(jié)MYSQL應(yīng)用
以上就是這篇文章的全部?jī)?nèi)容了,希望本文的內(nèi)容對(duì)大家的學(xué)習(xí)或者工作能帶來一定的贊助,如果有疑問大家可以留言交流,謝謝大家對(duì)維易PHP的支持.
MYSQL應(yīng)用
維易PHP培訓(xùn)學(xué)院每天發(fā)布《Mysql入門解決MySQL因不能創(chuàng)建 PID 導(dǎo)致無法啟動(dòng)的方法》等實(shí)戰(zhàn)技能，PHP、MYSQL、LINUX、APP、JS,CSS全面培養(yǎng)人才。
轉(zhuǎn)載請(qǐng)注明本頁網(wǎng)址：
http://www.snjht.com/jiaocheng/11259.html
