This is for Ubuntu 12.04 LTS. If your system is with other distro, change the systax accordingly.

Case 1: No root password

If your MySql root user have no password [if you left that blank while setup], then you have to make a little change in your phpmyadmin configuration file to accept that.
open file /etc/phpmyadmin/ uncomment the line
// $cfg['Servers'][$i]['AllowNoPassword']

This will make that fixed.

Case 2: No login page

In your local server, if you dont want the login page to come everytime, then set the Config in the config-db file, and set the auth type to Config in

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

config-db.php file suppose to be like this [I leave the root password as empty, but you should use yours one if that is not empty]:


The configuration also can be reversed, if you want opposite.

File locations and commands to open are:

gedit /etc/phpmyadmin/
gedit /etc/phpmyadmin/config-db.php