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.
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>
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…
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…
Create a new file to write the code to run on computer start-up: Open a new file using the following command from terminal: sudo vi /etc/init.d/tomcat or sudo gedit /etc/init.d/tomcat Copy the below code in the new tomcat file opened: # Tomcat auto-start # description: Auto-starts tomcat # processname: tomcat #…