Today while checking the system logs，I saw a lot of error messages in MariaDB，The content is as follows：
InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
After searching online，The main reason is that after a certain DB update，the length of some fields was adjusted，And as the event log says,，just run the mysql_upgrade command。
◎ Run MariaDB's Command Prompt，並輸入下列指令：
mysql_upgrade -u root -p
◎ 跑完後，重啟 SQL 服務即可。
若執行完上述動作，仍然沒有解決問題，請將資料庫備份後，移除再重新安裝即可。
【參考連結】
- errors – Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade – Database Administrators Stack Exchange
- MySQL5.7.25 下 报错提示innodb_table_stats 解决方法-我的二狗子呢-51CTO博客
Leave a Reply