今天升级MySQL数据库,从5.5升级到5.7,升级完成后,遇到Column count of mysql.user is wrong. Expected 45, found 42. The table is probably corrupted报错,经过查找资料发现是数据库升级后需要更新数据库状态。
使用:
mysql_upgrade -u root -p
C:\Program Files\MySQL\MySQL Server 5.7\bin>mysql_upgrade -u root -p
Enter password: *********
Checking if update is needed.
Checking server version.
Running queries to upgrade MySQL server.
Checking system database.
mysql.columns_priv OK
mysql.db OK
mysql.engine_cost OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.gtid_executed OK
mysql.help_category OK
mysql.help_keyword OK
mysq