MySQL中设置库管理员报错

mysql> grant all on blog.* to [e-mail] identified by '123.com';

报错内容如下：

ERROR 1558 (HY000): Column count of mysql.user is wrong. Expected 43, found 42. Created with MySQL 50565, now running 50648. Please use mysql_upgrade to fix this error

原因：可能是因为升级更高版本的mysql数据库时，没有升级好导致的。
解决方法：

[[e-mail] ~]# mysql_upgrade -uroot -pqinziteng