MAMP PRO MySQL does not start

The software is automatically updated on your Mac, and then Mamp PRO is upgraded.

After the upgrade, MySQL startup is a problem, reading the wrong log:

Innodb:the error means the system cannot find the path specified. Innodb:if you is installing InnoDB, remember you must createinnodb:directories yourself, InnoDB does not create th Em. InnoDB:Error:could not open single-table tablespace file./wordpress/wp_term_taxonomy.ibdinnodb:we does not continue the Crash recovery, because the table may becomeinnodb:corrupt if we cannot apply the log records in the InnoDB log to it. Innodb:to Fix the problem and start mysqld:innodb:1) If There is a permission problem in the file and Mysqld Cannotinnod B:open the file, you should modify the permissions. INNODB:2) If The table is not needed, or you can restore it from a backup,innodb:then you can remove the. ibd file, and InnoDB would do a normalinnodb:crash recovery and ignore that table. Innodb:3) If the file system or the disk is broken, and you cannot removeinnodb:the. ibd file, can set Innodb_force_ Recovery > 0 in My.cnfInnoDB:and Force InnoDB to continue crash recovery here. Mysqld_safe mysqld from PID File/applications/mamp/tmp/mysql/mysql.pid ended 

Very confused, Baidu search a circle, there is no good plan. Turn to Google and finally see a:

Https://stackoverflow.com/questions/40904630/mamp-wont-start-mysql-server-mac

After testing, execute the following name, delete these things, you can restart MySQL

$RM/Library/Application\ Support/Appsolute/MAMP\PRO/DB/mysql56/Ib_logfile0$RM/Library/Application\ Support/Appsolute/MAMP\PRO/DB/mysql56/Ib_logfile1$RM/Library/Application\ Support/Appsolute/MAMP\PRO/DB/mysql56/ibdata1

If you have no problem linking the database now, then don't look down.

——————————————————————————————

Then I opened MySQL with the database visualizer, and I used the mysqlworkbench to find that some of the tables I built recently had problems.

The data is then exported using Mysqlworkbench. Then empty the original database.

Rm-r/library/application\ support/appsolute/mamp\ pro/db/mysql56

　　

The catalogue is the one above.

Re-import data to build the schema, everything OK.

MAMP PRO MySQL does not start