Some tips on LAMP – phpmyadmin
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/config.inc.php uncomment the line
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 config.inc.php::
$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: