WampServer

I've scoured the internet for two days straight and I cannot seem to find a solution to save my life. When I boot up my WAMP server, I can access local host without any problems. However, when I click on phpMyAdmin I'm presented with the following message

MySQL said:

1045 - Access denied for user 'root'@'localhost' (using password: NO)

Now I know what you're thinking: "He forgot the password". But that isn't the case, and in fact when I access the config.inc.php file my password is there, and I double checked by copying and pasting it directly into the MySQL console (which I was able to log into by the way).

So what am I doing wrong here?

You need to set

$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'YOUR_PASSWORD';
$cfg['Servers'][$i]['AllowNoPassword'] = false;


Its probably AllowNoPassword that is still set to true thats causing the problem

Riggs- I set it to false, and it's still not working. I'm getting the same error message as before. Thanks for the suggestion though

Make sure you have set a password on all 3 root userid's.

There are 3
root@localhost
root@127.0.0.1
root@::1

Same password on all 3.

RiggsFolly Wrote:
-------------------------------------------------------
> Make sure you have set a password on all 3 root
> userid's.
>
> There are 3
> root@localhost
> root@127.0.0.1
> root@::1
>
> Same password on all 3.


Awesome, this looks promising but i'm a bit confused. How would I gain access to each of these?

Use phpMyAdmin

look closely there are 3 root userids.

If trying to access the PHPmyadmin "users" page also gives you that error and the inability to manage the users through it, the following guide may help (on Windows). Following RiggsFolly's advice and the guide below may fix it for you.

[learnmysql.blogspot.com]