- Install Php Mysql Apache Mac Os X
- Linux Apache Mysql Php
- Apache Mysql Php Install
- Php Mysql Apache For Mac Os High Sierra
MAMP is good, but it's gonna install everything from scratch. The same goes for PHP via homebrew. I have tried all of those. But you have to remember that your Mac comes bundled with Apache and PHP out of the box. You just have to add MySQL to the mix and get rolling. I have been using XAMMP on my mac, it was working fine before OS update to Catalina. I am not able to start MySQL and Apache. I read the blog that Apache and Php are built-in with Mac OS Catalina, this might be the issue, I have been using 64-bit XAMMP. Part 1: macOS 10.15 Catalina Web Development Environment. Developing web applications on macOS is a real joy. There are plenty of options for setting up your development environments, including the ever-popular MAMP Pro that provides a nice UI on top of Apache, PHP and MySQL.However, there are times when MAMP Pro has slow downs, or out of date versions, or is simply behaving badly due to its.
How to install and configure Apache, MySQL and PHP on Mac OS X 10.7 Lion and OS X 10.6 Snow Leopard.
How to Set Up PHP, HTML & MySQL Development on Mac OS X February 7, 2017 Comparatio 0 The following are instructions for setting up a development environment on a Mac that can be used for HTML, PHP and MySQL. How to install and configure Apache, MySQL and PHP on Mac OS X 10.7 Lion and OS X 10.6 Snow Leopard. OSX 10.8 Mountain Lion Version OSX 10.9 Mavericks Version Apache and PHP already come preloaded in OS X 10.7 Lion and 10.6 Snow Leopard, the versions on 10.7 Lion are PHP 5.3.6 and Apache 2.2.20, these 2 pieces of Open Source software are part of the “AMP” stack with MySQL the missing.
OSX 10.8 Mountain Lion VersionOSX 10.9 Mavericks Version
Apache and PHP already come preloaded in OS X 10.7 Lion and 10.6 Snow Leopard, the versions on 10.7 Lion are PHP 5.3.6 and Apache 2.2.20, these 2 pieces of Open Source software are part of the “AMP” stack with MySQL the missing third component.
Apache and PHP already come preloaded in OS X 10.7 Lion and 10.6 Snow Leopard, the versions on 10.7 Lion are PHP 5.3.6 and Apache 2.2.20, these 2 pieces of Open Source software are part of the “AMP” stack with MySQL the missing third component.
Their are other options for Mac users to install an AMP stack using prebuilt point and click downloads including the following, MAMP, DAMP, XAMPP and BitNami – these installations use separate binaries outside of the regular OS X software so no conflict occurs and it makes it easier to delete the stacks without affecting other parts of the operating system.
However sometimes you need to configure these with different port numbers and this can lead to issues and there is the question of vendor support and application versions.
This tutorial bypasses the 3rd party AMP stacks and uses the native installed components with the exception of MySQL which is a separate install, unless you have OS X Server, which then MySQL comes preloaded in 10.6 but not 10.7 which has dumped MySQL in favour of PostgreSQL instead – you can still install MySQL on 10.7 Server with the instructions below.
To get Apache, MySQL and PHP running natively on OSX is quite easy and straightforward – this guide should have you up and running in no time.
This guide uses the command line to achieve some text editing of various configuration files, however If you aren’t comfortable in the Terminal you can do this in a graphical mode, download a free text editor utility call TextWrangler, launch it, when you come to edit one of the configuration files, open file, you have to click on “show hidden items” at the bottom of the open dialog box to see all of the system files. But you will still need to use the terminal for some of the commands which don’t involve editing files.
PHP
You can verify your version of PHP by launching the Terminal application, as found in the Utilities folder: /Applications/Utilities/Terminal
To find the PHP version, type at the prompt:
And the version is displayed:
To find the Apache version, type at the prompt:
And the version is displayed:
So far so good, however by default PHP is not enabled and has to have its module loaded you need to make a simple edit in the Apache configuration file “httpd.conf” file. This is filed in /etc/apache2/httpd.conf, get there in the terminal by typing:
Then in the terminal you need to use a text editor either “vi” or nano” will do, this file also has stricter permissions so the “sudo” command needs to be used to edit the file, you will need to be an admin user to have permission to change the file, type:
and then your password.
Once in nano click “control+w” to get a search dialog, type “php” and this will bring you to the php module line:
Uncomment out the hash # to leave it like:
enable php module in nano
Finally type “control + x” to exit and when prompted save the change by typing “y”
MySQL
So now onto the 2nd piece of the puzzle, MySQL. You need to download it from http://dev.mysql.com/downloads/mysql/, chose Mac OS X ver. 10.7 (x86, 64-bit), DMG Archive for an Intel Mac the .dmg file is a point and click installation nice and easy, you can download the tar.gz also for a command line install. The easiest format is the .dmg file as it allows for an installation visually using the GUI.
When downloading you don’t have to sign up, look for » No thanks, just take me to the downloads! – go straight to the download mirrors and download the software from a mirror which is closest to you.
After download open the .dmg and install:
- mysql5.6.xxx.pkg
- MySQLstartupitem.pkg
- MySQLPrefPane
The first is the MySQL software, the 2nd item allows MySQL to start when the Mac is booted and the third is a System Preference that allows start/stop operation and a preference to enable it to start on boot.
- Installation of MySQL
Once the installs are done you can start the mysql server right from the System Preferences which has a new preference in the “Other” category called “MySQL” click start and now it is running.
mysql-system-preference-osx
To find the MySQL version from the terminal, type at the prompt:
This also puts you in to an interactive dialogue with mySQL, type q to exit.
If you got the error:
then mysql was not started, go back to the System Preference and start the database.
After installation, in order to use mysql commands without typing the full path to the commands you need to add the mysql directory to your shell path, this is done in your “.bash_profile” file in your home directory, if you don’t have that file just create it using vi or nano:
and then add:
The first command brings you to your home directory and opens the .bash_profile file or creates a new one if it doesn’t exist, then add in the line above which adds the mysql binary path to commands that you can run. Exit the file with type “control + x” and when prompted save the change by typing “y”. Last thing to do here is to reload the shell for the above to work straight away.
Then test the path by just this time issuing the mysql command without the full path:
You will get the version number again, just type “q” to exit.
The next step is to set up a root password for mysql there are 2 ways to do this one is a regular way and the other provides additional security and disables all other access:
Regular Way
If you have set the path correctly as above:
!use the single quotes
Then when logging in to mysql:
!NB the no space between -p and the password
Securer Way
Go ahead and just hit enter if this is a new installation and no password currently exists, follow the prompts to set up a new root password – this is a root password just for mysql separate from the root password of OS X you should set this.
You also get asked about:
- Removing anonymous users?
- Disallow root login remotely?
- Remove test database and access to it?
- Reload privilege tables now?
If this is a new installation you can just answer yes to the questions.
Once the root user and password is set, you have to interact with mysql with the username and password, so access via command line is (note that there is no space between -p and the password):
So thats the two components installed with MySQL having a System Preference option to Start/Stop the database.
Apache
You can start/stop the Web Server Apache in the System Preferences under Sharing and checking the WebSharing box. (Sometimes you may have to toggle it on/off a few times to get it going).
web-sharing-turned-on
This can also be accomplished in the terminal using:
Or restart the web server gracefully using the following:
Once you start your server the there are 2 x document root folders for sharing, one is a top level and the other is user account specific:
and
You should see a “It Works!” or a OSX welcome page depending on which document root you are at, in the finder these locations are found at your Sites folder in your home folder for local user:
/Users/username/Sites/
/Users/username/Sites/
or at the higher level
/Library/WebServer/Documents/
At the user level in Lion 10.7 you may need to create the personal web sharing folder first, do this through System Preferences > Sharing > Web Sharing and click “Create Personal Website Folder” if it is created this will say ” Open Personal WebSite Folder”
The final thing to verify is that PHP is loaded and ready to go by creating a new text file, has to be plain text (use TextEdit) and typing in:
Save the file as phpinfo.php and save it to the Sites folder in your home directory. Now point your browser to:
You should see the full PHP configuration page. If you just see the code restart the web server to make sure the php module is loaded.
- php-module-configuration
That’s it you are ready to develop and share!
The only difference between 10.6 and 10.7 are some incremental version numbers on Apache and MySQL otherwise the process is the same for both operating systems.
To get up and running with mysql and use phpMyAdmin to manage the mysql database, there is a guide here.
Then look at installing WordPress, Drupal and Joomla!!!
First part in a multi-part blog series for Mac developers
Part 1: macOS 10.15 Catalina Web Development Environment
Developing web applications on macOS is a real joy. There are plenty of options for setting up your development environments, including the ever-popular MAMP Pro that provides a nice UI on top of Apache, PHP and MySQL. However, there are times when MAMP Pro has slow downs, or out of date versions, or is simply behaving badly due to its restrictive system of configuration templates and non-standard builds.
It is times like these that people often look for an alternative approach, and luckily there is one, and it is relatively straight-forward to setup.
In this blog post, we will walk you through setting up and configuring Apache 2.4 and multiple PHP versions. In the second blog post in this two-post series, we will cover MySQL, Apache virtual hosts, APC caching, and Xdebug installation.
[Updated 12/02/2019] Updated to reflect the latest release of PHP 7.4 and the removal of PHP 7.1 from Official tap
[Updated 10/08/2019] Updated to reflect the release of macOS 10.15 Catalina
[Updated 01/10/2019] Updated to add back PHP 5.6 and PHP 7.0 from and external deprecated keg
[Updated 12/12/2018] Updated to reflect the latest release of PHP 7.3 and the removal of PHP 7.0 from Brew.
[Updated 10/08/2019] Updated to reflect the release of macOS 10.15 Catalina
[Updated 01/10/2019] Updated to add back PHP 5.6 and PHP 7.0 from and external deprecated keg
[Updated 12/12/2018] Updated to reflect the latest release of PHP 7.3 and the removal of PHP 7.0 from Brew.
If you have followed this guide in the past with the
Homebrew/php
tap, and are looking to upgrade to the new Homebrew/core
approach, then you should first clean-up your current installation by following our new Upgrading Homebrew.This guide is intended for experienced web developers. If you are a beginner developer, you will be better served using MAMP or MAMP Pro.
If you don't already have XCode installed, it's best to first install the command line tools as these will be used by homebrew:
This process relies heavily on the macOS package manager called Homebrew. Using the
brew
command you can easily add powerful functionality to your mac, but first we have to install it. This is a simple process, but you need to launch your Terminal (/Applications/Utilities/Terminal
) application and then enter:Just follow the terminal prompts and enter your password where required. This may take a few minutes, but when complete, a quick way to ensure you have installed
brew
correctly, simply type:You should probably also run the following command to ensure everything is configured correctly:
It will instruct you if you need to correct anything.
Catalina Required Libraries
When installing fresh on Catalina, I ran into a few libraries that were missing when completing all the steps below. To make things easier, please simply run these now:
The latest macOS 10.15 Catalina comes with Apache 2.4 pre-installed, however, it is no longer a simple task to use this version with Homebrew because Apple has removed some required scripts in this release. However, the solution is to install Apache 2.4 via Homebrew and then configure it to run on the standard ports (80/443).
If you already have the built-in Apache running, it will need to be shutdown first, and any auto-loading scripts removed. It really doesn't hurt to just run all these commands in order - even if it's a fresh installation:
Now we need to install the new version provided by Brew:
Without options, httpd won't need to be built from source, so it installs pretty quickly. Upon completion you should see a message like:
Now we just need to configure things so that our new Apache server is auto-started
You now have installed Homebrew's Apache, and configured it to auto-start with a privileged account. It should already be running, so you can try to reach your server in a browser by pointing it at
http://localhost:8080
, you should see a simple header that says 'It works!'.Troubleshooting Tips
If you get a message that the browser can't connect to the server, first check to ensure the server is up.
You should see a few httpd processes if Apache is up and running.
Try to restart Apache with:
You can watch the Apache error log in a new Terminal tab/window during a restart to see if anything is invalid or causing a problem:
Apache is controlled via the
apachectl
command so some useful commands to use are:The
-k
will force a restart immediately rather than asking politely to restart when apache is good and readyVisual Studio Code
In past guides, I've always provided instructions to edit files using the default
TextEdit
application that comes pre-installed. However, this is not what I use myself as it's a terrible editor and when testing my guide for Catalina, I kept running into problems with encoding, finding line numbers etc. The better solution is to simply install a better editor. So please install the amazingly versatile yet, 100% free, Visual Studio Code. It's available on Mac, Windows, and Linux, but right now we only care about the mac version.Go to the Visual Studio Code site and click Download for Mac
Once downloaded, drag the application to your preffered Applications location. Next, you want to install the command line tools, so follow the official step-by-step instructions so that you can use the
code
command from the Terminal.Apache Configuration
Now that we have a working web server, we will want to do is make some configuration changes so it works better as a local development server.
In the latest version of Brew, you have to manually set the listen port from the default of
8080
to 80
, so we will need to edit Apache's configuration file.If you followed the instructions above you should be able to use Visual Studio Code to edit your files using the
code
Terminal command. However, if you want to use the default TextEditor application to perform edits, you can use the open -e
command followed by the path to the file.Find the line that says
and change it to
80
:Next we'll configure it to use the to change the document root for Apache. This is the folder where Apache looks to serve file from. By default, the document root is configured as
/usr/local/var/www
. As this is a development machine, let's assume we want to change the document root to point to a folder in our own home directory.Search for the term
DocumentRoot
, and you should see the following line:Change this to point to your user directory where
your_user
is the name of your user account:You also need to change the
<Directory>
tag reference right below the DocumentRoot line. This should also be changed to point to your new document root also:We removed the optional quotes around the directory paths as TextEdit will probably try to convert those to smart-quotes and that will result in a Syntax error when you try to restart Apache. Even if you edit around the quotes and leave them where they are, saving the document may result in their conversion and cause an error.
In that same
<Directory>
block you will find an AllowOverride
setting, this should be changed as follows:Also we should now enable mod_rewrite which is commented out by default. Search for
mod_rewrite.so
and uncomment the line by removing the leading #
:User & Group
Now we have the Apache configuration pointing to a
Sites
folder in our home directory. One problem still exists, however. By default, apache runs as the user daemon
and group daemon
. This will cause permission problems when trying to access files in our home directory. About a third of the way down the httpd.conf
file there are two settings to set the User
and Group
Apache will run under. Change these to match your user account (replace your_user
with your real username), with a group of staff
:Servername
Apache likes to have a server name in the configuration, but this is disabled by default, so search for:
and replace it with:
Sites Folder
Now, you need to create a
Sites
folder in the root of your home directory. You can do this in your terminal, or in Finder. In this new Sites
folder create a simple index.html
and put some dummy content in it like: <h1>My User Web Root</h1>
.Restart apache to ensure your configuration changes have taken effect:
If you receive an error upon restarting Apache, try removing the quotes around the DocumentRoot and Directory designations we set up earlier.
Pointing your browser to
http://localhost
should display your new message. If you have that working, we can move on!If you have existing PHP installations via Brew, you need to first cleanup your setup with our Upgrading Homebrew guide before continuing with this section.
Up until the end of March 2018, all PHP related brews were handled by
Homebrew/php
tab, but that has been deprecated, so now we use what's available in the Homebrew/core
package. This should be a better maintained, but is a much less complete, set of packages.Install Php Mysql Apache Mac Os X
PHP 5.6, PHP 7.0, and PHP 7.1 have been deprecated and removed from Brew because they are out of support, and while it's not recommended for production, there are legitimate reasons to test these unsupported versions in a development environment. These versions also need to 'built from source' in order to use the latest versions of
icu4c
and openssl
.Remember only PHP 7.2 through 7.4 are officially supported by Brew so if you want to install PHP 5.6, PHP 7.0, or PHP 7.1 you will need to add this tap:
We will proceed by installing various verions of PHP and using a simple script to switch between them as we need. Feel free to exclude any versions you don't want to install.
You no longer have to
unlink
each version between installing PHP versions as they are not linked by defaultAlso, you may have the need to tweak configuration settings of PHP to your needs. A common thing to change is the memory setting, or the
date.timezone
configuration. The php.ini
files for each version of PHP are located in the following directories:Let's switch back to the first PHP version now:
At this point, I strongly recommend closing ALL your terminal tabs and windows. This will mean opening a new terminal to continue with the next step. This is strongly recommended because some really strange path issues can arise with existing terminals (trust me, I have seen it!).
Quick test that we're in the correct version:
Apache PHP Setup - Part 1
You have successfully installed your PHP versions, but we need to tell Apache to use them. You will again need to edit the
/usr/local/etc/httpd/httpd.conf
file scroll to the bottom of the LoadModule
entries.If you have been following this guide correctly, the last entry should be your
mod_rewrite
module:Below this add the following
libphp
modules:We can only have one module processing PHP at a time, so for now, so we have left our
[email protected]
entry uncommented while all teh others are commented out. This will tell Apache to use PHP 5.6 to handle PHP requests. (We will add the ability to switch PHP versions later).Also you must set the Directory Indexes for PHP explicitly, so search for this block:
and replace it with this:
Save the file and stop Apache then start again, now that we have installed PHP:
Validating PHP Installation
The best way to test if PHP is installed and running as expected is to make use of phpinfo(). This is not something you want to leave on a production machine, but it's invaluable in a development environment.
Simply create a file called
info.php
in your Sites/
folder you created earlier with this one-liner.Point your browser to
http://localhost/info.php
and you should see a shiny PHP information page:If you see a similar phpinfo result, congratulations! You now have Apache and PHP running successfully. You can test the other PHP versions by commenting the
LoadModule ... [email protected] ...
entry and uncommenting one of the other ones. Then simply restart apache and reload the same page.Linux Apache Mysql Php
PHP Switcher Script
We hard-coded Apache to use PHP 5.6, but we really want to be able to switch between versions. Luckily, some industrious individuals have already done the hard work for us and written a very handy little PHP switcher script.
We will install the
sphp
script into brew's standard /usr/local/bin
:Check Your Path
Homebrew should have added its preferred
/usr/local/bin
and /usr/local/sbin
to your path as part of its installation process. Quickly test this by typing:If you don't see this, you might need to add these manually to your path. Depending on your shell your using, you may need to add this line to
~/.profile
, ~/.bash_profile
, or ~/.zshrc
. We will assume you are using the default bash shell, so add this line to a your .profile
(create it if it doesn't exist) file at the root of your user directory:Testing the PHP Switching
After you have completed these steps, you should be able to switch your PHP version by using the command
sphp
followed by a two digit value for the PHP version:You will probably have to enter your administrator password, and it should give you some feedback:
Test to see if your Apache is now running PHP 7.1 by again pointing your browser to
http://localhost/info.php
. With a little luck, you should see something like this:Upgrading your system to PHP 7.4
If you have already installed this setup prior to December 2019, where PHP 7.3 was the latest, you can easily update your setup to support the new PHP 7.4 version with a few steps:
- Update to latest PHP 7.4 with
brew update && brew upgrade
- This will upgrade the default
php
package from 7.3 to 7.4. You then need to re-install PHP 7.3 with:brew install [email protected]
- Update the PHP switcher script (
sphp
) with the latest version that adds support for PHP 7.4 by re-running the commands: - Add a new entry in your
httpd.conf
for the PHP 7.4'slibphp
below the 7.3 entry: - Next you have to create a symbolic link for
/usr/local/opt/[email protected]
as brew installs PHP 7.4 as/usr/local/opt/php
:
That's it, just
sphp 7.4
to Switch to PHP 7.4 and you should be good to go!Apache Mysql Php Install
Updating PHP and other Brew Packages
Brew makes it super easy to update PHP and the other packages you install. The first step is to update Brew so that it gets a list of available updates:
This will spit out a list of available updates, and any deleted formulas. To upgrade the packages simply type:
You will need to switch to each of your installed PHP versions and run update again to get updates for each PHP version and ensure you are running the version of PHP you intend.
Activating Specific/Latest PHP Versions
Due to the way our PHP linking is set up, only one version of PHP is linked at a time, only the current active version of PHP will be updated to the latest version. You can see the current active version by typing:
And you can see the specific versions of a PHP package by typing:
OK, that wraps up Part 1 of this 3 part series You now have a fully functional Apache 2.4 installation with a quick-and-easy way to toggle between PHP 5.6, 7.0, 7.1, 7.2, 7.3 and 7.4. Check out Part 2 to find out how to setup your environment with MySQL, Virtual Hosts, APC caching, YAML, and Xdebug. Also take a gander at Part 3 to find out how to setup SSL for your Apache Virtual Hosts.