View Single Post
  #4  
Old 21st October 2008, 16:38
marpada marpada is offline
Senior Member
 
Join Date: Sep 2008
Posts: 139
Thanks: 2
Thanked 14 Times in 14 Posts
Default

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;
________
Fix ps3
________
Lovely Wendie99

Last edited by marpada; 13th May 2011 at 01:50.
Reply With Quote