XAMPPErrorDomain error 1 for changing MySQL data dirs

Question

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.

Operation could not be completed.  
(XAMPPErrorDomain error 1.)  

What's the problem here? I correctly specified the new path.

Answer 1

Look in your logs: apache friends - xampp for linux faq >> Error 1

Answer 2

I also have this problem but none of them works, I compared with files one by one on new machine and the old ones finally find the this works for me:

sudo chown -R nobody:admin /Applications/XAMPP/xamppfiles/var/

Answer 3

I found a tip elsewhere that says to run:

> sudo ${XAMPP_HOME}/xamppfiles/bin/mysql.server start

I did, and the result was interesting:

> sudo ${XAMPP_HOME}/xamppfiles/bin/mysql.server start
Password:
sudo: /xamppfiles/bin/mysql.server: command not found

Thus ${XAMPP_HOME} is undefined.

So I edited ~/.bash_profile and added the line:

export XAMPP_HOME="/Applications/XAMPP"

After restarting Terminal, our command now yields:

Starting MySQL
. ERROR! Manager of pid-file quit without updating file.

Not sure what to do at this point, but it’s progress.

---

Update: I looked in /Applications/XAMPP/xamppfiles/var/mysql and noticed a .err file (should start with your local computer name, like johns-macbook-pro.local.err). It indicated that my permissions were screwed up: “The error means mysqld does not have the access rights to the directory. File name ./ibdata1”

Setting /Applications/xampp/xamppfiles/var/mysql/ and all its contents to be readable and writable for everyone did the trick. Probably the best solution is to chown -R mysqld /Applications/xampp/xamppfiles/var/mysql/.

Answer 4

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

Answer 5

I did something like this:

cd /Applications/XAMPP/xamppfiles/bin
ls -la 

I have this file:

/Applications/xampp/xamppfiles/share/mysql/mysql.server

We can symlink it:

rm mysql.server 
ln -s /Applications/XAMPP/xamppfiles/share/mysql/mysql.server mysql.server

… and I started MySQL from XAMPP's control panel.