First things first, we need to get the latest version of
phpMyAdmin, at the time
this tutorial was written the latest stable version was 2.5.5-pl1,
and you can get it at;



The phpMyAdmin Home Page 

The Link I used:

[root@mydomain.com ~]wget http://nchc.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-3.1.1-all-languages.tar.gz



Grab the download, then grab a terminal window and do the following;



Change to the directory where you saved the downloaded file , such as;



$cd /home/inder/public_html/<enter>



Cool, now we need to move the file to the root directory of your
Apache webserver, which is usually /home/inder/public_html/,
also, root usually owns the Apache
directory structure so you'll need to do the rest as root, so;



$su <enter>



$password <enter>



Now, lets move the file to where we need it.May be u have downloaded phpmyadmin in another folder.



#mv phpMyAdmin-2.5.5-pl1.tar.gz /home/inder/public_html/ <enter>



Done, now make the Apache root directory
your working directory;



#cd /home/inder/public_html/ <enter>



Cool, now lets unpack the file;


[root@indiapoly member]# tar -zxf phpMyAdmin-3.1.1-all-languages.tar.gz




That will take a second, then, when the machine returns the prompt, do a
directory listing;



#ls <enter>



You should see a new directory which has been created called phpMyAdmin-3.1.1-all-languages, assuming you do go ahead and get rid of the
original file;



#rm phpMyAdmin-2.5.5-pl1.tar.gz <enter>



Now, the new directory name is a bit long, and definatley not something you
want to type in all the time, so lets make it easier;


[root@indiapoly member] mv phpMyAdmin-3.1.1-all-languages phpmyadmin <enter>



Cool, now you've renamed the directory to something a little easier to
remember, now make that your working directory;



#cd phpmyadmin <enter>



Configuration - Now, what we need to do is edit the config.inc.php file so it works
with your setup. So using vi, or whatever your favorite editor happens to
be, open config.inc.php, find the following lines, and edit them as
appropriate for your setup;

$cfg['PmaAbsoluteUri'] = ''; (Default info)

$cfg['PmaAbsoluteUri'] = 'http://www.mysite.com/phpmyadmin/';
(Edited)



$cfg['Servers'][$i]['user'] = 'root'; (Default info)

$cfg['Servers'][$i]['user'] = 'myusername'; (Edited)



$cfg['Servers'][$i]['password'] = ''; (Default info)

$cfg['Servers'][$i]['password'] = 'mypassword'; (Edited)



Thats it, save the file and close it.



Now, lets see if it works, open a browser and point it to
phpMyAdmin by using your
site info such as
www.yoursite.com/phpmyadmin, or, localhost/phpmyadmin if you are
only working locally. If all is well you should see the welcome screen for
phpMyAdmin !, if you
don't, then check your logs and remember,
Google is your friend. If you see a page full of
PHP errors, make sure you used the correct
username and password when you edited the lines mentioned above.