Error 1045 - Access denied for user 'root'@'localhost'

[guest]

It is not, I have tried all those things.

Here's what I have done:
1) Install WAMP, changed httpd.conf to Listen 8080, also changed ServerName localhost:8080
2) opened wampmanager.tpl and changed the parameters for localhost and phpmyadmin to 'localhost:8080/'

I can get to the WAMP splash page perfectly fine at localhost:8080, as well as accessing any project I have on the server. The issue here is purely phpmyadmin.

I have a feeling it might have something to do with the fact that I'm also running IIS7.5 but I have no idea where to go from here.

For those of you who haven't seen this error a billion times, here's the error I'm getting:

Error 1045 - Access denied for user 'root'@'localhost' (using password: NO)
! phpmyadmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username, and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

[guest]

the issue is simple, you added a password to mysql and you didnt tell phpmyadmin the password


so open the

config.inc.php

and add the password,


if you already have , below the error to the right , is a button you can press to force a reload.

this is all assuming that your wamp icon is green.

[guest]

The problem is in your phpmyadmin configuration on the server.

You can see the documentation here: http://www.phpmyadmin.net/documentation/#setup_script

The setting you are looking for is "$cfg['Servers'][$i]['auth_type']" - set this to 'HTTP', and you will be able to input a username and password.

[guest]

i am having same problem. treing to short from last 1 week.

(1) C:\Program Files\MySQL\mysql -u root
error 1045(HY000): Access denied for user: 'root@localhost' (Using pasword:no)

(2) C;Program Files\MySQL\mysql -u root -p
enter password:*******
error 1045(HY000): Access denied for user: 'root@localhost' (Using pasword:Yes)

please help me.

[guest]

Easy Fix is to make sure that the user that you are connecting with have settings to access db from both ALL HOSTS (%) AND from LOCALHOST.
If you are using mysql Administrator to manage your DBs go to User Administration (link on left side) choose or create user that you want to connect with to db then right click on this user pick add host choose any host and ok (it should add @ % sign under user) then do the same but this time add localhost (this also will be indicated under your user) And at last the most important thing Apply Changes to this user so it will keep the settings.
As addition later you can play with privilages of your user by clicking on schema privileges tab and assigning additional privilages from available list.

[chicagotech]

Or you may want to reset mysql password by following this link: How to reset MySQL password in Windows - http://www.howtonetworking.com/others/mysql4.htm