Acquia Dev Desktop MySQL database troubleshooting on Mac OSX 10.11

Question

I changed the Acquia Dev Desktop configuration, then when Apache web server and MySQL were restarting MySQL never got back online.

I have enabled the debug option in Acquia Dev Desktop. The logs don't show any clues:

Workaround

I am using the MAMP mysql in the meanwhile, it has this convenient shell script:

/Applications/MAMP/bin/startMysql.sh

I changed the Acquia Dev Desktop configuration What did you change? Did changing it back not fix the problem? We're gong to need more details — Clive♦, Oct 19 '16 at 18:26
I changed the port of the web server to 80. My current configuration is apache on port 80 and mysql on port 33070 (I tried changing this, but it hasn't work) — Cesar Moore, Oct 19 '16 at 18:46

Cesar Moore · Accepted Answer · 2016-10-27 19:25:26Z

Manually starting the MySQL server:

/Applications/DevDesktop/mysql/bin/mysqld --defaults-file=/Applications/DevDesktop/mysql/my.cnf

Viewing the log:

tail -50 /Applications/DevDesktop/mysql/data/mysql.err

If everything went right you should see the MySQL green dot in the Acquia Dev Desktop GUI.

user663947 · Accepted Answer · 2019-05-08 18:47:41Z

After spending time on searching for the solution. Below solution worked for me.

Open my.ini (my.cnf on linux-based systems and Mac)

Look for [mysqld]

Just below [mysqld] insert innodb_force_recovery = 1

Start MySQL Service

Stop MySQL Service

Remove the line from my.ini (innodb_force_recovery = 1)

Start MySQL Service

2 Answers 2