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
from
// $cfg['Servers'][$i]['AllowNoPassword']
to
$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 config.inc.php::

from
$cfg['Servers'][$i]['auth_type'] = 'cookie';
to
$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]:

$dbuser=’root’;
$dbpass=”;
$basepath=”;
$dbname=’phpmyadmin’;
$dbserver=”;
$dbport=”;
$dbtype=’mysql’;

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

File locations and commands to open are:

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

Comments

comments