PDA

View Full Version : [ubuntu] MySQL changing password


satimis
October 14th, 2008, 10:02 AM
Hi folks,


I have run following command;
GRANT SELECT, INSERT, UPDATE, DELETE ON mail.*
TO 'mail_admin'@'localhost' IDENTIFIED BY 'mail_admin_password';



Now I need changing password.


Whether run following command;
mysql> UPDATE mysql.user SET Password = PASSWORD('new_password')
-> WHERE User = 'mail_admin@localhost';
mysql> FLUSH PRIVILEGES;


TIA


B.R.
satimis