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

PunchCardBoy · February 8, 2010, 8:02am

Another one registering to say thank you bbparis for the detailed instructions.

As for wamp documentation am I right in assuming that there isn’t really any apart from installation instructions perhaps due to the fact that it’s really only a starting point for other applications/services and you need to find documents for them at other places?

bbparis · February 26, 2010, 11:08am

Dear Vanash, I’m happy to read that you could resolve your problem, you are welcome.
Dear PunchCardBoy, nice to know that you resolved your problem too, and try to ask any question in this forum, because there are a lot of nice people here are ready to help other.

Best regards.
BB

lidelu · May 7, 2010, 7:12pm

Can anyone tell me MySQL console show me edit password, but i do not know it. Again and again #1045 - Access denied for user ‘root’@‘localhost’ (using password: NO) I did all you said here.

coleytaruvinga · May 7, 2010, 8:22pm

hi lidelu you can try to folow what astroja posted, go to were your wamp is stored and open the folder writen wamp usually in the c: hard drive and then when you open it you can then find a folder called apps inside the wamp folder. after oppening the apps folder. look and open config.inc.php and find the following text:

$cfg[‘Servers’][$i][‘password’] = ‘’; // MySQL password (only needed) then enter your password between quotes after the equal sign. pliz take care not to delete anything just add the password you used on installing the wamp server, enter it between the quotes an example is $cfg[‘Servers’][$i][‘password’] = ‘*******’; after entering your password save the changes you have made and then close all the folders you have opened then restart your wamp and try to open the phpmyadmin again in wamp, your problem will be solved.

Iamsam123 · May 16, 2010, 12:03am

Hi I am a PHP novice here. I have the same problem as well. On your step 2. I suppose to have a blank screen (DOS), I didn’t have a blank screen. I have this line, enter your password. What password is it asking here?
I don’t have a password for my user account and the PHPmyAdmin installation. So I am puzzled here.

bbparis:

I’m just to confirm you that it’s the solution.

yesterday I tried to fix the problem, but the only think that was missing is the first line in MySQL command:

UPDATE mysql.user

I was writing ( UPDATE mysql ) : so 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 :
    [COLOR="red"]UPDATE mysql.user [/COLOR]
 -&gt;[COLOR="red"]SET Password=PASSWORD("*******")[/COLOR]
 -&gt;[COLOR="red"]WHERE User="root";[/COLOR]
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 :

$cfg[‘Servers’][$i][‘password’] = ‘yourpasswordhere’; // MySQL password (only needed

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.

NB: I wrote all this explications, because I’m also learning PHP and I found a lot on this website helped me, so I’m trying also to help you.

erngab · July 25, 2010, 11:36am

In config.inc.php I not have orange text:
$cfg[‘Servers’][$i][‘password’] = ‘’; // MySQL password (only needed
my config.inc.php http://a.imageshack.us/img291/7757/greenshot20100725130641.jpg

when start http://localhost/phpmyadmin/ not ask for password.

In localhost/phpmyadmin-Privilegs indicates that the password was set http://a.imageshack.us/img291/3189/greenshot20100725130442.jpg
I do not understand what it means yellow note at the bottom.

I clear Recent History

techysafi · November 4, 2010, 7:42pm

Guys Im using easyphp and I can’t find out the ****in mysql console in mysql folder of it.

Any help??

quicksand · November 28, 2010, 7:58pm

I don’t understand, all that happens when I go to ‘console’ is I get prompted for a password and when I try plugging it in, the machine beeps loudly and it disappears. I must be missing something in the process. I don’t care about adding a password; I just want the myphpadmin to show the database. I had to reload wamp on another drive becuase things got so badly screwed up on the c and I ended up having to unistall it. Now I’m at square one again but experiencing the same error: #1045 - Access denied for user ‘root’@‘localhost’ (using password: NO)

donboe · November 28, 2010, 8:28pm

Don’t use the ; behind the password

seekernad · January 1, 2011, 8:17am

I’m writing with the assumption that u have already set the password for ur root folder on xampp or wamp

Jusr use ‘root’ as ur username for phpmyadmin, n not the username u used for the root folder.
But for the password field, use the password u set for ur root folder.

Hope this wud help

andrern2000 · February 7, 2011, 8:47am

I have done that, but still ERROR POPS UP…

…UNTIL…

…CLEAR THOSE CACHE & COOKIES & RECENT HISTORY OF YOUR BROWSER. THEN MyPHPADMIN WILL RETRIEVE FROM YOUR SETTINGS CONFIG FILE AND WILL BE BACK TO NORMAL INSTEAD FROM CACHE.

It takes the damn one whole day for me to figure this very simple solution step.

alek75 · February 15, 2011, 7:26pm

hi guys

i did exactly what you suggested, even more than once, and nothing changes. and i didn’t make such big changes in the phpmyadmin. right after i got that message i went to the forum and tried the solution quoted. please help me my site and database are closed for me…

thank you

alek75 · February 16, 2011, 1:25pm

ok i have a very annoying problem

the phpmyadmin is logging in now, thanks to the great solution youv’e suggested! so thank you for that!

but i can’t log on to my site through localhost
i keep getting that message no matter what i do:

Database Error: Unable to connect to the Database: Could not connect to MySQL.

i don’t get it! what to do??

SpacePhoenix · February 16, 2011, 6:39pm

What error is being returned by MySQL? Try logging into MySQL with the same host, user and password combination as what your using for MySQL or alternativly in PHPMyAdmin create a new MySQL user that has suitable access rights just for the database for the app concerned and no other apps

alek75 · February 16, 2011, 7:00pm

hey. thanks for answering!

in the end i have erased all my files from localhost and installed joomla 1.6 all over again

now i have really dumb questions but it troubles me:

its working ok now, but i have no idea what was the problem, and i’m afraid to upload new folders for my other sites. like wordpress for example, to the localhost. and so i’m dtuck with only one folder that works. and i’m afraid to tuch it

what do you say can i create new folders in localhost…?

Mittineague · February 16, 2011, 10:36pm

Maybe you simply needed to shut down and restart the server? i.e. If you made config changes they don’t “take” until a restart.

alek75 · February 17, 2011, 12:55am

at first that really was the thing. i just needed to restart the servers and so i feell silly.

but afterwords, the problem with the mysql did not worked whatever i did, until i erased all my folders and reinstalled it. so in fact i didn’t really solved anything. and so i’m afraid to add more files and sites. i really don’t know what went wrong.

do you think i can upload more files to new sites allltogether to my localhost with new folders liuke wordpress etc.?

JayDubWill · April 8, 2011, 2:54am

first, thank you for the great tutorial. I know this thread my be a little old, but I recently had this exact same problem only nothing was working for me until I came across this:

Step1: Go to Control Panel
Step2: Click Administrator Tools
Step3: Click Services
Step4: Find MySQL Service
Step5: Right click and click stop
Step6: Now Restart Wampserver

If nothing else is working give it a shot, it worked for me.

giga67 · May 11, 2011, 5:37pm

You know what…

I just registered not too long ago and was about to quote Iamsam123’s quote with the same problem.

But for my last effort I decided to try THIS solution and by God’s grace it WORKED!!!

You have my highest gratitude!!! Thanks so much!

reflauta · May 24, 2011, 1:10am

i’m ussing Google Chrome… i cleaned the caché. and works!!! its important