Wednesday, February 16, 2011

Setting a Password for user 'root' WAMP

Once you may installed wamp it gives this error (As it does ever time)

"Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole by setting a password for user '.root'."

To fix this you have to set "password" for user "root" (default it hasn't any password)
  1. Open phpmyAdmin( where this error occur)

  2. click Privileges tabROOT password set WAMP
  3. Select user 'root' and Edit privileges
    WAMP password set for user root

  4. In next opened window locate "Change password"

  5. Select radio "password" and type your password and make sure retype it too and click "GO"

Now we have to configure "" for phpmyadmin otherwise we won't be able to access our mysql databases via phpmyadmin as it default comes with no password but now our mysql server expecting a password from every application that want to connected to it.
  1. Locate the file in my case it is in the directory "c:\wamp\apps\phpmyadmin3.2.0.1"
  2. Find "$cfg['Servers'][$i]['password']" and type your password there "$cfg['Servers'][$i]['password'] = 'yourPassHere';"
  3. Save

and we done


area rugs cheap said...

You shared a detailed steps of configuration setup. It is very useful for us we can easily setup with help of your steps.

Post a Comment