【问题解决】mysql-[Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name

产生原因

根据提示:是数据库innodb_table_stats 表中table_name一栏长度异常导致的。

解决方法

1：执行mysl更新
mysql_upgrade --host=‘127.0.0.1’ --port=3306 --user=‘root’ --password=“root”
2：重启数据库mysql
service mysql restart

官网bug修改

mysql 官网Bug Fixed
地址：https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-23.html

Bugs Fixed
Important Change; Partitioning: After creating partitioned InnoDB tables with very long names, the table_name columns in the corresponding entries in the mysql.innodb_index_stats and mysql.innodb_table_stats system tables were truncated. To fix this issue, the length of the table_name column in each of these tables has been increased from 64 to 199 characters. In both cases, this is now the same as the lengths of these co