WampServer development with phpMyAdmin 3

phpMyAdmin

After upgrading your WampServer with the latest phpMyAdmin of the 3 branch, you may not be able to sign in and instead get an “Access denied” message while everything was running smooth with phpMyAdmin 2.

This is caused by a new security feature in phpMyAdmin 3 which by default does not allow access as root without a password for the ‘config’ authentication type.

I do not have to explain why this was introduced and noone will state it isn’t a good addition. However, if you are developing on localhost and using the default WampServer set-up, you will not have a MySQL root password set. It has the advantage each of you local projects only require a database name.

If you want to circumvent this while not setting a root password, instead set the ‘AllowNoPasswordRoot‘ setting to true in your config.inc.php:

$cfg['Servers'][$i]['AllowNoPasswordRoot'] = true;

Update: since version 3.2.0 (?) a second setting is required:

$cfg['Servers'][$i]['AllowNoPassword'] = true;

Tags: ,

 
 
 

Leave a Reply