There are occasions when we forget or don’t have password to some website admin logins. Same thing happened to me today when I was trying to login to concrete5 installation on my localhost.
Lost concrete5 admin password
As I was using it on localhost, i can’t ask it to mail me the password (without configuring the mailserver on my computer or by uploading the site to webserver).
I tried adding custom password with md5 hashed value to concrete5 database directly via phpmyadmin but it failed. So then how to fix it?
How to recover / change concrete 5 admin password via phpmyadmin on localserver
Well, the solution is simple, you have to enter new md5 password to users table (user we want to change the value for) in mysql database via phpmyadmin, but with a slight modification.
We first need to generate the md5 hash using the password_salt value for our concrete5 installation. Our attempt to insert new password to mysql database via phpmyadmin directly by using built in md5 function in input field failed because we didn’t use the salt value for our conrete5 installation. So how to do this? simple enough:
- create a new php file in your localhost directory
- copy this code to it:
<?php echo md5('password'.':'.'salt'); ?>
- change “password” to your password that you want to use and “salt” to the salt value for your concrete5 installation (found in: /config/site.php file)
Run this file and copy the value echoed by it. Now enter this value in phpmyadmin to your users password (don’t md5 it again).
Now try logging in and it will work inshaAllah.
7 comments on “How to retrieve concrete5 admin password via phpmyadmin”
This helped out but rather than using phpMyAdmin, I just did a query instead:
update Users set uPassword=’PASSWORD’ where uName=’USER’;
thanks for the tip Patrick
thx, it works :-)
Way too good. Saved me just now.
Been using Concrete5 since 2012. Now, can’t reset user or password. I need step by step help without all the computer speak. Come on I’m 80 yrs. old.
Thank for commenting Tom. I can help you recover it. Please let me know if you still need it done.