MariaDB has a length mismatch error

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。



Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.