macOS Update: While these instructions still work, there are new posts for recent versions of macOS, the latest being Install Apache, PHP, and MySQL on macOS Mojave.
Download Mac OS X 10.10 (x86, 64-bit), DMG Archive. Then you get to this lame screen: Then you get to this lame screen: MySQL is free and open source software (FOSS), you do not need to sign up. 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. Geeks Worldwide.
PHP Update: Mac OS X El Capitan comes pre-installed with PHP version 5.5 which has reached its end of life. After you complete this post, you should upgrade PHP on Mac OS X.
Note: This post is for new installations. If you have installed Apache, PHP, and MySQL for Mac OS X Yosemite, read my post on Updating Apache, PHP, and MySQL for Mac OS X El Capitan.
![Download And Install Mysql On Mac Download And Install Mysql On Mac](/uploads/1/2/6/2/126289766/285864015.jpg)
![Download And Install Mysql On Mac Download And Install Mysql On Mac](/uploads/1/2/6/2/126289766/977293714.jpg)
Mac OS X runs atop UNIX. So most UNIX software installs easily on Mac OS X. Furthermore, Apache and PHP come packaged with Mac OS X. To create a local web server, all you need to do is configure Apache and install MySQL.
I am aware of the web server software available for Mac OS X, notably MAMP. These get you started quickly. But they forego the learning experience and, as most developers report, can become difficult to manage.
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 Mac OS X
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 Mac OS X.
Now edit the Apache configuration. Feel free to use TextEdit 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 Mac OS X El Capitan 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 Mac OS X El Capitan
Download and install the latest MySQL generally available release DMG for Mac OS X.
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.Connect PHP and MySQL
You need to ensure PHP and MySQL can communicate with one another. There are several options to do so. I do the following:
Additional Configuration (optional)
The default configuration for Apache 2.4 on Mac OS X 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
#
):If you develop multiple projects and would like each to have a unique url, you can configure Apache VirtualHosts for Mac OS X.
If you would like to install PHPMyAdmin, return to my original post on installing Apache, PHP, and MySQL on Mac OS X.
Find this interesting? Let's continue the conversation on Twitter.
MySQL is a relational database management system. MySQL is the widely used database server in the world. This tutorial helps you to install MySQL database server on macOS Sierra 10.12 and High Sierra 10.13 and other supported versions using Homebrew.
Step 1 – Prerequisites
Before starting the installation of MySQL using this tutorial you must have the following prerequisites
- Terminal: You must have Mac Terminal access and little knowledge about working with the terminal application.
- Homebrew: Homebrew is a popular package management tools used for installing most open source software like Node. Here is the Homebrew installation tutorial
Step 2 – Install MySQL on macOS
At this time of writing this tutorial, Homebrew has MySQL 5.7.21 version in its main repository. Start a terminal and run command to install MySQL:
Wait for the installation process finish. Now you just need to configure things so that your MySQL server is auto-started
Also, you have to set a strong password for the MySQL root account. Use the following command to set a new password. Make sure to use a strong password.
Step 3 – MySQL Configuration
MySQL server has been installed on your system. The binary files are installed under /usr/local/bin directory and all the MySQL related files are created under “/usr/local/var/mysql” directory. The main confiugration file is created at:
You can use above file to customize your MySQL server. Now, Connect to MySQL server using the command:
Step 4 – Manage MySQL Service
There are mysql.server command available under /usr/local/bin directory, which is used to manage MySQL service. You can use mysql.server command with options status, stop, start, or restart MySQL service on your system.
Install Mysql Client On Mac
All done. You have running MySQL server on your system. What next? Visit our MySQL tutorial section to create and manage databases from the command line.