Customizing phpMyAdmin

Here we will learn some common ways of customizing phpMyAdmin.

Customizing phpMyAdmin involves the following step.
1) Setting up automatic login


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 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.

To enable Config authentication mode, make the following changes to file.
NOTE: Replace USERNAME and PASSWORD with your preferred values.

$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'USERNAME';
$cfg['Servers'][$i]['password'] = 'PASSWORD';

Next time we access phpMyAdmin, the login details will not be asked.
Instead phpMyAdmin will read the login details from and perform automatic login.