mysql log 看到如下 error 訊息
140413 10:14:54 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. The table is probably corrupted 140413 10:14:54 [ERROR] mysql.user has no `Event_priv` column at position 29 140413 10:14:54 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
要用 mysql_fix_privilege_tables 修復
不過 mysql 5.5 似乎沒有這個 script 存在了
它現在有 mysql_upgrade,執行這個指令即可
留言