How to set password to an existing MySQL user account? - Mysql Views : 681
Tagged in : Mysql
Send mail vote down 0 vote down 0
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.
By - Ramya, On - 2008-06-02




    Login to add Comments .