The main reason for the following post is for my personal benefit, so I can reference it and remember exactly how I setup everything when I need to do it again. Hopefully someone else can get something useful from this article, but really, that’s just a bonus. With that said, enjoy.

Before doing all the terminal stuff, you probably want to start with downloading iTerm. This is one of the best Terminal alternatives for Mac.

://www.iterm2.com/

First (real) step, install Homebrew

Homebrew is an essential part of Mac development. It bills itself as “The missing package manager for macOS”. With it we can quickly and easily install any number of packaged applications, utilities, and services.

Open up the terminal and paste the following snippet to download and install Homebrew.

://brew.sh/

/usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"

Since we’re going to use the built-in macOS web server, we’ll just setup MySQL

After installing Homebrew, installing other things, like MySQL, is super easy. Just type the following command into your terminal.

brew install mysql

[icon name=”info-circle” class=”” unprefixed_class=””] Here’s a little fix if later you can’t access your MySQL databases over Socket

// Reference: https://stackoverflow.com/a/18090173
sudo mkdir /var/mysql
sudo ln -s /tmp/mysql.sock /var/mysql/mysql.sock

Using DNSMasq for wildcard URLs and Redirects

// setup dnsmasq for smart urls and redirecting
brew install dnsmasq
#reference: https://gist.github.com/ogrrd/5831371

Edit the DNSMasq parameters to fit your local network setup/IP

echo 'address=/. localhost/192.168.0.188' > $(brew --prefix)/etc/dnsmasq.conf
echo 'listen-address=192.168.0.188' > $(brew --prefix)/etc/dnsmasq.conf

This will add the following to your dnsmasq.conf configuration file (/usr/local/etc/dnsmasq.conf)

address=/.localhost/192.168.0.188
listen-address=192.168.0.188

Setup the DNSMasq resolver directory for your IP address

// create dnsmasq resolver directory and file where 127.0.0.1 is your computer's static IP address
sudo mkdir -v /etc/resolver
sudo bash -c 'echo "nameserver 192.168.0.188" > /etc/resolver/localhost'

Restart DNSMasq

sudo launchctl stop homebrew.mxcl.dnsmasq
sudo launchctl start homebrew.mxcl.dnsmasq

Now, on to the Apache setup

Sorry, no easy terminal commands for this part. Just search through your apache configuration file for these bits and either replace, remove, or comment out.

[icon name=”info-circle” class=”” unprefixed_class=””] While I use Sublime Text for pretty much everything else, I use Atom for this. Atom is a wonderful text/code editor and it’s great for editing system files without a problem.

://atom.io

Open the Apache Configuration file (/private/etc/apache2/httpd.conf) and edit the following.

// set the server name
ServerName localhost

// edit the apache config file /private/etc/apache2/httpd.conf
<IfModule unixd_module>
User jonathan // add your username here
Group _www
</IfModule>

// uncomment these modules
LoadModule deflate_module libexec/apache2/mod_deflate.so
LoadModule expires_module libexec/apache2/mod_expires.so
LoadModule rewrite_module libexec/apache2/mod_rewrite.so
LoadModule vhost_alias_module libexec/apache2/mod_vhost_alias.so

// Before High Sierra, uncomment this
LoadModule php5_module libexec/apache2/libphp5.so
// Using High Sierra or beyond, look for something like this:
LoadModule php7_module libexec/apache2/libphp7.so

// comment out this
# <Directory />
# AllowOverride none
# Require all denied
# </Directory>

// change these directories to your web server root (the place you're hosting your sites locally)
DocumentRoot "/Users/jonathan/Documents/www"
<Directory "/Users/jonathan/Documents/www">

// uncomment the "httpd-vhosts.conf" file for the virtual hosts to work with dnsmasq
# Virtual hosts
Include /private/etc/apache2/extra/httpd-vhosts.conf

Finally, the Apache Virtual Hosts configuration

Edit the apache vhosts configuration file (/private/etc/apache2/extra/httpd-vhosts.conf)

This uses a free little micro service called nip.io for redirecting stuff on your local network using nice, easy to read URLs.

<Directory "/Users/jonathan/Sites">
 Options Indexes MultiViews FollowSymLinks
 AllowOverride All
 Order allow,deny
 Allow from all
</Directory>

<Virtualhost *:80>
 VirtualDocumentRoot "/Users/jonathan/Sites"
 ServerName home.localhost
 UseCanonicalName Off
</Virtualhost>

<Virtualhost *:80>
 VirtualDocumentRoot "/Users/jonathan/Sites/%1"
 ServerName sites.localhost
 ServerAlias *.localhost
 UseCanonicalName Off
</Virtualhost>

<Virtualhost *:80>
 VirtualDocumentRoot "/Users/jonathan/Sites/%-7+"
 ServerName nip
 ServerAlias *.nip.io
 UseCanonicalName Off
</Virtualhost>

Now, restart the Apache server and MySQL for good measure

sudo apachectl -k restart
mysql.server restart

Network DNS settings

In the System Preferences > Network section you’ll need to add an additional DNS server to your network connection (ethernet or wifi). Click on the “Advanced…” button for your active connection and then the DNS tab at the top of this dialog. Here you’ll need to use the + (plus) button to add, first your development machine’s IP address (in my case it would be the same one I’ve been using in the examples: 192.168.0.188), then the base IP address for your network (generally: 192.168.0.1). After that I usually add in at least one of Google’s DNS addresses (8.8.8.8 or 8.8.4.4) [Read more about that here].

The best, free, SQL database manager for Mac: Sequel Pro

://sequelpro.com/

Once, downloaded, unzip and move the Sequel Pro app to your Applications folder. Now, open it and setup a Socket connection. All you need is to enter “root” in the user field for now. If everything was setup correct you can now connect directly to your local MySQL server and start setting up your databases.

The first thing I like to do is setup a user for all my local databases.

Command+U brings up the User Accounts dialog. Press the + (plus) button at the bottom left of the User Accounts dialog and enter your username and password. Then go to the “Global Privileges” tab and press the “Check All” button and finally, the “Apply” button to save your new user account.

That’s it for database setup. Now you can add all the local databases you want.