WampServer

Hello,
Iam using wampserver on my computer and currently i have some joomla sites installed on it. But today i tried to create a password to root account (localhost) and i ended up just getting the message below whenever i to open phpmyadmin.

The message is below;

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.

I can nolonger see anything in phpmyadmin. But my installed joomla sites are running normally.


Your help will in over coming this will be highly appreciated

Thank you

Ronnie

Download ResetMySQL here
[downloads.jlbn.net]

You should set Backup right after set WAMP successful so you can restore if having issue
To setup Backup, follow this
[blog.jlbn.net]

To setup Password, follow this
[blog.jlbn.net]

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Hello,
Thanks for your reply but i have failed to find a solution to my problem. But this is what happened.


I have been using wampserver on my computer for some time and today i decided to create a password for user "root", host is "localhost" and password is "no";.

But after creating a password. i stopped seeing home page and the only message i get nw is below;

Error

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..


How can i over come it without loosing my installed data like test sites for joomla and other applications installed on it?

Your help will be highly appreciated

Thank you

Ronnie

Did you download resetMySQL?

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

I don't think your problem is as complicated as it may seem. Perhaps you didn't set up your password correctly. I would uninstall your wamp and reinstall it. Then, when trying to set up the password, follow the steps outlined here. [guides.jlbn.net]
I'm thinking you didn't set up the password correctly and that's the reason for your error.

"One Step at a Time"

HarbingerZJC, you're right, she did not setup password properly but instead uninstall, reinstall wamp, she just need to download resetMySQL and follow the instruction in that file, then follow my guide to setup password

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Hello,

Thanks for all your replies and i think i will have to go for resetMYSQL. But where can i find the script for resetMYSQL?



Otherwise thanks once again for your help.

Regards

Ronnie

Download ResetMySQL here
[downloads.jlbn.net]

You should set Backup right after set WAMP successful so you can restore if having issue
To setup Backup, follow this
[blog.jlbn.net]

To setup Password, follow this
[blog.jlbn.net]

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Hey guys I have had this problem twice now after setting a password for root user.
I tried this fix but for some reason didn't make a difference. I uninstalled a separate MySQL installation. Completely made a fresh install and deleted the left over files.

Now here's the odd part.

I was still getting the #1045 - Access denied for user 'root'@'localhost' (using password: NO) message.

Now here's the solution.

I changed the password inside the config.inc.php file from nothing ('') to ('p') saved and restarted the WAMP services again. As expected error #1045.
Change the password back again to nothing ('') , restarted the WAMP services again and hey presto it worked.

I hope this helps some people.



Edited 2 time(s). Last edit at 11/26/2011 12:44AM by spectornz.

Yes but it's much easier if you just add the correct password and clear the
Browser history

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

I installed wampserver but it gives the ERROR

#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.
Open new phpMyAdmin window .

By default the userid 'root' has no password.

Just enter
Username = root
password = leave it blank

I have tried,it is still not working

Whats not working?