How to get back my admin account?

I use elgg 1.6. I somehow lost my admin account password, so I input my email to get it back, but it seems that the system send me an invaild link.

I had tried to change the password(md5) via phpmyadmin, but when I tried to login, it always requests me to click the link in email to verify.

Which table or field in mysql is for verifying? Can I change this in phpmyadmin?