Enable Authentication For PHPMYADMIN Login

01 Jun 2017 . category: sysadmin . Comments
#sysadmin #phpmyadmin #mysql #lampp

Installing the lampp package for a developing enviroment is the most commo for deverloper. Accepting all the default settings during installation result in a security issue. Anyone can access the database without authentication - nothing.

To make phpmyadmin throw an authentication when being accessed, like below:

Open the phpmyadmin configure (ex: /opt/lampp/phpmyadmin/config.inc.php ) then change:

change	$cfg['Servers'][$i]['auth_type'] = 'config';
to      $cfg['Servers'][$i]['auth_type'] = 'cookie';

Save then may restart your lampp server.

---