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.
This preference pane is installed by default, and is listed under your system's System Preferences window.
To install the MySQL Preference Pane:
Download the disk image (
.dmg) file (the community version is available here) that contains the MySQL package installer. Double-click the file to mount the disk image and see its contents.
Go through the process of installing the MySQL server, as described in the documentation at Chapter 2, Installing MySQL on macOS Using Native Packages.
Click Installation Type step. The "Preference Pane" option is listed there and enabled by default; make sure it is not deselected.at the
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. 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. 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.