Admin password reset

Hi guys,

I have a site written in PHP and today set about an admin password reset. i changed the password and was told that this was successful however i now cannot log in through admin.

How can i re-set this? i am assuming i can do this through access in the cpanel. Any help much appreciated !

 

Look at cPanel > MySQL Databases > PHPMyAdmin

 

Hi,

I am in the cpanel now and now here 3rdparty/phpMyAdmin/index.php any idea where to go from here?

 

Before you do any manual editing check and see if there is a separate PHP file that came with your site that fixes things like this such as admin password reset or cookie domain reset etc. If not do this:

• Log Into Cpanel
• Go Into PHPMYADMIN
• On the left there should be a list of databases. Click on one that your site uses.
• A list of tables should appear. Click your users tables or if admins are stored in a different table click that.
• Click on SQL and run this query. Make sure to change the variables to fix your needs. Edit it and paste it into the box and click Go.

UPDATE admintable SET adminpass='password' WHERE adminid='1'

Code (markup):

After that your password should be whatever is in between the single quotes for adminpass

 

Err, can't you do another password reset?

 

Brandon, Hamidof,

Thanks a mil for the help. the problem was that i entered too long a password. the database had told me it accepted all the characters but missed off the last letter ! All resolved now though!