I am the sole administrator of a small website I had built for me a few months ago. I have full access to the cpanel and can view all the data in the database through phpmyadmin with no problem.
This website has one admin user registration, in a separate table from the other user registrations. Unfortunately I haven't logged into the site (as opposed to cpanel) for ages and I now cannot remember the password for this admin account. The specific reason I need to have this password is that there is a user interface with the admin account that means I can manage the site directly rather than through the database. I do not know what email address the web developer used to set up the admin account so I cannot have the password resent, and I cannot currently ask him.
Is there a way I can either reset the password for the admin account through cpanel or phpmyadmin, or add a new admin user with a password I select?
I have tried going in phpmyadmin to the table with the admin user in it, and inserting a new admin user with username admin2, password 'admin2password', setting the function of the password as MD5 and adding this new user, but going to the site and trying to log in with admin2/admin2password does not work.
Thanks in advance.