phpMyAdmin is the mostly used web based PHP application for MySQL client. When we use it in the local systems, we always need to enter username and password to login. To avoid prompting the login screen you need to overwrite the existing settings with our own. phpMyAdmin lets us to overwrite the settings/configurations by using a file in the root of its directory.
A file is always delivered named config.sample.inc.php in its root. You just need to rename it to config.inc.php and change the following line:
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['auth_type'] = 'config';
And add the following two lines:
$cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = 'asdf#asdf'; // use here your MySQL password
Hope this helps someone who is willing to avoid login screen in phpMyAdmin.
One Comment to “Avoid login screen in phpmyadmin and auto login”