Blog

SET PASSWORD = PASSWORD('newpassword') 

SET PASSWORD FOR login@localhost = PASSWORD('newpassword');
SET PASSWORD FOR login@"%" = PASSWORD('newpassword');

UPDATE mysql.user SET Password=PASSWORD('newpassword')
WHERE User='login' AND Host='localhost';
FLUSH PRIVILEGES; 

GRANT USAGE ON DB.* TO login@localhost IDENTIFIED BY 'newpassword';

mysqladmin -u login password newpassword