解决InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade

  前面我们在解决宝塔MySQL无法开启时看到数据库错误日志显示InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade,如何解决呢?随ytkah一起来看看吧

  进入ssh,

cd /www/server/mysql/bin
./mysql_upgrade -u root -p

解决InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade

 

  输入数据库主密码后自动就会升级了,有碰到相同问题的朋友赶紧试一下吧

 

解决InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade

上一篇:Mysql 8.0 ERROR 1064 (42000)


下一篇:Oracle中的 UPDATE FROM 解决方法