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 Installer For Mac Os X 10 12
- Mysql Installer For Mac Os X Download
- Mysql Installer For 64-bit Mac Os X 10.6
Os x for macbook. Sep 29, 2016 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. PHP Update: Mac OS X Sierra comes pre-installed with PHP version 5.6, however the latest version of PHP is 7.1. After you complete this post, you should upgrade PHP on Mac OS X. Note: This post is for new installations. Sep 24, 2019 In this video I go through how to download and install MySQL on the Mac OS X. This is the 2019 installation guide, which also shows you how to set up your server and database access on your terminal. To actually install the MySQL PKG file, double-click on the package icon. This launches the Mac OS X Package Installer, which guides you through the installation of MySQL. Due to a bug in the Mac OS X package installer, you may see this error message in the destination disk selection dialog: You cannot install this software on this disk. Double-click the MySQL installer package. It will be named according to the MySQL version and the OS X version you have chosen. For example, if you have downloaded the package for MySQL 5.6.50 and OS X 10.8, double-click mysql-5.6.50-osx- 10.8-x8664.pkg. You will be presented with the opening installer dialog.
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. https://skyeycareer605.weebly.com/journal-template-for-os-x-pages.html. 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
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.
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.
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.![Mac Mac](/uploads/1/2/6/6/126606829/989592842.png)
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.
Mysql Installer For Mac Os X 10 12
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
#
):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.
- 2.4.1 General Notes on Installing MySQL on macOS
- 2.4.2 Installing MySQL on macOS Using Native Packages
- 2.4.3 Installing and Using the MySQL Launch Daemon
- 2.4.4 Installing and Using the MySQL Preference Pane
Mysql Installer For Mac Os X Download
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 Section 2.4.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 will need 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, Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”.In addition to the core installation, the Package Installer also includes Section 2.4.3, “Installing and Using the MySQL Launch Daemon” and Section 2.4.4, “Installing and Using the MySQL Preference Pane” to simplify the management of your installation.
Mysql Installer For 64-bit Mac Os X 10.6
For additional information on using MySQL on macOS, see Section 2.4.1, “General Notes on Installing MySQL on macOS”.