How to set password to an existing MySQL user account?

by Ramya 2008-06-02 17:31:40

SET PASSWORD statement assigns a password to an existing MySQL user account.

For example,

> SET PASSWORD FOR 'user_name'@'host_name' = PASSWORD('newpass');

> where user_name and host_name are exactly as they are listed in the User and Host columns of the mysql.user table entry.

Tagged in:

1236
like
0
dislike
0
mail
flag

You must LOGIN to add comments