mysql啟動報錯彙總

今天在做關于xtrabackup的實驗過程中mysql起不來了，經過檢查發現是權限設定的問題。由此想到在日常的工作中會出現mysql啟動不了的問題，這裡建個文章，把遇到的問題都收集過來，便于查閱。

1、        權限未進行配置

以下是日志資訊：

150327 13:06:54mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data

150327 13:06:55[Note] Plugin 'FEDERATED' is disabled.

15032713:06:55  InnoDB: Started; log sequencenumber 0 343564

150327 13:06:55[ERROR] Event Scheduler: Failed to open table mysql.event

150327 13:06:55[ERROR] Event Scheduler: Error while loading from disk.

150327 13:06:55[Note] Event Scheduler: Purging the queue. 0 events

150327 13:06:55[ERROR] Aborting

15032713:06:55  InnoDB: Starting shutdown...

15032713:06:56  InnoDB: Shutdown completed; logsequence number 0 343564

150327 13:06:56[Note] /usr/local/mysql/bin/mysqld: Shutdown complete

解決方法：

chown mysql:mysql-R /usr/local/mysql/data

chmod 660 -R/usr/local/mysql/data