set /change password in MYSQL

by Nirmala 2009-06-29 18:03:35

Hi...
Use the below query to change/set the password in MYSQL Query Browser.
SET PASSWORD FOR root@localhost=OLD_PASSWORD('newpassword');

Example:
SET PASSWORD FOR root@localhost=OLD_PASSWORD('mysql');
Now, Password can be changed to mysql.

Tagged in:

1875
like
1
dislike
0
mail
flag

You must LOGIN to add comments