WampServer

Hi everyone,

After I install and I went to phpMyAdmin and I changed a few passwords and I got an error

Error
MySQL said:

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


Even after I uninstall and reinstall WAMP and then restart and reinstall, i still get the same error. How can I solve it?

Thank in advance.

Cheers,

Henry

If you give the ROOT LOCALHOST a password (a very wise move) then you have to go into \wamp\phpmyadmin folder and edit config.inc.php - look for this line:

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

add password in between quotes

$cfg['Servers'][$i]['password'] = 'xxxxxxxx';



G. ARMENTO
----------------------------------------------------------------
Graphic Design - Multimedia - Illustration - Photography

website: [www.forthosewhowait.com]
e-mail: ggarmento@yahoo.com

After I tried the instuction above i get using password:YES instead of NO.
#1045 - Access denied for user 'root'@'localhost' (using password: YES)

I still have the same error. It might be save a file somewhere in my windows folder or something. How can I clear everything?

This is what I did, I uninstall wamp then I deleted the entire "wamp" folder in c:/wamp.

I would expect that everything will be gone but after I reinstall I still have the same error.


Can anyone hellp to clear everything?

Thank you

Henry

I got this same error. that was because i changed it within phpmyadmin in one of the excisting tabels.

How did you solve it?

Even now i formated my computer and I install it again and then I went to phpMyAdmin and then click on the priverlic then I select the localhost and then I changed the password where they have options
o No Password
o Password .................
verify ..................
[GO]

I clicked on password option then I put my password then click go there is a message say that I have change the password and the red message that appeared at the bottom of the screen is now gone. After ward I close the window and when I tried to go back in I get the the message:

Welcome to phpMyAdmin 2.10.1
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.
Error
MySQL said:
#1045 - Access denied for user 'root'@'localhost' (using password: NO)

Then I went to
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed
to put my password.
Error
MySQL said:
#1045 - Access denied for user 'root'@'localhost' (using password: YES)

Can anyone help please? I am so so piss.


Thank in advance

Henry

Make sure to restart your wamp server after any editting to take effect

Have fun,

[www.jlbn.net]

After installing WAMP, I open PHPMYADMIN,
go to PRIVLEDGES, and then
edit the ROOT LOCALHOST user.

I provide a password. xxxxxxxx - in the Chage Password field.

PHPMYADMIN will not work after that... because you
just gave YOURSELF the "root@localhost" user a new
password to access PHPMYADMIN and all MYSQL databases.

I then go into \wamp\phpmyadmin folder
and edit config.inc.php - look for this line:

$cfg['Servers'][$i]['password'] = '';

add password in between quotes

$cfg['Servers'][$i]['password'] = 'xxxxxxxx';

Now you restart the WAMP server and PHPMYADMIN should work!

You have to use the same username/password in your PHP files
to access the MYSQL database or setup a new USER/PASSWORD
in PHPMYADMIN (with fewer privileges *recommended) and use that
in your PHP files that try to access a MYSQL database.

Greg



G. ARMENTO
----------------------------------------------------------------
Graphic Design - Multimedia - Illustration - Photography

website: [www.forthosewhowait.com]
e-mail: ggarmento@yahoo.com

Hi i am experiencing the same problem . when i went to the phpmyadmin folder i could not locate the config.inc.php file. there is only config.inc listed.

please help.

My WAMP version is 1.6.6

the control file is config.inc.php

maybe your version is config.inc



G. ARMENTO
----------------------------------------------------------------
Graphic Design - Multimedia - Illustration - Photography

website: [www.forthosewhowait.com]
e-mail: ggarmento@yahoo.com

Hi.

I also have the same problem. I change the password for root user and then edited config.inc.php.

After restarting all services and looking for problem all the time result is the same - #1045 - Access denied for user 'root'@'localhost' (using password: NO)

howeever for me it looks quite strange that password in config.inc.php looks like I typed it not like 'xxxxxxxx'. Probable I''m not using the right editor or don't have the correct permisions to do this???

Please advise.henry wrote:

> Hi everyone,
>
> After I install and I went to phpMyAdmin and I changed a few
> passwords and I got an error
>
> Error
> MySQL said:
>
> #1045 - Access denied for user 'root'@'localhost' (using
> password: NO)
>
>
> Even after I uninstall and reinstall WAMP and then restart and
> reinstall, i still get the same error. How can I solve it?
>
> Thank in advance.
>
> Cheers,
>
> Henry

I had this same issue and it took me a while to figure out that the browser was loading the cached page. After I changed the pwd in config.inc and restarted services went back to the Wamp start page and clicked on myphpadmin I would get the error page. After I hit Refresh, my admin page came up.

thx xmlb.. i found the same problem

the problem was with the cache of IE 7.0 thts why the problem remains there if if u change password on both(PHPMYADMIN & config.inc.php)

the problem was gone but still the ie7.0 loads the cache page.. tht really pisses me off.

but now when i delete all the browsing history .. i m happy with my password set with phpadmin



Post Edited (11-06-07 12:53)