Install MySQL on macOS

Let’s learn how to install MySQL on macOS.

There is a package located in a disk image (.dmg) file, which needs to be mounted by double-clicking the icon in Finder. The next step is to mount the image and display its contents.

Before installing MySQL, users must ensure that all MySQL server instances have stopped running. This can be done using the MySQL management application on the macOS server, the preference pane, or using mysqladmin shutdown on the command line.

MySQL can be installed using the package installer. Let's see how to do this.

• Requires downloading a disk image (.dmg) file (a community version of which is also available). This will contain the MySQL package installer. Please refer to the official website screenshot below -

• The MySQL installer package downloaded above is now on the disk and needs to be double-clicked .

• Its name is based on the downloaded version of MySQL. If the MySQL server version is 8.0.22, the name will be mysql-8.0.22-osx-10.13-x86_64.pkg.

• The initial wizard introduction screen is used to reference the MySQL server version that needs to be installed.

• Click "Continue" to start installing the software package.

• MySQL Community Edition also displays a copy of the relevant GNU General Public License.

• Click "Continue" and then "Agree" to continue.

• From the Installation Type page, users can click Install to execute the installation wizard with all defaults, or Customize to change the specific components that need to be installed (such as MySQL Server, MySQL Test, Preference Pane, Launchd Support - all enabled by default except MySQL Test).

• The "Change installation location" option is available, but the installation location cannot be changed.

• You must click "Install" to install the MySQL server.

• If you are upgrading the current MySQL server installation, the installation process ends here, otherwise you need to follow the additional configuration of the wizard Steps to complete a new MySQL server installation.

• After successfully installing the MySQL server, you need to complete the configuration steps by selecting the default encryption type for passwords and enabling or disabling the MySQL server.

• The default MySQL 8.0 password mechanism uses caching_sha2_password (strong password).

• This step also allows the user to change it to mysql_native_password (legacy password).

• When the traditional password mechanism is selected, it modifies the generated launchd file to set --default_authentication_plugin = mysql_native_password under ProgramArguments.

• Selecting strong password encryption will not set --default_authentication_plugin because the default MySQL server value is used, which is caching_sha2_password.

• Define a password for the root user and toggle to know if the MySQL server starts after the configuration steps are completed.

• Summary is the final step to reference a successful and complete MySQL server installation. The wizard must be closed.

MySQL server is finally installed.

If the user chooses not to start MySQL at startup, they can start MySQL using launchctl from the command line or using the "Launch" button of the MySQL preference pane.

When you complete the installation using the package installer, the files are installed into a directory in /usr/local that matches the installation version and platform name.

Let us take an example to understand this: the installer file is mysql-8.0.25-osx10.15-x86_64.dmg, which installs MySQL to /usr/local/mysql-8.0.25-osx10 .15-x86_64/ and create a symbolic link to

/usr/local/mysql. The macOS installation process does not create or install the sample my.cnf MySQL configuration file.

The above is the detailed content of Install MySQL on macOS. For more information, please follow other related articles on the PHP Chinese website!