Please use mysql_upgrade to fix this error

一、故障现象

1. mysql> grant all on dw_rhapi.* to test@'%' identified by 'test@1234';
   
2. ERROR 3009 (HY000): Column count of mysql.user is wrong. Expected 45, found 43. Created with MySQL 50644, now running 50726. Please use mysql_upgrade to fix this error.

复制代码

二、解决方法

先退出mysql：
mysql> EXIT

执行以下命令：
# mysql_upgrade -u root -p
然后输入密码。

最后出现的提示信息：Upgrade process completed successfully.表示命令执行成功。然后再执行grant语句，发现故障已解决。