How can I change the password for admin account when login??

I lost my password to login to the admin page.
I logged into cpanel ->phpadmin->myDatabase->User table to change the password for my account (I chose MD5 to encrypt the pass)
However, when I login back into the admin page, it says that the username or password is not correct
Can you help me with this problem?

Contact the item author for the free support.