Here we will learn some common ways of customizing phpMyAdmin.
1) Setting up automatic login
Some of us may want to set up automatic login for phpMyAdmin.
This can be done by configuring phpMyAdmin for Config authentication.
NOTE: Read about Authentication modes used by phpMyAdmin.
Config authentication mode is the most basic authentication mode. This is preferable for troubleshooting problems and single-user installations where root or a similar super-user is used for all administrative work.
• This mode requires that the username and password is stored in phpMyAdmin configuration file. But this does not password protect phpMyAdmin; anyone who accesses the correct URL is logged directly in and can manipulate our server. Also anyone who can read our main configuration file config.inc.php can read our username and password.
• If you use Config authentication, you must place your server behind a firewall or use your webserver’s Access Control and/or Authentication and Authorization.
$cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = 'USERNAME'; $cfg['Servers'][$i]['password'] = 'PASSWORD';