MySQL and macOS/ Installing and Using the MySQL Preference Pane

Chapter 4 Installing and Using the MySQL Preference Pane

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'sSystem Preferenceswindow.

Figure 4.1 MySQL Preference Pane: Location

Shows

The MySQL preference pane is installed with the same DMG file that installs MySQL Server. Typically it is installed with MySQL Server but it can be installed by itself too.

To install the MySQL preference pane:

  1. Go through the process of installing the MySQL server, as described in the documentation atChapter 2,Installing MySQL on macOS Using Native Packages.

  2. ClickCustomizeat theInstallation Typestep. The "Preference Pane" option is listed there and enabled by default; make sure it is not deselected. The other options, such as MySQL Server, can be selected or deslected.

    Figure 4.2 MySQL Package Installer Wizard: Customize

    Customize shows three package name options: MySQL Server, MySQL Test, Preference Pane, and Launchd Support. All three options are checked.

  3. Complete the installation process.

Note

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 this preference pane.

TheInstancespage includes an option to start and stop MySQL, andInitialize Databaserecreates thedata/目录中。Uninstalluninstalls MySQL Server and optionally the pain and launchd information.

TheInstancespage includes an option to start or stop MySQL, andInitialize Databaserecreates thedata/目录中。Uninstalluninstalls MySQL Server and optionally the MySQL preference panel and launchd information.

Figure 4.3 MySQL Preference Pane: Instances

The left side shows a list of MySQL instances separated by

TheConfigurationpage shows MySQL Server options including the path to the MySQL configuration file.

Figure 4.4 MySQL Preference Pane: Configuration

Content is described in the surrounding text.

The MySQL Preference Pane shows the current status of the MySQL server, showingstopped(in red) if the server is not running andrunning(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.