OSX Setup Web Server PHP MySQL Cheat Sheet

A Programming › PHP cheat sheet in English by dockawash

Setting up web server on osx 10.10

Apache MySQL Web Server Mac OSX Httpd Hosts Vhosts

13,406 views 4,060 downloads 26 Mar 2016 History

PRs

4.6 avg · 2 ratings

Apache Setup

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

Add New Website

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

Install PHP70

http://w3bsmart.blogspot.fr/2015/08/installing-php-7-on-os-x-yosemite.html

MySQL Setup

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

PhpMyAdmin

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

Setup a local domain

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

Badges

Nice Cheat Sheet Good Cheat Sheet Downloaded from Unusual Locations × 2

Comments

No comments yet.