Showing posts with label mysql. Show all posts
Showing posts with label mysql. Show all posts

Wednesday, September 12, 2012

Change Mysql Password in WAMP server

1.Install wamp2 server

2.Start->run->cmd->

3.Type cd\ and press enter

4.Locate your mysql directory(like this is my default directory C:\wamp
\bin\mysql\mysql5.1.36\bin)


5.After like this you should have do C:\wamp\bin\mysql\mysql5.1.36
\bin> 
mysql -u root -h 127.0.0.1 -P 3306 -p press enter after you got 
Enter Password don't put anything simply click enter button

6.After like this mysql>

7.simply type mysql>use mysql;
mysql>show tables;
mysql>select * from user \G;

8.You can set your new password: mysql> UPDATE mysql.user SET
Password=PASSWORD('xxxx') WHERE User='root';
 (where replace 'xxxx' 
with your new password) 
(eg.mysql> UPDATE mysql.user SET Password=PASSWORD('muthu') WHERE
User='root';
)

9.Finally type mysql> FLUSH PRIVILEGES; 
mysql>exit;

10.Check your settings: mysql> mysql -u root -p
enter password:*****
 
press enter button.....


Add/Change password in phpMyadmin's config file(named config.inc.php under phpMyadmin folder) and change false to change.

From : http://www.kirupa.com/forum/showthread.php?279644-How-to-reset-password-in-WAMP-server