How to change admin password in the table of the mysql database?

You can use following command to do the same :

=====
update agb_book_auth set password=MD5("newwpass") where username="admin";
=====

Where table agb_book_auth contains admin and password attributes.

OR :

=====
update wp_users set user_pass = 'b15a2021cb835426552c5d8599d5c7ab' where user_login = 'admin';
=====
Then execute : flush privileges;

By : singlehop.com