升级MySQL后(5.5 -> 5.6.10),MySQL中执行grant命令,或者shell中执行mysqladmin修改密码,出现类似下面的错误:
ERROR 2013 (HY000): Lost connection to MySQL server during query
解决方案:原来是忘了执行mysql_upgrade,执行sudo mysql_upgrade,修复权限表。
升级MySQL后(5.5 -> 5.6.10),MySQL中执行grant命令,或者shell中执行mysqladmin修改密码,出现类似下面的错误:
ERROR 2013 (HY000): Lost connection to MySQL server during query
解决方案:原来是忘了执行mysql_upgrade,执行sudo mysql_upgrade,修复权限表。