changing md5 encrypted column (password) in mysql

We can use the below steps when you want to change the md5 encrypted password stored in the database (example xx) in the table yy,

select the table to which you want to change the password as,
> use xx;
> show tables;
> select * from yy;

you can check the validity of the password by calling,
> select md5('old-password');
This will show the exact values of the password column

then using "update" query to change the password.
> update yy set password = md5('new-password') where username='somename';