Adobe GoLive Tutorials

Installing phpMyAdmin

Untar phpMyAdmin and place the folder in your webserver's document root. You can use the free Stuffit Lite to untar the file. Let's look at the following directions from documentation.txt:

Open the file config.inc.php3 in your favourite editor and change the values for host, user, password and authentication mode to fit your environment. Also insert the correct value for$cfgPmaAbsoluteUri. Have a look at Configuration section for an explanation of all values.

So let's launch TextEdit, navigate to the phpMyAdmin folder and open the config.inc.php file, and see where we add the URI and the user name and password.

URI for your localhost

Scroll down just a little bit into the file. It won't be long before you will see something like what is at the bottom line in this screen shot. Where you see the variable $cfgPmaAbsoluteUri, you will see a null value with just single quotes: ' '. Add the value for your computer and phpMyAdmin version.

Take note of the URL, because you will access myPhpAdmin with it from within your browser. For instance, I type in http://127.0.0.1/phpMyAdmin-2.2.6/index.php (adding the index.php.) You may want to bookmark the page the first time you find it successfully.

Now let's add your user name and password. Remember that the user will be the administrator of the machine, but the password of the mySQL user! So you will probably enter "root" as the user, and the password you entered when you set up mySQL in the terminal. (You did set up a password for your mySQL user, didn't you?) Let's look at a screen shot:

user name and password

Scroll down till you see the variables for the user name and password. Enter them between the single quotes.

The documentation further recommends that you protect the directory in which the phpMyAdmin folder resides unless you are using it as a sole user on your own machine.

Otherwise, you're ready to type the URI you entered earlier to access phpMyAdmin right in your browser.

Future tutorials will delve into how to use the interface.