Can't access MySQL through XAMPP and phpMyAdmin

Following line in the log is the reason:

"Warning: World-writable config file '/Applications/XAMPP/xamppfiles/etc/my.cnf' is ignored"

As Rishi Kalia has pointed out already you have to set the correct permissions:

  1. Open Terminal
  2. Navigate to the XAMPP config folder

    cd /Applications/XAMPP/xamppfiles/etc/

  3. Set permissions of my.cnf to 600

    sudo chmod 600 my.cnf

  4. Restart MySQL.


I had to reset the permissions in my xampp folder because I needed to be able to INSERT images into a folder in the htdocs, via php from website I am building.

However after I changed the permission I got : Errcode: 13

The process listed above works but I am adding some additional notes for people who have no clue how to use the terminal.

1. Open Terminal

  • The Terminal is in Applications/Utilities/Terminal

2. Navigate to the XAMPP config folder

  • pwd shows the path listing to the current directory

  • cd changes the current directory

  • ls -a lists all the files in that directory

Enter this code into the terminal: cd /Applications/XAMPP/xamppfiles/etc/

3. Set permissions of my.cnf to 600

Enter this code into the terminal: sudo chmod 600 my.cnf

4. Restart MySQL

Voilà!


you have to go to your xampp installation directory and change the permissions of my.cnf to 600