setting a password for user ‘root’ : wampserver way

Posted at November 4, 2009

When You open phpmyadmin from wampserver you’ll see message :

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 change the password just follow this technique.

Technique I (visual way)

1. Open phpmyadmin
2. Click Privileges

3. Click Edit icon in same line where host “localhost” located.

change mysql root password on windows1 setting a password for user root : wampserver way

4. Enter password by type it inside number 1 and 2 ( see picture)

change mysql root password on windows2 setting a password for user root : wampserver way

Click Go and you’re done.

Technique II (command prompt)

Open command prompt by click :

Start -> Run

Type ‘cmd’ and hit Enter.

change mysql root password on windows3 setting a password for user root : wampserver way

type following command :

(I mark the command in bold)

C:\wamp\bin\mysql>cd c:\wamp\bin\mysql\mysql5.1.36\bin

C:\wamp\bin\mysql\mysql5.1.36\bin>mysql -uroot -p

Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 5.1.36-community-log MySQL Community Server (GPL)

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> use mysql;

Database changed

mysql> update user set password=password(‘typenewpasswordhere’) where host=’localhost’;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> flush privileges;

Query OK, 0 rows affected (0.01 sec)

mysql>

Whatever technique you want to use, you should change the password as suggested by phpmyadmin.

See you in other post.

Stay health!

Related Reading:

Using DrupalUsing Drupal

With the recipes in this book, you can take full advantage of the vast collection of community-contributed modules that make the Drupal web framewo... Read More >

Drupal For DummiesDrupal For Dummies

Learn to set up, manage, and administer a Drupal Web site

Drupal offers unparalleled flexibility for content-managed Web sites, but most ... Read More >

Pro Drupal Development, Second EditionPro Drupal Development, Second Edition

Widely praised for its in–depth coverage of Drupal internals, bestselling Pro Drupal Development has been completely updated for Drupal 6 in thi... Read More >

Front End Drupal: Designing, Theming, ScriptingFront End Drupal: Designing, Theming, Scripting

“For Drupal to succeed, we need books like this.”

–Dries Buytaert, Drupal founder and project... Read More >

Cracking Drupal: A Drop in the BucketCracking Drupal: A Drop in the BucketThe first book to reveal the vulnerabilities and security issues that exist in the sites that have been built with Drupal?and how to prevent them from... Read More >

Thanks for reading, if you think this post help you please consider to buy me a beer

Search Terms :

  • 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 passwor
  • wamp server password
  • wampserver password
  • wamp server mysql password
  • your configuration file contains settings (root with no password) that correspond to the default mysql privileged account
  • 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
  • setting a password for user root
  • 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
  • fix this security hole by setting a password for user root
  • wamp server mysql root password
  • wampserver mysql password
  • wampserver root password
  • and you really should fix this security hole by setting a password for user root
  • wamp server root password
  • xampp 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 p
  • wampserver change root password
  • wamp server localhost password
  • wamp server password mysql
  • you really should fix this security hole by setting a password for user root
  • wampserver mysql root password

    • Share/Bookmark
    Tips

    If you enjoyed this post, please consider to leave a comment or subscribe to the feed and get future articles delivered to your feed reader.

    Comments are closed.