Click here to Skip to main content
14,920,009 members
Please Sign up or sign in to vote.
4.33/5 (3 votes)
See more:
hi!
I have the error(#1045 - Access denied for user 'root'@'localhost' (using password: NO) )

I have read solution on other post that is as follow:
{
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 :

SQL
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 :

SQL
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:

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

and add your password now that you used in step number 3 like that :
HTML
[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.
I tried reinstalling wampp and then I installed xampp as well but it shows the same problem.

Thanks!!
Posted
Updated 17-Apr-12 22:57pm
v2
Comments
Sunny_Kumar_ 15-May-12 5:25am
   
Are you able to use your MySQL Server on localhost. If yes, the use that password with phpMyAdmin, otherwise did you try re-installing MySQL Server on your localhost?

Just press enter...no need for password for the first time
just press enter and it will go...
   
Awesome answer .. it works for me !
   

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

  Print Answers RSS
Top Experts
Last 24hrsThis month



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