Uploading and configuring PHPMyAdmin

1. Download the latest version of phpmyadmin available from: http://www.phpmyadmin.net/home_page/ (choose the zip option)

2. Extract the contents of the zip file to a folder on your desktop

3. Browse to the files inside the new folder you have created.

4. You have to configure phpMyAdmin to recognize your ISP's server settings. Edit the config.inc.php file using note pad or word pad

5. Only the following changes must be made:

$cfg['PmaAbsoluteUri'] = 'http://test.com/admin/';

Change this setting to reflect the full pathname and the directory where phpMyAdmin

is located. For example: test.com/admin/

$cfg['Servers'][$i]['host'] = '62.69.64.179';

Place the host name here

$cfg['Servers'][$i]['auth_type'] = 'config';

Make certain this option is set to config. It may be there by default.

$cfg['Servers'][$i]['user'] = 'user';

Your mySQL username

$cfg['Servers'][$i]['password'] = 'pass';

Your mySQL password

$cfg['Servers'][$i]['only_db'] = 'dbname';

Your database name

5. Log in to your FTP space on the server and create a folder (this must match the name you have used in your config file for example: $cfg['PmaAbsoluteUri'] = 'http://test.com/admin/';) I would advise that it may be usefull to call the folder something hard to guess or purchase a password protected area.

6. Upload the contents of the folder on your desktop to this folder.

7. Browse to your website eg. http://www.test.com/admin/ and if you have configured PHPMYADMIN correctly the admin page should appear and be ready for use.