System: OS X Mavericks (10.9.3) My SQL Server (5.6.19) Symptom: Ever since installing My SQL using Homebrew, My SQL would not start up properly on a hard reboot.
After installing My Sql with homebrew, I wasn't able to get the server running.
Hi, The mysql error log will exactly show why mysql service doesn't start.
The log will be /var/lib/mysql/where hostname is the server hostname.
(/data/mysql/err) #If that all happens to you, than most probably the issue is caused by SELinux. If you see output below: shell sestatus SELinux status: enabled SELinuxfs mount: /selinux Current mode: enforcing Mode from config file: enforcing Policy version: 24 Policy from config file: targeted #then you have SELinux on.
#(If you see that SELinux is disabled, then probably you have some other root cause and the rest of the post will not be a solution for you.) #You can turn SELinux off by editing file (/etc/selinux/config - update - SELINUX=disabled , save, reboot) #but this will reduce the security of your system and generally not recommended.
The above command seemed to fix it however the only difference i see is that you set the user where i do not!
I tried all the solutions but still have the same problem.
It began occurring after i did a brew switch from mysql 5.6.10 to 5.5.25.
#So, better solution is to tell to SELinux, that your new location for My SQL databases must have been #applied the proper security context (the one used for My SQL databases).
#Check the security type of default database folder and new location: shell ls -d Z /data/mysql drwxr-xr-x.
Paste the modified parameters here along with mysql version and we will assist further.