Installing PhpMyAdmin
step by step guide
What is PhpMyAdmin?
Basically it is an easy to use administrator graphical interface to make MySQL databases easily.
Before you start
Your webhost, or computer if using a server, will need php support installed, preferably version 5 although 4 should be ok, any less and you need to update. If you have a webhost with less you need to get a different webhost. They aren't serious. Also your webhost, or pc, will need to have MySQL installed.
Downloading
Go to phpmyadmin.net and download a compressed file of PhpMyAdmin.
Extracting
Extract the file in your web directory.
Creating connection between MySQL and PhpMyAdmin
Create a file with a text editor called config.inc.php and paste the following:
<?php
$i=1;
$cfg['PmaAbsoluteUri'] = 'http://www.
yourwebsite.com/folder_where_PhpMyAdmin_is/';
$cfg['Servers'][$i]['host'] = 'MySQL.http://yourwebsite.com';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';
$cfg['blowfish_secret'] = 'insert_random_phrase_here';
?>
Make sure you leave no white space on the bottom of the script. Save this file in the PhpMyAdmin folder. Overwrite if asked.
Change "yourwebsite.com" to your website and "folder_where_PhpMyAdmin_is" to the folder where PhpMyAdmin is.
Next you need to decide what method you are going to log in with.
The Cookie Method: (recommended because of the security)
Leave the "user" and "password" fields blank because we are going to use the cookie method of logging in. This way is the most secure.
If you want to use the config method you must set a password on the PhpMyAdmin directory otherwise someone could get your MySQL username and password.
Change "insert_random_phrase_here" to anything. This is just used to encrypt internally. You will not need it again.
The Cache Method: (not recommended because it stores your MySQL password where it can be accessed)
Fill in the script the same way as the cookie method except change "cookie" to "cache" and "user" to your MySQL username which should be "root" by default and "password" to your password which normally is blank by default, you can change that from PhpMyAdmin once you log in. Make sure you do change it especially if you have made a database!!! Delete the "insert_random_phrase_here" and leave blank.
The difference between methods
The difference between the methods for the user is that with the cookie method you need to keep logging in, but with the cache method you don't because it stores your MySQL password in the script. Logging in to PhpMyAdmin will be the achieved in the same way with both methods though.
Please note that PhpMyAdmin has nothing to do with these passwords. They are provided by MySQL.
Logging in
To log in you must go to the link you specified in the php script (http://www.yourwebsite.com/
folder_where_PhpMyAdmin_is/). You will then be prompted for your username, which usually, by default, is "root" (without double quotes) the password usually is blank.
moneysupermarket the best
price
comparison site
