Web Sharing and Mountain Lion Client

The non-server version of Mountain Lion does not include a check box for Web Sharing in the Sharing System Preferences, which had been included in all previous versions. Twenty more dollars for Server is not much to get a easy check box, but you don’t need to.

The easy solution is going to Tyler Hall‘s site and he made a Preference Pane to enable/disable Web Sharing, just unzip and double click.

To get Apache going manually open the Terminal and enter these commands:

To Start:

sudo apachectl start

To Stop:

sudo apachectl stop

To Restart:

sudo apachectl restart

Apache Version:

httpd -v

Opening your browser of choice and typing localhost, it should result in “It Works!”

Document Root

Document root is the location where the files are shared from the file system and is similar to the traditional names of ‘public_html’ and ‘htdocs’, OSX has 2 web roots, one at a system level and one at a user level – you can set both up or just run with one, the user level one allows multiple acounts to have their own web root whilst the system one is global for all users. It seems there is less effort from Apple in continuing with the user level one but it still can be set up with a couple of extra tweaks.

System Level Web Root

– The default system document root is still found at: –

http://localhost/

The files are shared in the filing system at –

/Library/WebServer/Documents/

User Level Root

The user document root level ‘~/Sites‘ folder no longer exists in the User account, you need to make a folder and rename it “Sites” then it will work.

Check that you have a “username.conf” filed under:

/etc/apache2/users/

If you don’t, then create one named by the short username of the account with the suffix.conf, its contents should be (swap in the real username):

cd /etc/apache2/users

sudo nano username.conf

Then add the content below swapping in your username:

<directory "="" users="" username="" sites="">
Options Indexes MultiViews
AllowOverride All
Order allow,deny
Allow from all

Permissions on the file should be:

-rw-r--r--   1 root  wheel  298 Jun 28 16:47 username.conf

If not you need to change…

sudo chmod 755 username.conf

Restart Apache for the new file to be read:

sudo apachectl restart

Then this user level document root will be viewable at:

http://localhost/~username/

——————————————————————————-

PHP

PHP 5.3.13 is loaded in OSX 10.8 Mountain Lion and needs to be turned on by uncommenting a line in the httpd.conf file.

sudo nano /etc/apache2/httpd.conf

Use “control” + “w” to search and search for ‘php’ this will land you on the right line then uncomment the line (remove the #):

LoadModule php5_module libexec/apache2/libphp5.so

Write out and Save using the nano short cut keys at the bottom ‘control o’ and ‘control x’

Re-load apache to kick in

sudo apachectl restart

To see and test PHP, create a file name it “phpinfo.php” and file it in your document root with the contents below, then view it in a browser.

<!--?php phpinfo(); ?>

——————————————————————————-

MySQL

MySQL is again a missing component in OS X 10.8 and needs to be dowloaded from the MySQL site use the Mac OS X 10.6 (64-bit), DMG Archive version (works fine on 10.8).

Once downloaded, install the 3 components.

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.

You can start the MySQL server from the System Preferences or via the command line.

sudo /usr/local/mysql/support-files/mysql.server start

To find the MySQL version from the terminal, type at the prompt:

/usr/local/mysql/bin/mysql -v

This also puts you in to an interactive dialogue with mySQL, type q to exit.

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, (optional step) 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:

cd ; nano .bash_profile

export PATH="/usr/local/mysql/bin:$PATH"

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.

source ~/.bash_profile

mysql -v

You will get the version number again, just type “q” to exit.

Set the root password

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

Use the single ‘quotes’ surrounding the password

——————————————————————————-

phpMyAdmin

Download phpMyAdmin, the english.tar.gz should be sufficient, after the file is downloaded decompress it and move it to your personal web sharing folder “/Users/username/Sites” directory or other web root folder.

Rename the folder from “phpMyAdmin-3.5.2-english” to “phpmyadmin“. The rest of the tutorial assumes that you have already mysql set up with a mysql root user and password enabled if not then please follow that process first.

The login address for phpMyAdmin is going to be http://localhost/~username/phpmyadmin/ or http://localhost/phpmyadmin depending on your web root directory, but before this will work correctly a few steps need to be done namely addressing the MySQL socket error and configuration file set up:

a) Launch /Applications/Utilities/Terminal to fix the mysql 2002 socket error by entering the following commands:

sudo mkdir /var/mysql
sudo ln -s /tmp/mysql.sock /var/mysql/mysql.sock

b) In the phpmyadmin folder in your web root make a new directory named “config”.

mkdir ~/Sites/phpmyadmin/config

c) Give Others “write”permissions to the “/phpmyadmin/config” folder either through Get Info or a ‘chmod o+w’ in Terminal.

chmod o+w ~/Sites/phpmyadmin/config

Installing phpMyAdmin

Older Safari browser currently has issues with the installation, blank screens?? Upgrade to Safari 6 or use either Chrome or Firefox.

Now we are ready to run the set up in the browser by going to:

http://localhost/~username/phpmyadmin/setup/

The new server to be configured is the localhost, click new server and then the only other configurations are the local mysql user and the password in the Authentication tab.

Add in the username, by default “root” is assumed, add in the password, click on save and you are returned to the previous screen.

Make sure you click on save, then a config.inc.php is now in the /config directory, move this file to the root level of /phpmyadmin and then remove the now empty /config directory.

Now going to http://localhost/~username/phpmyadmin/ will now allow you to interact with your MySQL databases.

Upgrading phpMyAdmin is an easy task just grab the latest version from the phpmyadmin website and replace your older phpMyAdmin directory in your web shared folder apart from the “config.inc.php” file – make sure the config.inc.php is kept and put it back in the new directory.

Via: Coolest Guy