Click here to Skip to main content
15,867,835 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have this error when I try to open phpmyadmin in localhost page.

Please help . I waiting.
Posted

the error indicates that root has a password, but you are not supplying it, hence the (Using password: NO)

Read this [^]for more info.

hope it helps :)
 
Share this answer
 
Comments
sanjiv shah 18-Apr-12 3:00am    
Actually i am using blank password in config.inc.php. Even then i am getting this error. I have googled for the solution.
I got one as below which is to switch from no password to some password.
The solution is like this:
{
Please follow the next steps if you want to resolve your problem with ( #1045 - Access denied for user 'root'@'localhost' (using password: NO):

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 phpmyadmin2.11.6 ) and find the config.inc.php

7: open config.inc.php and find the following orange text:

$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed

and add your password now that you used in step number 3 like that :

[COLOR="rgb(255, 140, 0)"]$cfg['Servers'][$i]['password'] = 'yourpasswordhere'; // MySQL password (only needed[/COLOR]

8: now save this modification, and close config.inc.php

9: go to your web browser and type the following link :

http://localhost/phpmyadmin/

and enjoy, this is what happened with me.
}

But in the Mysql console: i am stuck with the following problem
(Enter password: ) in the command prompt screen.

I have no idea what password it is asking for. can you help me.
I have tried blank, and other possible passwords but it does not work.
So I am unable to follow the instruction of above step no 3.
I tried reinstalling wampp and then I installed xampp as well but it shows the same problem.

i will greatly appreciate any kind of help.
Uday P.Singh 18-Apr-12 8:46am    
why don't you re-install your WAMP server , with no password
please visit below link for solution i have solve my problem by doing this.

http://windowsproblemsandsolutions.blogspot.in/2012/09/1045-access-denied-for-user.html[^]
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900