Download And Install Mysql On Mac

MySQL is the most popular open source database management system. It allows you to quickly download and install and run a powerful database system on almost any platform available including Linux, Windows, and Mac OS X etc. Native Package Installer, which uses the native macOS installer (DMG) to walk you through the installation of MySQL. For more information, see Chapter 2, Installing MySQL on macOS Using Native Packages.

For a list of macOS versions that the MySQL server supports, see https://www.mysql.com/support/supportedplatforms/database.html.

MySQL for macOS is available in a number of different forms:

  • Native Package Installer, which uses the native macOS installer (DMG) to walk you through the installation of MySQL. For more information, see Chapter 2, Installing MySQL on macOS Using Native Packages. You can use the package installer with macOS. The user you use to perform the installation must have administrator privileges.

  • Compressed TAR archive, which uses a file packaged using the Unix tar and gzip commands. To use this method, you 'to open a Terminal window. You do not need administrator privileges using this method, as you can install the MySQL server anywhere using this method. For more information on using this method, you can use the generic instructions for using a tarball, Installing MySQL on Unix/Linux Using Generic Binaries.

    In addition to the core installation, the Package Installer also includes Chapter 3, Installing a MySQL Launch Daemon and Chapter 4, Installing and Using the MySQL Preference Pane, both of which simplify the management of your installation.

For additional information on using MySQL on macOS, see Chapter 5, General Notes on Installing MySQL on macOS.

MySQL is the most popular open source database management system. It allows you to quickly download and install and run a powerful database system on almost any platform available including Linux, Windows, and Mac OS X etc. In this tutorial, I am going to explain how to download and install MySQL on Mac OS X in a few easy steps.

Background

Mac OS X doesn’t ship with its own copy of MySQL, nor does Sequel Pro. You will have to install a copy on your local machine, or connect to the MySQL server on a machine somewhere on the Internet.

Most webservers and website packages will include a MySQL installation as part of the services they provide, and usually provide external connection details to allow you to connect to them in an external program like Sequel Pro. (See Web Hosting Providers for a list of hosting options).

Important! IncoPOS for macOS can now download, install and configure MySQL server for you when it is started for the first time. You can download it from here.

Download MySQL

The first step is to download MySQL server on your Mac.

Go to the MySQL web site and select the version that matches your version of Mac OS. Select the DMG archive version which I recommend. Open the installer and follow the installation steps.

Install

Warning! Because Oracle has changed the MySQL installer and the default parameters of the MySQL server in newer versions the following steps may no longer work. These steps were tested with MySQL server version 5.7.18 for macos10.12 in 2017 and I hoped this still worked fine with latest version. If not, feel free to leave a comment and I will update this post ASAP.

Please download and install version 5.5.48 to make sure that all the steps will work correctly. If for some reason the installer is no longer available on the MySQL web site you can download it from here.


Pay attention to the password in notification center. If you do not save the proper password for admin, open notification center and scroll a little bit, you will find something like this:

MySQL Configuration

  • Choose Apple () menu > System Preferences > MySQL, select MySQL and start MySQL server and move to the next step. If you use MySQL frequently, make sure to leave the checkbox “Automatically Start MySQL Server on Startup” so you won’t have to do that again and again.
  • Open terminal and type:

  • Type this piece of codes in the file you opened, then save and quit.

  • Use this piece of code and the password appeared in notification center to log in.

  • If you successfully log in using Terminal, you can use this piece of code to reset/change your password.

  • This is it! Now you have MySQL installed and secured on your Mac.

Mysql For Mac

If you notice mistakes and errors in this post, don’t hesitate to leave a comment and I would be super happy to correct them right away!