I forgot the admin user/password of moodle, but i have mysql access. How can i restore the admin password?

Login to the mysql prompt.
use table_name
update mdl_user set password='0192023a7bbd73250516f069df18b500' where  username='admin';
quit

I know moodle is using MD5 encryption.
The above mentioned is MD5 encryption of admin123

Login to the admin panel with password admin123 It works!!!