The MySQL Installation Package includes a MySQL preference Pane that enables you to start, stop, and control automated startup during boot of your MySQL installation.
To install the MySQL Preference Pane:
Download and open the MySQL package installer, which is
provided on a disk image (
includes the main MySQL installation package.
Previously, the OS X packages included separate
MySQL.prefPane files. They have since
been merged into the main package file.
Go through the process of installing the MySQL server, as described in the documentation at Chapter 2, Installing MySQL on OS X Using Native Packages.
Click Customize at the Installation Type step. The "Preference Pane" option is listed there and enabled by default.
Complete the MySQL server installation process.
The MySQL Preference Pane only starts and stops MySQL installation installed from the MySQL package installation that have been installed in the default location.
Once the MySQL Preference Pane has been installed, you can control your MySQL server instance using the preference pane. To use the preference pane, open the System Preferences... from the Apple menu. Select the MySQL preference pane by clicking the MySQL logo within the bottom section of the preference panes list.
The MySQL Preference Pane shows the current status of the MySQL server, showing stopped (in red) if the server is not running and running (in green) if the server has already been started. The preference pane also shows the current setting for whether the MySQL server has been set to start automatically.
To start the MySQL server using the preference pane:
Click Start MySQL Server. You may be prompted for the username and password of a user with administrator privileges to start the MySQL server.
To stop the MySQL server using the preference pane:
Click Stop MySQL Server. You may be prompted for the username and password of a user with administrator privileges to stop the MySQL server.
To automatically start the MySQL server when the system boots:
Check the check box next to Automatically Start MySQL Server on Startup.
To disable automatic MySQL server startup when the system boots:
Uncheck the check box next to Automatically Start MySQL Server on Startup.
You can close the System Preferences... window once you have completed your settings.