Recommend switching to Docker
I finally switched to using Docker for local development on macOS. While the following tutorial works for macOS Catalina, it has limitations. I recommend following my latest tutorial on installing Apache, MySQL, and PHP on macOS using Docker.
Note: This post is for new installations. If you have installed Apache, PHP, and MySQL for Mac OS Mojave, read my post on Updating Apache, PHP, and MySQL for macOS Catalina.
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. Installing MySQL Using the Native Installation Package The free download for the Mac is the MySQL Community Server edition. Go to the MySQL website and download the latest version of MySQL for MacOS. MySQL Community Edition is a freely downloadable version of the world's most popular open source database that is supported by an active community of open source developers and enthusiasts. MySQL Cluster Community Edition is available as a separate download. The reason for this change is so that MySQL Cluster can provide more frequent updates. Installing MySQL on your own Mac. There are several different ways to install MySQL on Mac OS X. We have provided links to the most common installation methods for Mac OS X. Using the official.pkg installer. This is the fastest method for installing MySQL on your Mac.
I am aware of the web server software available for macOS, notably MAMP, as well as package managers like
brew
. These get you started quickly. But they forego the learning experience and, as most developers report, can become difficult to manage.macOS runs atop UNIX. Most UNIX software installs easily on macOS. In Additional, Apache and PHP come preinstalled with macOS. So to create a local web server, all you need to do is configure Apache and install MySQL.
Running Commands
First, open the Terminal app and switch to the
root
user so you can run the commands in this post without any permission issues:Enable Apache on macOS
Verify It works! by accessing http://localhost
Enable PHP for Apache
First, make a backup of the default Apache configuration. This is good practice and serves as a comparison against future versions of macOS.
Download And Install Mysql On Mac Catalina
Now edit the Apache configuration. Feel free to use a different editor if you are not familiar with vi.
Uncomment the following line (remove
#
):Restart Apache:
You can verify PHP is enabled by creating a
phpinfo()
page in your DocumentRoot
.The default
DocumentRoot
for macOS Catalina is /Library/WebServer/Documents
. You can verify this from your Apache configuration.Now create the
phpinfo()
page in your DocumentRoot
:Verify PHP by accessing http://localhost/phpinfo.php
Install MySQL on macOS Catalina
Download and install the latest MySQL generally available release DMG for macOS. MySQL 8 is the latest version. But older versions are available if you need to support older applications.
When the install completes it will provide you with a temporary password. Copy this password before closing the installer. You will use it again in a few steps.
The README suggests creating aliases for
mysql
and mysqladmin
. However there are other commands that are helpful such as mysqldump
. Instead, you can update your path to include /usr/local/mysql/bin
.Note: You will need to open a new Terminal window or run the command above for your path to update.
Finally, you should run
mysql_secure_installation
. While this isn't necessary, it's good practice to secure your database. This is also where you can change that nasty temporary password to something more manageable for local development.Connect PHP and MySQL
You need to ensure PHP and MySQL can communicate with one another. There are several options to do so. I like the following as it doesn't require changing lots of configuration:
Additional Configuration (optional)
The default configuration for Apache 2.4 on macOS seemed pretty lean. For example, common modules like
mod_rewrite
were disabled. You may consider enabling this now to avoid forgetting they are disabled in the future.I edited my Apache Configuration:
I uncommented the following lines (remove
#
):How To Download And Install Mysql On Macos
If you develop multiple projects and would like each to have a unique url, you can configure Apache VirtualHosts for macOS.
If you would like to install PHPMyAdmin, return to my original post on installing Apache, PHP, and MySQL on macOS.
Find this interesting? Let's continue the conversation on Twitter.
Introduction
MySQL is an opensource, relational database management system. Its name is the combination of two words that are My + SQL where my is the name of co-founder Michael Widenius's daughter and SQL is the abbreviation of Structured Query Language.
MySQL is widely used as a database system in various well-known companies like Google and Facebook. In this tutorial, we will learn the installation process of MySQL server on MacOS.
Prerequisites
- MacOS
- Login as an administrator on terminal.
Mac Install Mysql 5.7
Installation
Following steps are used to install MySQL on MacOS.
1) Download the latest version
![Download And Install Mysql On Mac Download And Install Mysql On Mac](/uploads/1/1/8/5/118548604/566070011.jpg)
Download the latest version of MySQL community server that is 5.7.20 from its official website or simply copy and paste https://dev.mysql.com/downloads/file/?id=473576 into our browser search bar. The file will be downloaded in disk image format which is to be mounted first on our volumes directory.
2) Mount the disk image file
Hdiutil is used with the mount option to mount the disk image file on volumes directory of root.
3) Using Installer to Install MySQL package
The command installs MySQL community server to the root directory. During the installation process, it also sets the default password for root to access MySQL.
When we install MySQL on MacOS, a default username and password is created which is shown to the user at the time of installation.
4) Unmount the Disk Image File
The MySQL package mounted on volumes directory needs to be unmounted. Hdiutil is used with the unmount option to do so.
5) Starting MySQL
On MacOS, all the support files are located at /usr/local/MySQL. Support-Files contains MySQL.server which is actually started when we need to access our database. We must have the path information of MySQL server in order to start MySQL. We must have super user permissions to start and stop MySQL database.
6) Working on MySQL Command Line
1. Accessing from command line
To run MySQL from command line, we need to start MySQL server first. Then, following command will be executed.
Where root is the username and password is r>mpyW,-J4xS .
2. Create database
Download And Install Mysql On Mac Download
To create database, we need to execute a SQL query which is as follows.
![Download And Install Mysql On Mac Download And Install Mysql On Mac](/uploads/1/1/8/5/118548604/979458948.png)
7) Stopping MySQL
To stop database, use the following command.