在将Mac的mysql数据导入ubuntu时,报了:ERROR 1805 (HY000): Column count of mysql.user is wrong. Expected 45, found 43. The table is probably corrupted错误,查询资料后发现是Macbook的mysql版本是5.6,而ubuntu的版本是5.7,因为版本不足导致的,解决方法很简单,把版本升级就ok了,打开终端后输入:
mysql_upgrade -u root -p
结果是执行一条条升级指令,最后出现successful即表示升级成功: