MySQL and macOS  /  Installing MySQL on macOS Using Native Packages

Chapter 2 Installing MySQL on macOS Using Native Packages


Before proceeding with the installation, be sure to stop all running MySQL server instances by using either the MySQL Manager Application (on macOS Server), the preference pane, or mysqladmin shutdown on the command line.

To install MySQL using the package installer:

  1. 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.

    Figure 2.1 MySQL Package Installer: DMG Contents

    Content is described in the surrounding text.

  2. Double-click the MySQL installer package. It is named according to the MySQL version and the macOS version you have chosen. For example, if you have downloaded the package for MySQL 5.6.51 and macOS 10.8, double-click mysql-5.6.51-macos-10.8-x86_64.pkg.

  3. You are presented with the opening installer dialog. Click Continue to begin installation.

    Figure 2.2 MySQL Package Installer: Introduction

    Content is described in the surrounding text.

  4. If you have downloaded the community version of MySQL, you are shown a copy of the relevant GNU General Public License. Click Continue and then Agree to continue.

  5. From the Installation Type page you can either click Install to execute the installation wizard using all defaults, click Customize to alter which components to install (MySQL server, Preference Pane, Launchd Support -- all enabled by default).


    Although the Change Install Location option is visible, the installation location cannot be changed.

    Figure 2.3 MySQL Package Installer: Installation Type

    Content is described in the surrounding text.

    Figure 2.4 MySQL Package Installer: Customize

    Content is described in the surrounding text.

  6. Click Install to begin the installation process.

  7. Once the installation has been completed successfully, you are shown an Install Succeeded message with a short summary. Now, Close the wizard and begin using the MySQL server.

    Figure 2.5 MySQL Package Installer: Summary

    Content is described in the surrounding text.

MySQL server is now installed, but it is not loaded (or started) by default. Use either launchctl from the command line, or start MySQL by clicking "Start" using the MySQL preference pane. For additional information, see Chapter 3, Installing a MySQL Launch Daemon, and Chapter 4, Installing and Using the MySQL Preference Pane. Use the MySQL Preference Pane or launchd to configure MySQL to automatically start at bootup.

When installing using the package installer, the files are installed into a directory within /usr/local matching the name of the installation version and platform. For example, the installer file mysql-5.6.51-macos10.12-x86_64.dmg installs MySQL into /usr/local/mysql-5.6.51-macos10.12-x86_64/ . The following table shows the layout of the installation directory.

Table 2.1 MySQL Installation Layout on macOS

Directory Contents of Directory
bin, scripts mysqld server, client and utility programs
data Log files, databases
docs Helper documents, like the Release Notes and build information
include Include (header) files
lib Libraries
man Unix manual pages
mysql-test MySQL test suite
share Miscellaneous support files, including error messages, sample configuration files, SQL for database installation
sql-bench Benchmarks
support-files Scripts and sample configuration files
/tmp/mysql.sock Location of the MySQL Unix socket

During the package installer process, a symbolic link from /usr/local/mysql to the version/platform specific directory created during installation is created automatically.