Lost admin password

[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!!!

[calguy1000]

http://wiki.cmsmadesimple.org/index.php/FAQ/Login

[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!!

[Edmontonabguy]

http://wiki.cmsmadesimple.org/index.php/FAQ/Login

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

[fearmydesign]

This was extremely helpful! Thank you everyone