Skip to content
MAMP PRO Documentation

Table mysql/innodb_table_stats has length mismatch

This error appears in the MySQL log file (mysql_error.log) when the internal InnoDB statistics tables are out of sync with the current MySQL version — typically after a MySQL upgrade:

InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade

Running the built-in upgrade tool in MAMP PRO resolves the issue:

  1. Open MAMP PRO and start the servers.

  2. Open the Tools menu and select Upgrade MySQL Databases….

  3. Click Upgrade in the dialog that appears.

  4. Once the upgrade is complete, close the dialog.


MySQL