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:
- Open Terminal
Navigate to the XAMPP config folder
cd /Applications/XAMPP/xamppfiles/etc/
Set permissions of
my.cnf
to600
sudo chmod 600 my.cnf
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