Change admin password through phpmyadmin

[finelinecreative]

My client has a site on the GoDaddy servers.
I need to change the admin password but am not receiving the email using the normal process through the login panel.
How can I change the admin password through phpmyadmin?

thanks

[mnakalay]

hello. You cannot change the password through phpMyAdmin because the password is not saved in the database. What is saved in the database is a hash of the password.

Here’s an article that lists all ways of logging back in as an Admin. If you are in a hurry and want the quick and dirty but effective way, go straight to the last one.

The complete guide to recovering a user password in concrete5 - Kalmoya.com

Once you’re logged in just change yor password from the dashbaord

[hutman]

If you have access to phpMyAdmin you can copy the Password Reset link from the Logs table record and put it into your browser to go through the normal Password Reset steps.