首頁猿問 mysql啟動(dòng)失敗，但沒有erro...

mysql啟動(dòng)失敗，但沒有error信息，請(qǐng)問如何解決？

JavaScript

紅糖糍粑 2019-04-08 11:16:55

服務(wù)器環(huán)境：centos6.4啟動(dòng)代碼：#servicemysqldstartStartingMySQL...ERROR!TheserverquitwithoutupdatingPIDfile(/mnt/data/mysql/mysql.pid).檢查日志文件，也沒有error：13102611:25:45mysqld_safeStartingmysqlddaemonwithdatabasesfrom/mnt/data/mysql2013-10-2611:25:460[Warning]TIMESTAMPwithimplicitDEFAULTvalueisdeprecated.Pleaseuse--explicit_defaults_for_timestampserveroption(seedocumentationformoredetails).2013-10-2611:25:4613682[Note]Plugin'FEDERATED'isdisabled.2013-10-2611:25:477feddd850720InnoDB:Warning:Usinginnodb_additional_mem_pool_sizeisDEPRECATED.Thisoptionmayberemovedinfuturereleases,togetherwiththeoptioninnodb_use_sys_mallocandwiththeInnoDB'sinternalmemoryallocator.2013-10-2611:25:4713682[Note]InnoDB:TheInnoDBmemoryheapisdisabled2013-10-2611:25:4713682[Note]InnoDB:Mutexesandrw_locksuseGCCatomicbuiltins2013-10-2611:25:4713682[Note]InnoDB:Compressedtablesusezlib1.2.32013-10-2611:25:4713682[Note]InnoDB:CPUdoesnotsupportcrc32instructions2013-10-2611:25:4713682[Note]InnoDB:UsingLinuxnativeAIO2013-10-2611:25:4713682[Note]InnoDB:Initializingbufferpool,size=10.0M2013-10-2611:25:4713682[Note]InnoDB:Completedinitializationofbufferpool13102611:25:47mysqld_safemysqldfrompidfile/mnt/data/mysql/mysql.pidended檢查目錄權(quán)限：#ls-l/mnt/data/總用量656020drwxr-xr-x7mysqlmysql409610月2611:24mysql

查看完整描述

2 回答

烙印99

TA貢獻(xiàn)1829條經(jīng)驗(yàn) 獲得超13個(gè)贊

請(qǐng)給出啟動(dòng)失敗與所展示的日志間的時(shí)間關(guān)系；請(qǐng)檢查/var/log下的通用日志，如messages、daemon.log之類；你的服務(wù)器啟動(dòng)腳本似乎是自己寫的或者修改過，貼一下？

反對(duì) 回復(fù) 2019-04-08

繁華開滿天機(jī)

TA貢獻(xiàn)1816條經(jīng)驗(yàn) 獲得超4個(gè)贊

ls-lZ檢查mysqldatadir的SELinux權(quán)限如果是SELinux權(quán)限的問題可以用如下方法恢復(fù)假設(shè)你的datadir是/var/lib/mysql:semanagefcontext-a-tmysqld_db_t"/var/lib/mysql(/.*)?"restorecon-Rv/var/lib/mysql

反對(duì) 回復(fù) 2019-04-08