MacXperience.com

We have previously activated Apache Web Server and the native PHP packed with Mac OS X. We have managed to host static pages and also dynamic functionality using PHP. Now, its time to get ourselves the Database tier, the ever famous MySql Server. More info on MySql here. Hence, we will be completing the OS , Apache, MySql & PHP stack, commonly called LAMP for Linux, WAMP for Windows and MAMP for Mac OS X.

Get the tools:

• We can download the latest version of MySql Community Open Source version for Mac form its official site, here. (approx. 61 MB)
• We can also download some GUI tools namely MySql Administrator, Query Browser etc. from here.
• Also, We’ll download the famous web based PHP management tool PHPMyAdmin from here.

Installation:

Installation is pretty straight forward, click and enjoy, nothing fancy about it. The MySql installation package, version 5.0.45 contains 4 items, namely:

• MySql-5.0.45-ox10.4-i686.pkg (The main installation file)
• MySqlStartupItem.pkg (If you want MySql to start automatically on OS boot, then must install it)
• MySql.PrefPane (Copy this file into MacintoshHD > Library > PreferencePane, to control Start/Stop MySql)
• Readme.txt (much about everything I have mentioned above and much more, Please Read)

The above process applies for both Tiger & Leopard.

Post-Installation:

Here, I’m going to refer original documentation for consultation. But, I’ll lay down the basic idea. At the time of installation, the default user created is “Root” without any password. We need to assign password to the “Root” user. In my installation on Leopard, using the GUI based tools, I was able to do pretty much anything. But on Tiger with PhpMyAdmin I was given password invalid message. Therefore, It is better to follow what MySql recommends.

• Please read Installing MySql on Mac OS X for detailed instructions and settings
• Post Installation procedures covers issues regarding applying password to the Root user etc.
• Securing the initial MySql Accounts
• Mac OS X specific notes

Managing MySql through GUI Tools:

I have tried both MySql provided GUI tools and web based ever famous PhpMyAdmin. The GUI tools were quite easy to install and use.

For PhpMyAdmin, just read the Installation instructions under documentation. We need to configure one Config file, which pretty much covers every behavior of the application with MySql.

This completes our LAMP stack. Happy coding from here and give us the next start-up 3.0

Related Posts

• Forbidden 403 error in Leopard Mac OS 10.5 with Web Sharing On
• Serving PHP with Mac OS X
• Web Development on the iPad