Re: Mac Yosemite update - MySQL doesn't automatically start

[Pieter de Jong]

I believe I may have found the solution, works for me so far.

The instructions:
Create a file called com.mysql.mysql.plist in /Library/LaunchDaemons

The file should have like this code (without the horizontal lines above and below):

-------------------------------------------------------

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">;
<plist version="1.0">
<dict>
<key>KeepAlive</key>
<true/>
<key>Label</key>
<string>com.mysql.mysqld</string>
<key>ProgramArguments</key>
<array>
<string>/usr/local/mysql/bin/mysqld_safe</string>
<string>--user=mysql</string>
</array>
</dict>
</plist>

-------------------------------------------------------


After reating that file, open Terminal and submit the following commands:
sudo chown root /Library/LaunchDaemons/com.mysql.mysql.plist
sudo chgrp wheel /Library/LaunchDaemons/com.mysql.mysql.plist
sudo chmod 644 /Library/LaunchDaemons/com.mysql.mysql.plist

And last command:
sudo launchctl load -w /Library/LaunchDaemons/com.mysql.mysql.plist

Then restart computer and check if the MySql server is autostarted.
Worked for me.

(Above is based on the answers given here: http://stackoverflow.com/questions/26461173/autostart-mysql-server-on-mac-os-x-yosemite/26465743#26465743)