View Single Post
  #5  
Old 21st October 2008, 19:02
satimis satimis is offline
Senior Member
 
Join Date: Oct 2006
Posts: 533
Thanks: 4
Thanked 2 Times in 2 Posts
Default

Quote:
Originally Posted by marpada View Post
mysql> UPDATE mysql.user SET password=PASSWORD('newpassword') WHERE user="'mail_admin'@'localhost'";

or

mysql> USE mysql;
mysql> SET PASSWORD FOR 'mail_admin'@'localhost' = PASSWORD('newpassword');

and last

mysql> FLUSH PRIVILEGES;
Hi marpada,


I got password changed. Thanks


B.R.
satimis
Reply With Quote