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) 😉
I’ve just installed Unofficial_WampServer2.0j and my config.inc.php hasn’t got the lines shown in your guide. Here’s mine:
This is my first day with any of this software, so any help will be much appreciated.
Steve
Steve, we can’t read your codes, so please use our tool here to convert your code then post again
http://blog.jlbn.net/?p=84
Thank you so much, your tutorials and help are wonderful.
My question is:
I chenges password from phpmyadmin and did not copied secret code. Now I got 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.
and
Database Error: Unable to connect to the database:Could not connect to MySQL
what can i do?
goncoloz, in your case, you need to reset MySQL, setup password and setup database account so you can use in most sessions including in your script since you should avoid to use “root” on everything unless you have to 😉
Download resetmysql here
http://downloads.jlbn.net/
To setup Backup, follow this
http://blog.jlbn.net/?p=6
To setup Password, follow this
http://blog.jlbn.net/?p=17
To setup DB account, follow this
http://blog.jlbn.net/?p=19
Sorry. I have tried this entire install/uninstall/password procedure many times with many passwords and it does not work. Not sure how or why some give praise. Not sure why the maker of WAMP software couldn’t give better documentation with the package.
I am worn out by the many annoying ads on these pages, and the thought that each one is pouring cash into your account while I have lost an honest day of working time trying to get my job done.
People have problem because they’re most likely stop at step 4 instead following until the end, and by the time you recognize the issue and come back for more, it’s too late since your mysql already set, and in that case you need to reset mysql then follow the setup password guide again
Download ResetMySQL here
http://downloads.jlbn.net
To setup Password, follow this
http://blog.jlbn.net/?p=17
By the way, you can only setup password when your wamp is in working state; if your wamp is not working, you can not setup password
I’ve installed WampServer, and the Tray icon is yellow. I click localhost and it comes up with Authentication Required. I’ve tried everything. I can’t get past this.
Make sure no other program conflict Wamp such as IIS, Skype, Zonealarm, firewall/antivirus, NOD32, Eset, any web related program …
IIS and Apache/Wamp are both web server and might conflict in some way, so you have to disable IIS in order for Wamp to work
Disable IIS in Vista/W7:
Control Panel, Uninstall Programs, Turn Widows Features On or Off, uncheck Internet Information Services
Disable IIS in XP:
Control Panel, Add/Remove Programs, Add/Remove Windows Components, uncheck Internet Information Services (IIS)
Restart computer, then restart Wamp
Also, in folder C:\WINDOWS\System32\drivers\etc, open file hosts and delete anything in this file and have only this line below and nothing else
127.0.0.1 localhost
If using Skype, open Skype > Tools > Options > Advanced > Connection then uncheck “use port 80…”; restart Wamp then Skype
Hello,
I’ve followed the instructions above, however on step 2 myphpadmin refuses to login and gives the following error instead:
Error
MySQL said:
#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.
Is this a common problem?
Eric, download ResetMySQL here
http://downloads.jlbn.net/
To setup Password, follow this
http://blog.jlbn.net/?p=17
Thanks a lot for an excellent tutorial. Even though I’ve got a newer phpmyadmin version, it worked like a charm.
May God bless you richly and abundantly.
Pastor Carlos Camacho
Iglesia Nuevo Testamento de Ponce (http://www.intponce.org)
Ponce, Puerto Rico, USA
I tried following the instructions at http://guides.jlbn.net/setpw/setpw1.html for setting up password protection. But now I can’t log in to phpMyAdmin at all! Access denied for user ‘root’@’localhost’ (using password: YES). I can’t even log in to turn off the password anymore! What can I do?
@ lost
You must miss a step or two, so download ResetMySQL, follow the instruction included in the archive, then go over Setup Password guide again, and of course, carefully go through step by step 🙂
Download ResetMySQL here
http://downloads.jlbn.net/
To setup Password, follow this
http://blog.jlbn.net/?p=17
Excellent stuff. Your instructions were just right to set the passwords. Thanks a lot for the help.
The PS was for jlbn.net of course 😛
Your step by step instruction on how to set up a MySQL root password is the best out there! I wasted hours going through others’ instructions that didn’t make sense. Thanks a lot, I really appreciate the help!
Thank you very much. The guide was easy to follow and fixed my issues by changing auth type to cookie.
I meant to post this earlier. Everything worked as it was supposed to after I rebooted my computer 🙂 )
I think I’ll steer clear of passwords for now. No matter which setup I’ve use, when I enter a password, I lose access.
Thank you for the files.
Thank you for offering this password setup guide, however, I tried to get this to work many, many times. I get the same #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
error, no matter what I do. I downloaded reset mysql and that did not work either.
Aside from removing WAMP, I don’t know what else to do. I had access before trying to set a password.
Dee, if you’ve had access before setup password, you must missed a step or two, so before uninstall and reinstall wamp, try to go over the guide step by step carefully, and if in some step you might find it’s not quite clear, just post the question here
Thanks a ton… Appreciated…
It really helped me a lot…
Perfect for newbies’….
One suggestion: In step 3, it would have been better if you would’ve mentioned to click on the privileges button…
Thanks again…
@ Sandeep
It’s in step 2 as stated “selecting Privileges” 😉
@ Tom
We might edit to make it better, but anyway it’s already stated “Next step is to add the codes below”
We’ve just edited them as follows “left clicking Privileges tab or link” and “Next step is to add a line of codes below“. Hope it would be more clear 😉
T H A N K Y O U S O M U C H !!!
I’m a newbie on wamp, this was very easy and straightforward, pictures are great idea! Thanks a lot!
(If I may give a small suggestion on step 8 it took me a while untill I figured out I have to write the whole line myself in config.inc.php, since I’m using wamp 3.2.0.1also step 15 became obsolete in this release)
But most of all: thanks
This is the best tutorial regarding Password Protection on WAMP that I’ve ever seen. You’re a lifesaver, I can’t thank you enough for your help.
Thank you!
Hi
Thank you very much for your wonderful and easy instruction. Myphpadmin is secured now. When I test the site on the localhost, it has this message.
Warning: mysql_connect() [function.mysql-connect]: Access denied for user ‘SYSTEM’@’localhost’ (using password: NO) in C:\wamp\www\checklogin.php on line 11
can’t connect
Line 11:
mysql_connect ($host, $username, $password) or die (“can’t connect”);
I still have the same error. Any help is greatly appreciated. Once again, thanks.
Sam Mah, you need to setup Database Account for your script to work
to setup db acct, follow this
http://blog.jlbn.net/?p=19
Dear Ser or Madam
Thank you very much.
Best regard
Jannati from Iran
I have visited both of the sites that you have mentioned but it is not solving my problem becoz the phpMyAdmin page is not opening in my local host. I am getting the error only as mentioned earlier.
I cannot go to the privileges link. Please Help me out asap. Thanks in advanced.
Rashmi, did you reset MySQL as suggested or not???