Home » Questions » Computers [ Ask a new question ]

XAMPPErrorDomain error 1 for changing MySQL data dirs

XAMPPErrorDomain error 1 for changing MySQL data dirs

I tried to move my mysql data dir from one disk to another, I modified the datadir parameter in my.cnf, but when XAMPP, and more precisely, MySQL starts, this error is displayed and MySQL doesn't run.

Asked by: Guest | Views: 291
Total answers/comments: 4
Guest [Entry]

Look in your logs: apache friends - xampp for linux faq >> Error 1
Guest [Entry]

"Same error.
Easily resolved on Mac OSX by changing permissions of the Xampp folder in applications to allow read&write access !"
Guest [Entry]

"I fixed this by doing the folowing steps.

Install XAMPP normally
Copy the folders of database from the older location to the folder Application/XAMPP/xamppfiles/var/mysql
Right click on folder and select Show Information.
Add the user ADMIN to the list of users allowed
Give permission read-only

This fixed for me when I changed my HD and I needed install all over again.

Regards"
Guest [Entry]

"Look for error files, for example: /Applications/XAMPP/xamppfiles/var/mysql/[YOUR_COMPUTER_NAME].err

An error I sometimes have is:

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

Meaning MySQL will ignore the my.cnf file because any-one and their mother can change it (security issue)

Go to the my.cnf file, right click > Get Info, Under Sharing & Permissions change Everyone permissions to No Access."