JLBN – Setup Password Protection on WAMP
In this guide for WAMP, we will show you how to install and setup password for WAMPSERVER. There are too many ways to setup password, but here we only show the easiest but security way for WAMP
Note: Before attempting any change, even the first time password setup, you should perform a full backup; check the Setup Backup guide for WAMP on this website.
Note: Even this guide is used for Wampserver, you can apply this method on other wamp package such as Xampp, EasyPHP, so on. Just make sure to select correct file(s) in proper location(s) 😉
Access Denied , no user password set – searched many blogs for the solutin, but could’nt find it, but your steps has been realy incredible. Worked well …………. Thanks
Hi…
Thank you so much for this very-easy-to-follow (especially with the added pictures) guide. I spent a whole day getting frustrated by the password %&^&@# on WAMP server, then I stumbled upon this site. Thanks again :)…
nice guide, thanks.
Fantastic – idiot proof guide!
This was fantastic, I nearly went insane trying to get my password working before I followed this tutorial. Only one complaint though, not even a complaint just a mention, the english used in the tutorial was a little broken, maybe the author was a non-english speaker!
Great tutorial, really helped me a lot!
@ JL
yes, but I did not change the server auth type to ‘cookie’ as I want phpMyAdmin to log on automatically as I will be the only user…
btw, what is the blowfish / passphrase needed for ??
Thanx.
– Mike
@ Mike
blowfish is used to encrypt your password, and if you don’t want to the log in screen, you still need to set it up 😉
@ John Walsh
he he… he he… 😉
you’re right and if you don’t mind, you can help us to improve it 😉
Hi,
have a problem here, although I followed your guide.
I have 2 root users, one with an IP address under HOST, the second one with localhost under HOST.
After I changed / set up the password for the first root user, I still get the error message that there is a root user without a password.
Once I change / set up a password for the SECOND root user, phpMyAdmin will not work anymore – outputting:
#1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
What I have also tried:
1. tried to delete the second root user, it will give me the same 1045 error message after I deleted the account
2. I used a different password for the second root user, it still outputs the 1045 error message
Any suggestions ? 😉
Thanx in advance.
– M
before setup password for second user “root”, did you follow all steps until instructed to setup password for other user “root”?
Thank you for this guide! One thing that had me chasing my tail for a bit was that I had IIS installed as well. That gave me the yellow icon for WAMP and asked for a login on localhost. After finding out that the login was due to a setting in about:config for FF I then had to uninstall IIS and now everything works properly.
Excellent guides, thanks a bunch!
I had to relax my Google Chrome cookie setting a notch in order to log into the now passworded phpmyadmin, but once I got it, I set Chrome back to restrict 3rd party cookies, and I can still login.
Sorry, I guess I blew it. I now see what I should have done. Thanks.
Please help! I restored wamp and found the entire website back to the backup date. How do I get mySQL to at least show the more recent changed tables from another disk instead of the old ones? Or how do I recreate the overwritten newer httpd.conf? Thanks.
Many many thanks. I was not able to donate much, sorry, but for lack of funds not for lack of appreciation!
thank you thank you thank you!
Every donations are greatly appreciated no matter it’s 100 or 1 dollar 😉
Thank you, we’re really appreciate it
It’s very nice and brilliant and never find help like this immediately and for beginners life like me makes sweet, the postings and help like this is surprise.Thank You very much hundreds of times
I am new user i set password for mysql using mysql console and opened phpmyadmin it throws the similiar error can you help me i didn’t see the window that you are posted in links.
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.
Balaji.M, download resetmysql here
To setup password, follow this
http://blog.jlbn.net/?p=17
Hi,
I have followed the steps 1-13 and set my password. Then after restarting mysql when i click the phpmyadmin from the wamp tray i get the error that #1045 – Access denied for user ‘root’@’localhost’ (using password: NO) . When i open the mysql console and login using the password i provided it logs in. When i type the SHOW DATABASES command i am able to see the information that 2 rows returned in 0.01sec. what should i do now so that phpmyadmin works fine???? Could you please help me out in this?? Thanks in advance…
Regards,
Prakash
Prakash, it seems you missed a step or 2, so download resetmysql here then start the guide from beginning
Hi, followed your password guide and have a root password set, but now i can’t access any of my files through the web server, just get a 403 forbidden message. There isn’t a prompt for a password at all.
Any help you could offer would be appreciated.
Michael, it seems you didn’t follow all the steps, so suggest to go through them all to make sure you didn’t miss any step; however, if still can’t figure out, redo all steps after download and apply resetmysql here
password configuration for wamp?
Not quite sure what you mean, so you should follow this guide then 😉
Спасибо наконец то нашла то что хотела прочитать тут. Кстати у меня есть рисунки на эту тему. Куда можно скинуть? Ещё раз спасибо огромнейшее ! 🙂
Just a quick comment here :
Using the ZoneAlarm Pro firewall, it will block the access to these setup pages, requiring for enabling cookies, despite they are, both in your browser and in the ZA setup.
this error always comes up, Unidentified index: Login c:wamp/www/main.php Line 5
i do not know what it means,
can anyone please help .. asap. thank you in advance !
shazzo, since you put file directly in www folder, it might conflict w/ main index file; suggest you check this
http://blog.jlbn.net/?p=11