phpMyAdmin disable admin login

Question

I have Ubuntu, and installed the phpMyAdmin package (currently 4:3.3.2-1). Every 30 minutes, it asks me to enter my username and password, for inactive session timeout. In earlier version of phpMyAdmin, setting a user/pass would entirely skip this login form and keep the session open indefinitely. This installation is on a dev machine (single user on closed private network) and I want to disable, or bypass that login form so I never have to actually input the user/pass again. I tried fiddling with the configuration files (there are like 3, not even sure which one is used) but nothing seems to change.

I've followed this thread : http://ubuntuforums.org/showthread.php?t=743991 which brought me to this thread http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=499399 but there is no clear directive on how this be be solved.

Thanks!

Answer 1

Open config.inc.php on my debian instalation i can find it at /usr/share/phpmyadmin/config.inc.php. Change auth_type and add in the first element on the array like this $cfg['Servers'][1] any data (like a host in $cfg['Servers'][1]['host']) need to auth.

EDIT:

Add this lines before first for statement in config.inc.php:

$cfg['Servers'][1]['auth_type'] = 'config'; $cfg['Servers'][1]['host'] = 'localhost'; //edit if you have db in the other host $cfg['Servers'][1]['connect_type'] = 'tcp'; $cfg['Servers'][1]['compress'] = false; $cfg['Servers'][1]['extension'] = 'mysql'; $cfg['Servers'][1]['user'] = 'root'; //edit this line $cfg['Servers'][1]['password'] = ''; // edit this line 

Answer 2

On Ubuntu installation the config file is located at /etc/phpmyadmin/config.inc.php

Add/Correct these lines to the file:

$cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = ''; $cfg['Servers'][$i]['AllowNoPassword'] = TRUE; $cfg['Servers'][$i]['AllowRoot'] = TRUE;