After having been working with my MySQL and sleeping my MacBook Pro without stoping all the XAMPP services, when I tried to restart the MySQL server, it didn’t work.

First I tried to start MySQL from terminal:

sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start

It doesn’t work either, but at least I got an error message:

ERROR! The server quit without updating PID file

The solution for me was going to XAMPP and follow these steps:
 1. Select MySQL Database
 2. Click on Configure
 3. Click on Open Conf File
 4. In the file opened, write below [mysqld] the line: innodb_force_recovery = 1
 5. Save and click on Restart All.

With this steps I forced innoDB to enter in recovery mode and solved my problem.

For further information I got my answer from this stackOverflow post and this article from the MySQL docs

via Code Hatchling http://ift.tt/23rHMbu