WampServer

Hello friends,
I installed WampServer 2.2 and tried to run PhpMyAdmin but it is showing error saying


MySQL said: Documentation
#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.


Please could anyone tell me where should I go and make configuration

Thanks and Regards
Chiranjeevi

have same problem

let me know if it is solved and how?

Here's solution chiru.
1 : go to your WAMP icon on your PC desktop screen and LEFT CLICK to open the menu, you will see MYSQL folder, CLICK to see MYSQL CONSOLE, open it.

2: now you have DOS screen ( a black screen ) :

A: if you already set a password, type it
B: if you did not do this step yet, write the following red text
B1: use mysql; and click ENTER on your keyboard
3: now write the following red text and click ENTER :

UPDATE mysql.user
->SET Password=PASSWORD("*******"
->WHERE User="root";

don't worry about this sign ( -> ) , because for example when you write ( UPDATE mysql.user ) and you click ENTER on your keyboard, a new line appear with this sign ( -> ), your command will execute when you write this sign ( ; ) at the end of your text and click ENTER.

NOTE: replace the password ******* by your password.

4: now write the following red text and click ENTER :

FLUSH PRIVILEGES;

5: and to exit the black DOS screen now, write exit and click enter.

------------------------- we are finished from MySQL now --------------

6: go to WAMP folder ( open your My Computer, click on C driver, and you will see WAMP folder ), click on APPS folder, and than click on your PHPMYADMIN folder ( e.g my folder called .phpmyadmin3.4.5 ) and find the config.inc

Your config.inc file should look like this :
/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'mypassword';
$cfg['Servers'][$i]['AllowNoPassword'] = false;

/* End of servers configuration */


make sure you enter your password in 'mypassword'
also AllowNoPassword should equal false (in the original config.inc it was true)

save file and open phpmyadmin

Not to hijack the thread or anything but I have the exact same problem. I just want to clear up your post above.

You said type in the "red text" you dont have any red text in your post. Is there meant to be red text?

I have a similar problem, but in my case the root passwords are blank (and that's ok, it's a localhost server) and I can get into phpMyAdmin just fine. I've checked the length of the passwords for a user I set up to access a specific DB, and it's the long password (which is the NEW way, right?).

When I try to access that DB from my application with the correct password, access is denied.

Any thoughts... suggestions?