Yanick Rochon Yanick Rochon - 4 months ago 7x
MySQL Question

phpMyAdmin disable admin login

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.



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.


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