1

I'm on Max OS X Yosemite and have installed fresh version of XAMPP.

However, MySQL doesn't seem to start. I've already looked in the '/Applications/XAMPP/xamppfiles/xampp' file and looks like 'unset DYLD_LIBRARY_PATH' is already there.

followed this thread here and killed the Mysql process but it also doesn't seem to work

When I execute this command sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start

It throws an error "Starting MySQL ... ERROR! The server quit without updating PID file (/Applications/XAMPP/xamppfiles/var/mysql/MacBook-Pro.local.pid)."

How should I fix this?

Community
  • 1
  • 1
Joseph Matthews
  • 11
  • 1
  • 2

2 Answers2

0

For me help this fix.

Step 1: Go to your Finder and edit the file as the following path below.

/Applications/XAMPP/xamppfiles/etc/my.cnf

Step 2: Open the file and find the [mysqld] section

add one line as following

innodb_force_recovery = 1

,and save.

Step 3: Run command in your Terminal

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

Wait until everything is OK.

Step 4: Edit the my.cnf again and remove the line you just added

innodb_force_recovery = 1

,and save.

Step 5: Stop for restart

sudo /Applications/XAMPP/bin/mysql.server stop

Wait until everything is OK.

Michael
  • 11
  • 3
-2

Hello I 'm using Mac OS X as well, once used XAMPP but also gave me errors sometimes , I recommend MAMP has not given me any problems ever and is easy to deploy.

Srozalen
  • 1