Installing MySQL on a Mac

Using the SQL community's native installation package is easy

Oracle's MySQL is a popular open source relational database management system that is based on Structured Query Language (SQL). It is frequently used in conjunction with PHP to enhance the capabilities of websites. PHP comes pre-loaded onto Mac computers, but MySQL does not.

When you create and test software or websites that require a MySQL database, it is handy to have MySQL installed on your computer.

Installing MySQL on an Mac is easier than you might expect, particularly if you use the native installation package instead of the TAR package, which requires access and changes to the command line in Terminal mode.

Installing MySQL Using the Native Installation Package

  1. Go to the MySQL website and download the latest version of MySQL for MacOS. Select the native package DMG archive version, not the TAR version.
  2. Double-click the file icon to mount the .dmg archive, which contains the installer.
  3. Double-click the icon for the MySQL package installer.
  4. Read the opening dialog screen and click Continue to begin the installation.
  5. Read the license terms. Click Continue and then Agree to continue.
  6. Click Install to execute the installation using all defaults. 
  7. Record the temporary password that displays during the installation process. This password cannot be recovered. You must save it. After you log in to MySQL, you'll be prompted to create a new password.
  1. Press Close on the Summary screen to complete the installation.

How to Start My SQL on a Mac

Now the MySQL server is installed on the Mac, but it does not load by default. Start MySQL by clicking Start using the MySQL Preference Pane, which was installed during the default installation. You can configure MySQL to automatically start when you turn on your computer using the MySQL Preference Pane.

Format
mla apa chicago
Your Citation
Bradley, Angela. "Installing MySQL on a Mac." ThoughtCo, Nov. 27, 2016, thoughtco.com/installing-mysql-on-mac-2693866. Bradley, Angela. (2016, November 27). Installing MySQL on a Mac. Retrieved from https://www.thoughtco.com/installing-mysql-on-mac-2693866 Bradley, Angela. "Installing MySQL on a Mac." ThoughtCo. https://www.thoughtco.com/installing-mysql-on-mac-2693866 (accessed January 19, 2018).