Set auth. for phpmyadmin

When you do a fresh install of XAMPP/WAMP etc. phpmyadmin doesn’t prompt for auth.

To configure auth, do this

1) open phpmyadmin, click SQL, and perform the following query:

  
SET PASSWORD FOR root@localhost = PASSWORD('your\_root\_password');
  

2) edit ‘$wamp_home\apps\phpmyadmin\config.inc.php'. Change this line:

  
$cfg\['Servers'\]\[$i\]['auth_type'] = 'http';
  

Or

  
$cfg\['Servers'\]\[$i\]['auth_type'] = 'cookie';
  

Then use your root username/pass.