MySQL升級(jí)(5.0->5.5)時(shí),Please use mysql_upgrade to fix this error錯(cuò)誤如何解決
2016-11-25 07:54:58
15010
MySQL升級(jí)后,啟動(dòng),報(bào)錯(cuò)Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50077, now running 50511. Please use mysql_upgrade to fix this error.
我們可以嘗試按照下面的步驟進(jìn)行解決:
執(zhí)行mysql_upgrade,可能會(huì)提示
help_category 和 help_keyword需要被修復(fù)
修復(fù)上面兩張表
執(zhí)行 REPAIR TABLE mysql.help_category;
執(zhí)行 REPAIR TABLE mysql.help_keyword;
再次運(yùn)行(強(qiáng)制執(zhí)行)
mysql_upgrade --force