Auto start MySQL on Mac startup

If enabling “Automatically Start MySQL Server on Startup” does not work then doing below process will fix it.

Open terminal/command line interface (CLI) and run below commands.

1. run “sudo vi /Library/LaunchDaemons/com.mysql.mysql.plist” and add below code and save the file. If vi does not work then create file “com.mysql.mysql.plist” in “/Library/LaunchDaemons/” and save below code.
   <?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>
   </array>
   </dict>
   </plist>
2. sudo chown root:wheel /Library/LaunchDaemons/com.mysql.mysql.plist
3. sudo chmod 644 /Library/LaunchDaemons/com.mysql.mysql.plist
4. sudo launchctl load -w /Library/LaunchDaemons/com.mysql.mysql.plist

Now restart the system and see that MySQL will be in running mode and no need to manually start.

Related

XAMPP MySQL fails to start: ‘InnoDB’ ENGINE failed

Some times MySQL fails to start/restart with an error like "Plugin 'InnoDB' registration as a STORAGE ENGINE failed" The simple solution to fix is to delete InnoDB log files "ib_logfile0" and "ib_logfile1". Steps to delete above mentioned files The files "ib_logfile0" and "ib_logfile1" usually reside in the data directory in…

July 28, 2020

In "Database"

Getting started with Jenkins – An Open Source Continuous Integration Server

What is Jenkins: An open source continuous integration server. Helps to continuously and automatically build, deploy and test your software/project. Helps you to monitor the execution of tasks which in turn allow you to focus more on writing code and less on managing/deploying servers. Makes it easier for team and…

April 5, 2017

In "Tech Tools"

MySQL wait_timeout and sleep connections.

For cases where an application fails to close a connection it is no longer using, a low wait_timeout value can help to avoid hitting max_connections simply due to sleeping idle connections that are not in a transaction and will not be reused. wait_timeout: is a variable representing the amount of time…

July 21, 2015

In "Database"