Managing MySQL with phpMyAdmin

phpMyAdmin is a free software tool designed to help administrate a MySQL database over the Web, and in this quick tutorial, I will show you how to install it here at Winhost.  First, you need to create a MySQL database through the Control Panel.

Click on the Sites tab.

Click on the Manage link and then click on the MySQL button.

Click the Add button and enter the values for Database Name, Database User, and Quota.  Click the Create button to finish creating the database.  Now click on the Manage link and record the connection information (Database Name, Database Server, Database User, and Database Password) on a piece of paper or a text editor such as Notepad.

Now download the source code from the phpMyAdmin website.

Extract the contents using a decompression program such as 7-Zip.  Now make a copy of the config.sample.inc.php file and save the new file as config.inc.php.  In the config.inc.php file, alter line 31:

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

By changing ‘localhost’ to the database server name.  For example:

$cfg['Servers'][$i]['host'] = 'my01.winhost.com';

Now, upload the contents to your Winhost account and access it, adding a Default Document if necessary.

Voila!  You are now ready to manage your MySQL database with phpMyAdmin.