MySQL Bugs: #74434: mysqld will not autostart under OS X Yosemite

Bug #74434	mysqld will not autostart under OS X Yosemite
Submitted:	18 Oct 2014 0:14	Modified:	27 Jul 2015 13:07
Reporter:	Jeff Schuler	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S2 (Serious)
Version:	5.6.21 Community Server	OS:	MacOS
Assigned to:		CPU Architecture:	Any

Description:
mysqld will not autostart under OS X Yosemite.  It worked before the upgrade from Mavericks.  You can manually start it, and everything works fine after that.

How to repeat:
Restart the Mac, and the mysql daemon will fail to start on its own.

Thank you for the bug report. I am wondering why do you think is MySQL Server bug instead of the OS itself. I noticed several people commenting issues with Yosemite stuck in the upgrade process (include me too).

I have a similar issue with NO-IP's dynamic DNS daemon process also not auto starting, and they have confirmed it is a bug on their end.  I would think if there was an issue with Yosemite and auto starting Daemons in general I would have found a hit somewhere.  I have checked on Apple's developer site as well.

Thanks.

After suffering a lot I was able to install Yosemite an upgrade from Mavericks and I could confirm the auto-start issue. However I still believe isn't a MySQL server bug.

I have found a work around for this.  Here is the link: http://stackoverflow.com/questions/26461173/autostart-mysql-server-on-mac-os-x-yosemite/26...

Just wondering if you plan on researching the issue further since you don't seem to think it's a MySQL issue.

Thank you for the feedback. The bug is on Verified status so action will be taken to fix. Thanks again.

See also at https://developer.apple.com/library/mac/documentation/MacOSX/Conceptual/BPSystemStartup/Ch...:

"Deprecation Note: Startup items are a deprecated technology. Launching of daemons through this process may be removed or eliminated in a future release of OS X.

Unless your software requires compatibility with OS X v10.3 or earlier, use the launchd facility instead. For more information, see Creating Launch Daemons and Agents."

Looks like this happened.

Noted in 5.5.45, 5.6.26, 5.7.8 changelogs.

mysqld failed to start automatically on OS X Yosemite.

Revised changelog entry:

On OS X 10.10 (Yosemite), mysqld failed to start automatically. The
startup item has been replaced with a launchd job, which enables the
preference pane checkbox for automatic startup to work again.

Issue with mysql-5.6.26-osx10.9-x86_64 rc 

LaunchDaemon (sudo launchctl load -w /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist) starts mysql, but default config stops server there after with error: Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!