• Content
  • Comments (0)
  • Related articles
Jul
11
2012

How to set MySQL password in WAMP Server Wednesday, 11 July 2012

By default [ root ] password for WAMP Server is [ blank / empty ]. To set the password for first time login into MySQL Console by pressing [ Enter ] for no password (click WAMP tray icon > MySQL > MySQL Console) and use following command:

SET PASSWORD FOR root@localhost=PASSWORD(“your_passord_here”);

If you need to change the password use the following command:

UPDATE mysql.user SET Password=PASSWORD(“your_passord_here”) WHERE User=’root’;

 

*pay atention at the syntax, specially for variable declaration, like (“your_password_here”) – so !!! is not (‘your_password_here’) nor (your_password_here)

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*