Logging in to PHPMyAdmin directly

Issue :

How to login to PHPMyAdmin directly (without logging in to the cPanel interface) ?

Solution :

This can be achieved by the following steps :

First, download and untar the latest version in to your public_html folder.

wget http://downloads.sourceforge.net/project/phpmyadmin/phpMyAdmin/2.11.9.5/phpMyAdmin-2.11.9.5-english.tar.gz
tar -zxvf phpMyAdmin-2.11.9.5-english.tar.gz
cd phpMyAdmin-2.11.9.5-english
mv phpMyAdmin-2.11.9.5-english phpMyAdmin

Then, create a file named config.inc.php and put the following entries in it .

vi config.inc.php
———

$i=0;
$i++;
$cfg['Servers'][$i]['user'] = 'example_test'; //database username
$cfg['Servers'][$i]['password'] = 'qazplm123'; // use here your password
$cfg['Servers'][$i]['auth_type'] = 'config';
?>
———-

Now, you would be able to access it as http://domainname.com/phpmyadmin

For more details on this , please refer this.