• RSS
  • Delicious
  • Facebook
  • Twitter

JLBN

Free Guides, Themes, Photo, Games, Movies

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) ;)

[Read more...]

268 Responses so far.

  1. Aditya says:

    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

    • JL says:

      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 :)

  2. shefali says:

    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

    • shefali says:

      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

    • shef says:

      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

  3. BN says:

    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

  4. Naim says:

    You have missing one ” in $cfg['Servers'][$i]['password']

    so change that line to $cfg['Servers'][$i]['password'] = “”;

  5. Asad says:

    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.

    • JL says:

      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

  6. Ludger says:

    Just a few words to say… thanks a lot !! this is a nice helpful detailed tutorial ;-) )

  7. Tony Cotton says:

    $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.

  8. Tony Cotton says:

    Got stage 1 password set
    Works Thanks

    Look forward to doing the rest of the tutorial

  9. AIKO says:

    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

    • JL says:

      AIKO, seems you have another PHP, MySQL, or Apache so you should eliminate any other PHP, MySQL, or Apache outside Wamp folder

  10. Mohammed Azran says:

    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..:)

    • JL says:

      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

  11. Ugsams says:

    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.

    • Ugsams says:

      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″

    • JL says:

      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

  12. seo says:

    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!

  13. Louis Buevink says:

    Excellent guide…thank yoe

You must be logged in to post a comment.

  • Get Chitika Premium
  • JLBN - Place Your Banner Here
  • JLBN - Place Your Banner Here