When checking system records today,See MariaDB has a lot of error messages,Follows:
InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
Internet search after,Mainly because after a certain DB update,The length of the field has been adjusted,And the adjustment method is as the event record says,Just execute the mysql_upgrade command。
◎ Run Command Prompt of MariaDB,And enter the following command:
mysql_upgrade -u root -p
◎ After running,Just restart the SQL service。
If the above actions are performed,Still didn't solve the problem,Please backup the database,Remove and reinstall。
【參考連結】
- errors – Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade – Database Administrators Stack Exchange
- Under MySQL5.7.25, the error message innodb_table_stats is reported-Where is my second dog-51CTO blog