OSX Setup Web Server PHP MySQL Cheat Sheet by dockawash

 httpd
> Check version
httpd -v

 Apache
> Start & version
sudo apachectl start
> Test localhost in browser
http://localhost

 Setup user
> Create user Sites folder
mkdir ~/Sites

> Create or edit user apache .conf file, don't forget to replace USERNAME by yours
sudo nano /etc/apache2/users/USERNAME.conf

> Paste in USERNAME.conf
<Directory "/Users/*/Sites/">
    Options Indexes MultiViews FollowSymLinks
    AllowOverride All
    Require all granted
</Directory>

 httpd.conf
> Edit httpd.conf
sudo nano /etc/apache2/httpd.conf

> Uncomment these line to activate mandatories modules
LoadModule userdir_module libexec/apache2/mod_userdir.so
LoadModule alias_module libexec/apache2/mod_alias.so
LoadModule rewrite_module libexec/apache2/mod_rewrite.so
LoadModule php5_module libexec/apache2/libphp5.so

> Change default apache user _www to USERNAME in httpd.conf
User USERNAME
Group staff

> Allow .htaccess and Override
<Directory "/Library/WebServer/Documents">
    ...
    AllowOverride All
    ...
</Directory>

> Activate userdir conf
Include /private/etc/apache2/extra/httpd-userdir.conf

 httpd-userdir.conf
> Edit httpd-userdir.conf
sudo nano /etc/apache2/extra/httpd-userdir.conf
> Uncomment or add this line at the end
Include /private/etc/apache2/users/*.conf

 Restart apache
sudo apachectl restart

 PHP test file
> Create php test file
printf "<?php phpinfo(); ?>" > ~/Sites/phpinfo.php
> Test phpinfo in browser
http://localhost/~USERNAME/phpinfo.php

 Auto start apache
> Set to auto start
sudo launchctl load -w /System/Library/LaunchDaemons/org.apache.httpd.plist
> Unset to auto start
sudo launchctl unload /System/Library/LaunchDaemons/org.apache.httpd.plist

You can either way create a new folder in /Library/WebServer/Documents/ or in /Users/USERNAME/Sites/

 /Library/WebServer/Documents/
> Create MYWEBSITE folder
sudo mkdir /Library/WebServer/Documents/MYWEBSITE
> And the access in browser
http://localhost/MYWEBSITE

 /Users/USERNAME/Sites/
> Create MYWEBSITE folder
mkdir /Users/USERNAME/Sites/MYWEBSITE
> And the access in browser
http://localhost/~USERNAME/MYWEBSITE

 Download MySQL
http://dev.mysql.com/downloads/mysql/
> Get the .dmg install file for OSX 10.10 and install it

 Command line MySQL
> Start MySQL
sudo /usr/local/mysql/support-files/mysql.server start
> Check version
/usr/local/mysql/bin/mysql -v

 Change $PATH
> edit profile
nano ~/.bash_profile
> add this line
export PATH="/usr/local/mysql/bin:$PATH"
> validate new profile
source ~/.bash_profile
> test change
mysql -v

 Change MySQL root password
/usr/local/mysql/bin/mysqladmin -u root password 'yourpasswordhere'

 Fix the 2002 MySQL Socket error
> Error in PhpMysql
sudo mkdir /var/mysql
sudo ln -s /tmp/mysql.sock /var/mysql/mysql.sock

 Download PhpMyAdmin
https://www.phpmyadmin.net/downloads/

 Extract in /Users/USERNAME/Sites/
> Then access it
http://localhost/~USERNAME/phpMyAdmin

 Extract in /Library/WebServer/Documents/
> Then access it
http://localhost/phpMyAdmin

 Set httpd.conf
> Edit httpd.conf
sudo nano /etc/apache2/httpd.conf
> Uncomment
Include /private/etc/apache2/extra/httpd-vhosts.conf
LoadModule vhost_alias_module libexec/apache2/mod_vhost_alias.so

 Set the vhosts.conf file
> Edit vhosts.conf
sudo nano /etc/apache2/extra/httpd-vhosts.conf

> Exemple vhost
<VirtualHost *:80>
    ServerName mywebsite.com
    ServerAlias www.mywebsite.com
    DocumentRoot "/Users/USERNAME/Sites/mywebsite"
    ErrorLog "/private/var/log/apache2/mywebsite.com-error_log"
    CustomLog "/private/var/log/apache2/mywebsite.com-access_log" common
    ServerAdmin web@mywebsite.com

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

 Restart apache
sudo apachectl restart

 Set the hosts file
> Edit hosts
sudo nano /etc/hosts
> Add this to map domain
127.0.0.1 mywebsite.com www.mywebsite.com
> Flush cache
dscacheutil -flushcache
sudo dscacheutil -flushcache

 Losing localhost
Fix the 403 Forbidden Error

> Edit httpd-vhosts.conf
sudo nano /etc/apache2/extra/httpd-vhosts.conf
> Add in
<VirtualHost *:80>
    ServerName localhost
    DocumentRoot /Library/WebServer/Documents/
</VirtualHost>

 Change default apache user and group
> Get username and group
id
uid=501(USERNAME) gid=20(staff)
> Edit httpd.conf
sudo nano /etc/apache2/httpd.conf
> Change these lines to
User USERNAME
Group staff

 Restart apache
sudo apachectl restart