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) 😉
Hi. I need ur help asap,,, Am getting this error
#1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
And I tried following ur steps but I can’t get it…. I have never opened phpMyadmin before,,,, it is refusing
Onnie, 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
Thanks for reply
When i uninstalled wamp I assured that there is no mysql in system from
task manager(i checked processes and service) and no mysql there
wait for help
Hello,
Thanks for your explain
I installed wamp server which contain:
Apache 2.2.17
Php 5.3.3
Mysql 5.1.53 (version 64 bits)
Mysql 5.5.8 (version 32 bits)
PhpMyadmin 3.2.0.1
SQLBuddy 1.3.2
I tested info.php and http://localhost/ and its ok
but i have two problem:
first: when go to http://localhost/phpmyadmin/
it loaded very slowly and ask me for user and password
I typed root for user and no password when submitted it went to
a blank page ?? (i didn t set any password)
second: when go to mysql consol it says : Enter password:
I hit enter button but nothing happen
my config.inc.php in E:\wamp\apps\phpmyadmin3.2.0.1 look like this:
when change auth_type from config to cookie :phpmyadmin loaded but very slow and go to a blank page when submitted
I uninstalled wamp and installed it again but the problem still ?
What can i do ?
Thanks in advance
ballack, you’re running a latest updated wamp version which came out very recently and we did not try it out yet, but based on your error, you’ve already had another MySQL running and they’re conflicted that results phpMyadmin runs slow, and when you made the changes, it does not take effect properly
Hey,hi
Just finished all the steps BUt as i mentioned i did not find that php_mcrypt file in extensions but the best part is :
I DID NOT GET ANY ERROR message while logging in.
THIS IS THE BEST instruction set that took my ride so so smoothly.
I ll highly recommend this to all PHP starters in the communities i ve joined,otherwise developers toil hours together JUST to get a server running with everything configured !
However,i d like to know why is that file missing i my php extensions and why does not my version ask for it?
Amit, the latest updated Wamp version just came out very recently and we did not try it out yet, so we’re not quite sure why it’s not there as it should be, but you can open file php.ini through Wamp tray icon and make sure there is no symbol ; in front of this line:
extension=php_mbstring.dllHi, excellent instruction set i EVER saw for any setup.
But this is my config:
phpmyadmin3.2.0.1
Apache2.2.11
mysql5.1.36
php5.3.0
I followed every step carefully But in the 15th step you mention about
“left click on wamp tray icon and select PHP, then PHP Extensions, then scroll down to click on php_mcrypt ”
But the problem is i Don’t see such a file ,should i download it extra from any site or how do i resolve it?
Hello.This article was extremely fascinating, especially since I was looking for thoughts on this matter last Monday.
I’m not having as much luck as some people on here… I’m using phpmyadmin3.2.0.1. At Step 8: I can’t find
$cfg[‘blowfish_secret’] = ”;
in the config.inc.php file. I was able to do everything else, including changing “config” to “cookie”. I tried skipping the step 8 and restarting, opening myPHPadmin, entering “root” and the password from Step 4… I got this error message
#1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
Thx!
Schiffy, in that step it stated “Next step is to add a line of codes below” so you just simply add that line of code 😉
You genius – thanks! 🙂
I want to share a problem and solution I ran into in case somebody else happens to experience the same:
After changing the password, I restarted WAMP and clicked on phpMyAdmin, and I was greeted with an error message in the browser. It said “Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly.”
To fix this, I had to change the windows permissions for the wamp installation directory. The group “users” did not have write permissions. When I gave full control permissions to the wamp folder and all child files/folders for the group “users”, my error went away and was given the login prompt.
If you are not familiar with how to do this, try right-clicking on the wamp folder in explorer and selecting properties. Go the security tab, click “advanced”, select the line that says “users”, click change permissions, click users again, click edit, check the box next to full control under “allow”, select “this folder, subfolders and files” next to the words “apply to” click ok to exit each window.
Mind you, each version of windows may be slightly different, so if it is not the same for you, do a google search on “change file permissions windows [xp, vista, whatever your version is]”
I hope this helps someone.
thanks a lot. This is the best step tutorial. my problem solved!!
but what’s wrong because phpmyadmin said it:
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.
Can u help me plz
Ary, 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 until the end of the guide 🙂
Download ResetMySQL here
http://downloads.jlbn.net/
To setup Password, follow this
http://blog.jlbn.net/?p=17
This is the best step by step tutorial I have ever read.
Thanks a lot!
10 fingers UP (hahaha)
Thanks so much for the guide to install WAMP. I always forgot these important and it takes me a long time. Now i have copied and pasted the guide into a word document, and it is my plan to add joomla installation to this guide and make it public. how about that, maestro!!
george
George Davis, to setup Joomla on Wamp, follow this
http://blog.jlbn.net/?p=32
Using last version of Wamp 2.0i following all steps carefully, but I cannot
login from the login window. No error messages , just the same login window and nothing. Yes I’ve done the backup, and can restore all again.
I cannot believe this stupid thing can be so complicated. May be I just have to change the browser selection to IE7, which I don’t use but for testing purposes, as I use mainly firefox with NoScript activated.Even I disabled the Comodo firewall and Defense & Sandbox modules.
The fact is that I want something usable, my business is design, even if I have enough skill to manage all these. I will try once again or better give a try to Xampp
Niftydog, it sounds like your Firefox add-on causes the problem because it would post the error if you input wrong password or any other error if you did not setup properly
Thank you very much for your clear instructions. That worked great!
I have one small suggestion/question. If the config.inc.php file has no password set, instructions say to close the file.
The next instruction says to “find this line” — the auth_type line. But I just closed the file! I had to open it again to make sure that the auth_type was ‘config’.
Maybe put the auth_type instruction *before* the password instruction?
Thanks Skip Knox, will correct it 😉
After much toil trying to remove these errors, I give up.
It seems like it was much easier with the earlier version. Now, I am just stuck with this 1045 error. Yes, I did everything you said, and it still comes up with these errors.
On install, why don’t they just give you the opportunity to add a user id and password. This is a nightmare. I think I am just going to go with xampp. I have not had any problems like this at all.
Thanks,
Lynn
LynnStrauch, unless you’ve already had or having other MySQL running in your PC, you should not have any problem to follow the guide, so make sure to search and delete any my.ini (or my.cnf or my.cfg) file outside wamp folder
ps; i boot my computer EVERY DAY
hello friend. i want you to always remember what i am going to say now. i want to say someone somewhere in africa will always be grateful each time he boots his computer to you for helping him solve a problem. thank you so much.
ps; i boot my computer
Very good! I would like to receive blog updates into email, how?
If we already created the database with many tables in it, is it possible to create a password without reset mysql?
MS, it should not a problem but you should setup Backup first, just in case something go wrong or not as expected, you can restore back
To setup backup, follow this
http://blog.jlbn.net/?p=6