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) 😉
Excellent guide…thank yoe
It’s a shame you don’t have a donate button! I’d definitely donate to this superb blog!
I guess for now i’ll settle for bookmarking and adding your
RSS feed to my Google account. I look forward to brand new updates and will share this site with
my Facebook group. Chat soon!
The tutorial was very clear, simple and helpful as i have succeeded to remove the no passsword warning after creating a password through the help of your tutorial. However, am faced with a new challenge after the proccess. I saw this notice “The additional features for working with linked tables have been deactivated. To find out why click here.” and when i tried to create a new user by clicking “create” i got this message “#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1″ on the upper part of the page. Please how do i resolve this problem? I am a novice in PHP and MySQL. I only started learning Joomla on Wamp server.
i meant when i tried to create a new database i got this error message “#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1″
Ugsams, since you might never need to use linked tables, don’t ever click on that link. If you did, you will get the issue to run MySQL properly which might be the cause for your second issue, so the only way is to reinstall MySQL. However, if you’re not sure how to reinstall just MySQL, then the easier way is to uninstall both Wamp and firewall/antivirus, remove wamp folder, run regedit to search and delete 2 registries wampapache and wampmysql, restart PC, reinstall Wamp first then reinstall firewall/antivirus AFTER and WHILE Wamp is running
Hello. As i have looked some of the running process of wampserver, but when i give a click to phpmyadmin, it says like this ‘MySql said: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.
What should i do so that i can get access to it..? how can i create a password for root and in which tool..mysqlconsole get close when i hit for Enter password:
Reply me the correct procedure please..Thank you..:)
Make sure you don’t have any other Apache, MySQL, and/or PHP in your computer by search and uninstall/remove any Apache, MySQL and PHP outside wamp folder
Hi there,wampserver runs very well but whenever I try to acess phpmyadmin I see the message as: http://s1301.photobucket.com/user/Angelsmiley103/media/localhost_zps6727cfd5.jpg.html?sort=3&o=0
So plz help me out
AIKO, seems you have another PHP, MySQL, or Apache so you should eliminate any other PHP, MySQL, or Apache outside Wamp folder
Got stage 1 password set
Works Thanks
Look forward to doing the rest of the tutorial
$cfg[‘blowfish_secret’] = ”;
is the code to insert into config.inc.php
<?php
/* Servers configuration */
$i = 0;
/* Server: localhost [1] */
$cfg['blowfish_secret'] = 'mysecret Phrase';
$i++;
$cfg
Is that correct! Hope so because that is what I did. If wrong I will retrieve the backup file you wisely asked me to create.
If so please be aware that I was confused a little by the instructions.
Much appreciate your efforts with this guide,impossible for me to cope without it.
Just a few words to say… thanks a lot !! this is a nice helpful detailed tutorial ;-))
I am using wamp server 2.2 and through phpmyadmin, I have created a database by name phpdata. Following is my code
Which I have edited from http://www.freewebmasterhelp.com/tutorials/phpmysql/2
I am a total beginner and dont know why it gives the error:
Unable to select database
Please guide
Please also tell where should be the database savd a I created it.
Asad, you nee to follow our guide to setup a Database Account first 🙂
Don’t get us wrong; that guide is very educated but for the new beginner like you, it’s much easier to follow our step-by-step guide to create the database
Setup Database guide
You have missing one ” in $cfg[‘Servers’][$i][‘password’]
so change that line to $cfg[‘Servers’][$i][‘password’] = “”;
Naim, they’re single quote, not double quote
shefali, follow JL’s advice for Aditya above, then do these steps:
Download ResetMySQL here
http://downloads.jlbn.net/
You should set Backup right after set WAMP successful so you can restore if having issue
To setup Backup, follow this
http://blog.jlbn.net/?p=6
To setup Password, follow this
http://blog.jlbn.net/?p=17
I click phpmyadmin and nothing loads.
http://i1187.photobucket.com/albums/z395/Goku_Briefs/d_zps2396eba2.jpg
Help me fast please!!!
Saadat Khan, is your Wamp running? I don’t see it in the system tray 🙁
hello
I am trying to use the wamp server 2.2 and getting the following error in Phpmyadmin page.
#1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
the config.inc is as:
$cfg[‘Servers’][$i][‘verbose’] = ‘localhost’;
$cfg[‘Servers’][$i][‘host’] = ‘localhost’;
$cfg[‘Servers’][$i][‘port’] = ”;
$cfg[‘Servers’][$i][‘socket’] = ”;
$cfg[‘Servers’][$i][‘connect_type’] = ‘tcp’;
$cfg[‘Servers’][$i][‘extension’] = ‘mysqli’;
$cfg[‘Servers’][$i][‘auth_type’] = ‘config’;
$cfg[‘Servers’][$i][‘user’] = ‘root’;
$cfg[‘Servers’][$i][‘password’] = ”;
$cfg[‘Servers’][$i][‘AllowNoPassword’] = ‘true’;
please help me out
thanx
hello
I am trying to use the wamp server 2.2 and getting the following error in Phpmyadmin page.
#1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
the config.inc is as:
$cfg[‘Servers’][$i][‘verbose’] = ‘localhost’;
$cfg[‘Servers’][$i][‘host’] = ‘localhost’;
$cfg[‘Servers’][$i][‘port’] = ”;
$cfg[‘Servers’][$i][‘socket’] = ”;
$cfg[‘Servers’][$i][‘connect_type’] = ‘tcp’;
$cfg[‘Servers’][$i][‘extension’] = ‘mysqli’;
$cfg[‘Servers’][$i][‘auth_type’] = ‘config’;
$cfg[‘Servers’][$i][‘user’] = ‘root’;
$cfg[‘Servers’][$i][‘password’] = ”;
$cfg[‘Servers’][$i][‘AllowNoPassword’] = ‘true’;
please help me out
thanx
HELLO
ACTUALLY INSTEAD OF BELOW ERROR
#1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
I AM FACING THIS ERROR
#1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
PLEASE RESOLVE IT SOON
hello
I am trying to use the wamp server 2.1 and getting the following error in Phpmyadmin page.
#1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
the config.inc is as:
$cfg[‘Servers’][$i][‘verbose’] = ‘localhost’;
$cfg[‘Servers’][$i][‘host’] = ‘localhost’;
$cfg[‘Servers’][$i][‘port’] = ”;
$cfg[‘Servers’][$i][‘socket’] = ”;
$cfg[‘Servers’][$i][‘connect_type’] = ‘tcp’;
$cfg[‘Servers’][$i][‘extension’] = ‘mysqli’;
$cfg[‘Servers’][$i][‘auth_type’] = ‘config’;
$cfg[‘Servers’][$i][‘user’] = ‘root’;
$cfg[‘Servers’][$i][‘password’] = ”;
$cfg[‘Servers’][$i][‘AllowNoPassword’] = false;
please help me out
thanx
Aditya, first thing first, try to search your computer to check if you have any OTHER Apache, MySQL, and/or PHP.
You might have these questions: What OTHER mean? How to distinguish them?
OTHER means that Apache, MySQL and PHP that are NOT come with WampServer. To distinguish them is very easy as Apache, MySQL and PHP that come with WampServer will always reside inside “wamp” folder, so if you see any OTHER outside “wamp” folder, you have to uninstall / remove them.
No matter you find any OTHER or not, post back here and we go to the next step 🙂
Thank you so very much for this great, step-by-step, easy to follow guide. I was racking my brains trying to figure out how to configure WAMP. The configuration script that came with my package didn’t work. Great job!