The phpMyAdmin Tutorial

phpMyAdmin is a web-based front end to control MySQL.

In order to get phpMyAdmin setup on your account, you need to get the files and configure them to work with your database.
Simply highlight the the commands in the "setup", open a terminal window and press the middle mouse button (scroll wheel).
BUT! Before you do it, know that this will open emacs session in a file. Look at the "configure" section to see what you need to change in that file.

Removing old versions:

If you have old versions of phpMyAdmin installed via this tutorial and you want to remove them please use the following:

rm -rf ~/www/HTML/mysqladmin ~/www/HTML/phpMyAdmin-*

Installing the CS version:

mkdir -p ~/www/HTML
chmod 755 ~/www/
chmod 755 ~/www/HTML/
(cd ~/www/HTML/; tar jvxf /seu/public/repository/phpMyAdmin/phpMyAdmin-2.9.1.1-english.tar.bz2)
ln -s ~/www/HTML/phpMyAdmin-2.9.1.1-english ~/www/HTML/mysqladmin
chmod -R 755 ~/www/HTML/mysqladmin/
cp -p /seu/public/repository/phpMyAdmin/phpMyAdmin-2.9.1.1-english-sample-config ~/www/HTML/mysqladmin/config.inc.php
emacs +18 ~/www/HTML/mysqladmin/config.inc.php

Configure:

First you need to enter a random string for the blowfish_secret. This will be used as part of the cookie based authentication system

$cfg['blowfish_secret'] = 'Enter some random string here*(@#TY';

Save the config.inc.php file and exit emacs.

Test:

Test it out from a web browser. Go to the URL http://www.cs.stedwards.edu/~yourusername/mysqladmin
You should now have access to your database using the web browser. Isn't it wonderful..
For more information on using phpmyadmin, check out http://www.phpmyadmin.net