MAMP PRO (macOS) Documentation

FAQ > MySQL

Table mysql/innodb_table_stats has length mismatch

If you see the following output in the MySQL log file (mysql_error.log)

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

then you need to upgrade the MySQL database. To do this, follow these steps:

1. Start MAMP PRO.
2. Start the servers.
3. Open the menu “Tools” and click on the entry “Upgrade MySQL Databases…”.
4. Click on the Upgrade button in the following dialog.
5. The upgrade of your MySQL database will be performed.
6. Close the dialog by clicking the Cancel button.