《Mysql入門linux下mysql提示"mysql deamon failed to start"錯誤的解決方法》要點(diǎn):
本文介紹了Mysql入門linux下mysql提示"mysql deamon failed to start"錯誤的解決方法,希望對您有用。如果有疑問,可以聯(lián)系我們。
有臺linux服務(wù)器,系統(tǒng)為centos系統(tǒng).
網(wǎng)站突然連接不上數(shù)據(jù)庫,于是朋友直接重啟了一下服務(wù)器.進(jìn)到cli模式下,執(zhí)行 service myqsld start 發(fā)現(xiàn)還是提示"mysql deamon failed to start"錯誤信息.
# /etc/init.d/mysqld start
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
查看mysqld的log文件
#less /var/log/mysqld.log
/usr/libexec/mysqld: Can't change dir to ‘XXX' (Errcode: 13)
首先是查看數(shù)據(jù)庫日志
mysqld started
[Warning] Can't create test file xxx.lower-test
[Warning] Can't create test file xxx.lower-test
/usr/libexec/mysqld: Can't change dir to '/xxx' (Errcode: 13)
[ERROR] Aborting
首先檢查數(shù)據(jù)目錄和日志目錄的權(quán)限和所屬用戶,權(quán)限和所屬用戶都沒問題,那應(yīng)該是SELINUX的權(quán)限限制了.
先查看當(dāng)前配置信息.
# getenforce
Enforcing
就表明SELinux已經(jīng)啟用.只需要關(guān)閉即可.
關(guān)閉方法:
#setenforce 0 (0|1 開|關(guān))
或者
setsebool ftpd_disable_trans 1
命令也可以.
轉(zhuǎn)載請注明本頁網(wǎng)址:
http://www.snjht.com/jiaocheng/1744.html