WampServer

phpmyadmin had been working fine but when I added a password to localhost root phpmyadmin wouldn't recognize it and I was not able to access my site!

Hi Hester,

When you add a password to the root user in MySQL you also need to change phpMyAdmin's config so that it knows about this new password, OR, change phpMyAdmin so that it asks you for a userid and password when you try and us it.


Option 1: Add the new password to the phpMyAdmin config file

Edit C:\wamp\apps\phpmyadminX.Y.Z\config.inc.php


set these parameters as follows

$cfg['Servers'][$i]['password'] = 'YOUR_NEW_PASSWORD';
$cfg['Servers'][$i]['AllowNoPassword'] = false;



Option 2: Make the phpMyAdmin app throw a login screen asking for Userid and Password

set these parameters as follows

$cfg['Servers'][$i]['auth_type'] = 'http';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = false;