Page 1 of 1

Lost admin password

Posted: Sun Sep 30, 2007 1:40 am
by janggu
Hi there,

I forgot my admin password and wonder if there is a way to reset this. I can access the database though. It looks like the password for the admin was encrypted and I overwrote it anyway. Still does not work. I created a new user but it would not work either. PLEASE HELP!!!

Re: Lost admin password

Posted: Sun Sep 30, 2007 2:38 am
by calguy1000

Re: Lost admin password

Posted: Thu Mar 12, 2009 7:01 pm
by ssah
I have found another way to change your password if you have lost your admin password, as long as you have access to the database.

Visit http://md5encryption.com/ and enter a password to encrypt with MD HASH

copy the hash.

Next..........

1 Log into your database (I use phpMyAdmin)
2 open cms_users in the database and edit the password field.
3 save and your done!

Alternatively, if you use command line SQL, log into your database and execute the following....

Code: Select all

UPDATE `[YOURDATABASENAME]`.`cms_users` SET `password` = '[MD5 HASH]' WHERE `cms_users`.`user_id` =1 LIMIT 1 ;
be sure to replace [YOURDATABASENAME] with your actual database name and [MD5 HASH] with the hash you just created

Once its saved, go to your login page and hey presto, you're in!!

Re: Lost admin password

Posted: Tue Apr 07, 2009 2:55 pm
by Edmontonabguy

Thanks for all the help. WOW that link was not anywhere else I could have found it.
Cheers
FYI - It did NOT help...

Re: Lost admin password

Posted: Tue Nov 09, 2010 5:22 am
by fearmydesign
8) This was extremely helpful! Thank you everyone  ;)