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) 😉
Everything seemed to work until I opened phpmyadmin. I had to set the username to ‘root’ and typed in my password to let me in. but now I have no privileges. Is there something that I have done wrong?
It works but I don’t see the point in putting the blowfish encrypter in the config.inc.php, I can’t log in in phpmyadmin with it, while your tutorial says I can.
Any idea?
Thank you very much!
GOOD work & GREAT jobs!!
I’ve been trying so hard changing the mysql root password and finally I’ve did it by just following your steps ^^
Greatly appreciate your hard work. Thank you so much (-̮̮̃-̃)
Thank you — this’s really help me a lot.
Great article. This can be confusing, I know it was for me. The changing root password threw me for a loop as a beginner because I was not familiar with config files. Here is a great tutorial on how to change root password in Wamp for Windows based machines: Here is a really easy tutorial on how to change the Root user’s password in Wamp on a Windows based machine: http://www.itutorblog.com/2011/06/how-to-change-root-password-on-wamp/ Thanks again!
FYI on WAMP 2.1e-x32
Followed this excellent guide point by point, no tweaks, skipped step 12 tho.
With multiple ‘root’, had to set up 4 different pass + blowfish. Cleared cache and rebooted WAMP after each one.
Guess what, work like a charm!
Cheers!
pardon
i’m newbie here
when i installed WAMP they didn’t ask me about password, but when i was to install wordpress they ask me the password
anyone knows what’s the first password??
please…
To setup Password, follow this
http://blog.jlbn.net/?p=17
To setup WordPress on Wamp, follow this
http://blog.jlbn.net/?p=34
It took a few bangs on win7 x64, but I got it. Even though this method was posted some time ago, it worked as long as I paid close attention to the instructions and making some simple logical improvisations (CR’s) in the config.ini file.
This was after that feeling of wanting to condemn the programming world and considering tossing the box out the window. Let’s calm down, try again from a backup, Exit wamp, start svcs, clear cache, and it works. Next.
One curious thing was going to the phpMyAdmin login page, there were some curious characters in the ‘user’ text box. Replaced it with ‘root’ (naturally) and the password from step 4 .. Happy Joy
It helps to do the last step as well.
Thank you for the instructions and also, a special thank you to PG. I missed your comment the first time and ended up doing a reinstall. Groan… glad I saw it the 2nd time around!
Hi there!
it really helps a lot. thank’s to you, I’m not very familiar in this kind procedure even though I consider myself as a programmer.I focus more on the software application and mobile not on web, so it helps a lot.it’s a good start before a creating a secure website..before i just try to create a site without using any kind of security even using MySQl as my backbone to my VB6 or VB.net.
for those try to follow this link, I’ll assure you can have more secure database..thanks once again.. >:)
Thanks for this. I got it to work after I cleared the cache.
I´m a little confused about step 12, though, and the part that says you could skip this step for extra security. Skip what, exactly? The password has to be entered in the file to be able to log in, right? At least I couldn´t log in when I tried to leave it blank.
Carina, as posted, you can skip step 12 and don’t have to input your password into config.inc.php file
Worked like a charm. Instructions for setting password are thorough. Please accept my congratulations. But where is the original documentation on this?
There are some pain-in-the-neck problems with wamp, like setting up Pear mail in Windows 7 x64 system with wamp server 2.1d-x64 version, for which I have given up after a lot of effort. Can some one please help?
your guides are a bit dated and scattered throughout many pages, I tried to follow the MySGLlite instructions but WAMP / phpmyadmin didnot have a link to MySQL-lite – so i proceeded onto the database setup, although I was happy to have no login/pass I followed your guide to set it up…and guess what! – I cant login…lol!!
you need to update your guides and perhaps organise them better.
Paul, you need to completely shut down Wamp then restart it, just can’t use Restart All Services
Great very usefull, I just run it and changed my password!
Great Tutorial even more better with illustrated guides.
Thank you!
I follow all the steps and successfully blocked my login to php admin
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.
Same thing here. Followed the guide to the ‘t’ and now after trying to login in I am just redirected to the login page, over and over again.
@ raven and simone
A lot of people already setup password successful following this guide; thus, my best guess you guys might miss a step or two, so try to reset MySQL then following the guide again from start to end or you would get a error if stop in middle
Download ResetMySQL here
http://downloads.jlbn.net
You should setup Backup right after setup Wamp successful, so you can go back if something wrong later
To setup Backup, follow this
http://blog.jlbn.net/?p=6
To setup Password, follow this
http://blog.jlbn.net/?p=17
Thank goodness I read PG’s follow up. Thank you to all!!!
Great walk through, when ever I have to install WAMP or reinstall it, this is my first port of call, much appreciated!
Wampserver wouldn’t work after I tried to set a root password using the guide following a successful installation. I tried twice. Then I took a look at config.sample.inc.php and noticed that $cfg[‘blowfish_secret’] = ”; is placed before the server configuration settings, and before $i++;
I moved $cfg[‘blowfish_secret’] = ‘whatever’; to the beginning of config.ini.php, saved config.ini.php, restarted all services, cleared cookies in the browser, and that did it!
Hope this helps someone
I found the PHP MyAdmin wouldn’t work, as per PG, but PG’s solution didn’t seem to work for me.
However, I noticed the config.inc.php showed this:
$cfg[‘Servers’][$i][‘password’] = ”;
So I entered my password
$cfg[‘Servers’][$i][‘password’] = ‘password-here’;
and, hey presto!
Hope that helps a fellow new-to-this-stuff sufferer.
Chris9, as posted to answer to Carina above, you don’t have to put your password in config.inc.php for more security but you do need to shut down Wampserver and start it again instead choosing Restart from Wamp menu; also remember to clear your browser cache 😉