Another fun filled day with mysql..fuck me. Â Anyhow my datadir was filling up and attempted to move datadir to another partition with more space…normally a 2 minute deal. Â Update in /etc/my.cnf and restart mysql… negative Houston, we have a problem…Checked all the normal crap with selinux, proper perms on new datadir, owned by mysql.mysql etc…etc.
If you leave the default location /var/lib/myql it will start all damn day and no issues.
Looks like perhaps the Fedora 19 Updates repo has the funky RPMS. Â I uninstalled completely and re-installed with yum install mysql mysql-server (which installs the mariadb mariadb-server) numberous times and everytime issues after I moved the datadir.
Here’s the fix..
Used Fedora 20 repo located here. Â This did the trick..had one more issue with mysql client it was complaining about not being able to find mysql.sock. Â However it did work if I did mysql -u root -p -h 127.0.0.1 but gave error without the -h host portion. Â Simple fix.. add this to /etc/my.cnf
[client]
socket=/path/to/mysql.sock
