這篇文章主要介紹了mysql無法啟動的解決辦法的相關資料,希望通過本文大家能解決數據庫不能啟動的問題,需要的朋友可以參考下
mysql無法啟動的解決辦法
MySQL無法啟動
在停止mysql之后,執行了一些操作(如修改主機名),重新啟動 mysql,發現起不來。?
[root@www?~]$?service?mysql?start? Starting?MySQL..^[[A..................................................................................................?ERROR!?The?server?quit?without?updating?PID?file?(/disk/mysql/www.pid). [root@www?~]$?service?mysql?stop? ?ERROR!?MySQL?server?PID?file?could?not?be?found! [root@www?~]$?service?mysql?stop? ?ERROR!?MySQL?server?PID?file?could?not?be?found! [root@www?~]$?service?mysql?start? Starting?MySQL.................. 還是老樣子,只好?Ctr+C?掉。 [root@www?~]$
實在是啟動不了,看一下日志:/disk/mysql/www.err?
120608?09:56:17?mysqld_safe?Starting?mysqld?daemon?with?databases?from?/disk/mysql 120608?9:56:17?[Note]?Plugin?'FEDERATED'?is?disabled. 120608?9:56:17?InnoDB:?The?InnoDB?memory?heap?is?disabled 120608?9:56:17?InnoDB:?Mutexes?and?rw_locks?use?InnoDB's?own?implementation 120608?9:56:17?InnoDB:?Compressed?tables?use?zlib?1.2.3 120608?9:56:17?InnoDB:?Using?Linux?native?AIO 120608?9:56:17?InnoDB:?Initializing?buffer?pool,?size?=?128.0M 120608?9:56:17?InnoDB:?Completed?initialization?of?buffer?pool InnoDB:?Unable?to?lock?./ibdata1,?error:?11 InnoDB:?Check?that?you?do?not?already?have?another?mysqld?process InnoDB:?using?the?same?InnoDB?data?or?log?files. 120608?9:56:17?InnoDB:?Retrying?to?lock?the?first?data?file InnoDB:?Unable?to?lock?./ibdata1,?error:?11 InnoDB:?Check?that?you?do?not?already?have?another?mysqld?process InnoDB:?using?the?same?InnoDB?data?or?log?files. InnoDB:?Unable?to?lock?./ibdata1,?error:?11 InnoDB:?Check?that?you?do?not?already?have?another?mysqld?process InnoDB:?using?the?same?InnoDB?data?or?log?files. InnoDB:?Unable?to?lock?./ibdata1,?error:?11 ...
?好像是原來的 mysqld 并沒有停下來。
強制終止 mysqld
[root@www?~]$?ps?-ef|grep?mysql? root???4769???1?0?Jun06??????00:00:00?/bin/sh?/usr/bin/mysqld_safe?--datadir=/disk/mysql?--pid-file=/disk/mysql/localhost.pid mysql???4874?4769?0?Jun06??????00:04:04?/usr/sbin/mysqld?--basedir=/usr?--datadir=/disk/mysql?--plugin-dir=/usr/lib/mysql/plugin?--user=mysql?--log-error=/disk/mysql/localhost.err?--pid-file=/disk/mysql/localhost.pid?--socket=/disk/mysql/mysql.sock root???17947???1?0?09:56?pts/1??00:00:00?/bin/sh?/usr/bin/mysqld_safe?--datadir=/disk/mysql?--pid-file=/disk/mysql/www.pid mysql??18052?17947?0?09:56?pts/1??00:00:00?/usr/sbin/mysqld?--basedir=/usr?--datadir=/disk/mysql?--plugin-dir=/usr/lib/mysql/plugin?--user=mysql?--log-error=/disk/mysql/www.err?--pid-file=/disk/mysql/www.pid?--socket=/disk/mysql/mysql.sock root???18099?17514?0?09:56?pts/1??00:00:00?grep?mysql [root@www?~]$?killall?mysqld? [root@www?~]$?killall?mysqld? [root@www?~]$?ps?-ef|grep?mysql? root???18116?17514?0?09:57?pts/1??00:00:00?grep?mysql [root@www?~]$
?啟動 mysqld ,現在執行多次啟動命令都沒有問題。
[root@www?~]$?service?mysql?start? Starting?MySQL.?SUCCESS!? [root@www?~]$? [root@www?~]$? [root@www?~]$? [root@www?~]$? [root@www?~]$?service?mysql?start? Starting?MySQL?SUCCESS!? [root@www?~]$
前面 www.err 文件中顯示的 error: 11 到底是什么,看下:
[root@www?~]$?perror?11? OS?error?code?11:?Resource?temporarily?unavailable [root@www?~]$? [root@www?~]$
? 版權聲明
文章版權歸作者所有,未經允許請勿轉載。
THE END