How to reset mysql user password in linux through command prompt

Login to MySQL.

mysql -u root -p

In mysql prompt use

mysql> use mysql;

Now change the password for user “seemab”   to  “bird.123″ as below :

[mysql> update user set password=PASSWORD("bird.123") where User='seemab';]