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.