Mar 27, 2011
Yesterday, I showed you how you can keep local installation of phpmyadmin from logging you out every few minutes. I took one more step and edited configuration to not ask me username, password at all. Now phpmyadmin never asks me for mysql username and password.
Keep in mind if you follow this tutorial anyone would be able to access your database using phpmyadmin unless you deny access via apache configuration. Don’t do this on production servers.
Steps to follow:
- Run: gksudo gedit /etc/phpmyadmin/config.inc.php
$cfg['Servers'][$i]['auth_type'] = 'cookie';
And change it to:
$cfg['Servers'][$i]['auth_type'] = 'config';
- Just below this line, add:
$cfg['Servers'][$i]['user'] = ''; $cfg['Servers'][$i]['password'] = '';
Replace and with mysql username and password.
- Save the file.
- Changes will be applied immediately, no need to restart apache.
Now, you’ll never have to enter username and password in phpmyadmin.