MySQL Database won't start XAMPP

Question

I have updated my XAMPP version to 1.8.2. Now I have the problem that the MySQL Database-server won't start.

If I try to start the Apache Web Server (in 'Application manager'), it says "starting..." and after a few seconds it says "Running". When I do the same thing with the MySQL Database, it says "starting..." for a few seconds and then it says "Stopped".

When I look at the config file (my.cnf), I see this:

# The following options will be passed to all MySQL clients
[client]
#password           = your_password
port        = 3306
socket      = /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock

I think the problem is in the socket. mysql.sock does not exist in that directory and not even in the whole XAMPP-directory.

Does anyone know how to fix this?

PS: I have PHP 5.4 installed on OS X.

Solution 1

i had experienced the same error on Mac OS X (10.9) Mavericks i fixed by following these steps

1. Open terminal and use sudo su
2. Run ps aux | grep mysql
3. Kill all process using kill -9 PROCESS_ID
4. Start your MySQL using control panel

Solution 2

Port 3306 might be used by other process, Can just change the Port number in Xampp mysql configuration and start the mysql.