set password user mysql

set password user mysql

To Set password for a User in Mysql database run this query.

set password for cacti@localhost=PASSWORD('cacti');

Solution:

http://dev.mysql.com/doc/refman/5.0/en/set-password.html