MySQL Database won't start in XAMPP Manager-osx

Solution 1:

This should work:
sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start

Solution 2:

Minimal Guide

1. sudo killall mysqld

2. manager-osx > start mysql


If that didn't work...

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

Google the error...


Examples:

Error:

ERROR! The server quit without updating PID file (/Applications/XAMPP/xamppfiles/var/mysql/<computername>.local.pid)

My Solution:

In /Applications/XAMPP/xamppfiles/etc/my.cnf change user = <uid> s that <uid> is uid from id command.

$ id
uid=...

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

Solution 3:

If these commands don't work for you:

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

Try this:

For XAMPP 7.1.1-0, I changed the port number from 3306 to 3307.

  1. Click on Manage Servers
  2. Select MySQL Database
  3. Click on Configure on your right
  4. Change your port number to 3307
  5. Click OK
  6. Close your Control Panel and relaunch it.

You are now good to go.