The package is located inside a disk image (.dmg) file that you first need to mount by double-clicking its icon in the Finder. It should then mount the image and display its contents.

In this post we will learn how to How To Install MySQL on Mac OS X. The same procedure can be used for installing MySQL on Mac OS X. How to add MySQL to $PAT. Before proceeding with the installation, be sure to stop all running MySQL server instances by using either the MySQL Manager Application (on OS X Server), the preference pane, or mysqladmin shutdown on the command line. Sep 28, 2017 The latest version of MySQL 5.7.19 does work with the public release of macOS. If you already have MySQL 5.7 and you have upgraded OS from El Capitan to Sierra I expect that to be ok, but will be interested if anyone comments on that. Use the Mac OS X 10.12 (x86, 64-bit), DMG Archive version (works on macOS High Sierra). Oct 29, 2017 Questions: I’m trying to setup up MySQL on mac os 10.6 using Homebrew by brew install mysql 5.1.52. Everything goes well and I am also successful with the mysqlinstalldb.

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.

In the Add-Ins available box, select the Solver Add-In check box, and then click OK. If Solver Add-in is not listed in the Add-Ins available box, click Browse to locate the add-in. If you get a prompt that the Solver add-in is not currently installed on your computer, click Yes in the dialog box to install it. After you load the Solver add-in, the Solver button is available on the Data tab.

To install MySQL using the package installer:

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
Double-click the MySQL installer package from the disk. It is named according to the version of MySQL you have downloaded. For example, for MySQL server 5.7.33 it might be named mysql-5.7.33-osx-10.13-x86_64.pkg.
The initial wizard introduction screen references the MySQL server version to install. Click to begin the installation.
Figure 2.2 MySQL Package Installer Wizard: Introduction
The MySQL community edition shows a copy of the relevant GNU General Public License. Click and then to continue.
From the Installation Type page you can either click to execute the installation wizard using all defaults, click to alter which components to install (MySQL server, Preference Pane, Launchd Support -- all enabled by default).
Although the option is visible, the installation location cannot be changed.
Figure 2.3 MySQL Package Installer Wizard: Installation Type

Figure 2.4 MySQL Package Installer Wizard: Customize
Click to begin the installation process.
After a successful installation, the installer displays a window with your temporary root password. This cannot be recovered so you must save this password for the initial login to MySQL. For example:
Figure 2.5 MySQL Package Installer Wizard: Temporary Root Password

MySQL expires this temporary root password after the initial login and requires you to create a new password.
Summary is the final step and references a successful and complete MySQL Server installation. the wizard.
Figure 2.6 MySQL Package Installer Wizard: Summary

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.7.33-osx10.13-x86_64.dmg installs MySQL into /usr/local/mysql-5.7.33-osx10.13-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`	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
`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.

In this tutorial, we are going to learn how to install MySQL community server on Mac and setting up the MySQL in Terminal app.

Mac OS doesn’t come along with the pre-configured version of MySQL, but this step by step guide will make the task easy for you. By the end of this tutorial, you will be able to set up the MySQL server on your Mac system for local development purposes.

Download MySQL Server

Before we start installing MySQL server on mac, we first download the latest version of MySQL from its official site.

Visit https://dev.mysql.com/downloads/mysql and choose the MySQL version that you want to download.

On this page, you will see list of operating systems under the “Select Operating System” dropdown choose the macOS from the list. Then, click on the download button for the MySQL .dmg file. You can download the other MySQL instances as per your operating system requirement.

Install MySQL on Mac

You have to click on the MySQL file to install the MySQL on Mac system. You might get the warning “macOS cannot verify that this app is free from malware”.

To get rid from this issue got to System Preferences > Security & Privacy and click on the “Open Anyway” button. This will allow you to install the MySQL version in your system.

Once the MySQL installation is completed, go to System Preferences and click on the MySQL icon that you can see on the bottom left position.

Here you can see the MySQL is already running and other configurations of MySQL. You can even stop the server by clicking on “stop MySQL server”. Well this is not the only way to start the server, we can even manually start the MySQL server via command line.

Configure MySQL in Mac for Terminal App

To start the MySQL via terminal app, you need to use the following command.

But this command will display the following error on your terminal screen

Install Mysql For Mac Os