password lost

[idcarlos]

Hi.

I have forgot my admin password  but I have full acessto to the database. I have try to put a null value in the admin password, but not work.

¿Any idea to "reset" my password?

Un saludo
Carlos Garces

[cyberman]

The password is encrypted  .

Hmm, I think you should install cmsms once again so you have the chance to set the admin password once again. In step 3 you should deselect the entrys "Create Tables" and "Install sample content and templates". Then it should work  ...

But make sure you have made a sql dump before for security reasons !!

[idcarlos]

I have made a cleand instalation in localhost and updoaded the cms_uses table.
It don't work ¿why?

[cyberman]

I have made a cleand instalation in localhost and updoaded the cms_uses table.
It don't work ¿why?

This cannot work. If you've made a clean installation you have the chance to set the admin password so an upload of cms_users table is not needed.

you should install cmsms once again so you have the chance to set the admin password once again. In step 3 you should deselect the entrys "Create Tables" and "Install sample content and templates".

Have you followed my instructions accurately ?

[Ted]

For future reference

Code: Select all

UPDATE cms_users SET password = '21232f297a57a5a743894a0e4a801fc3' WHERE user_id = 1;

will reset the password to 'admin'.

[idcarlos]

Thanks, it works

[jelle]

md5('plain password') work too instead of the long encrypted line? At least that is how I do it in my new debian package and both postgres and Mysql swallow it.

[lennon]

UPDATE cms_users SET password = '21232f297a57a5a743894a0e4a801fc3' WHERE user_id = 1;

Having the same issue and the re installation isnt working.

Where do i put this code...........................? Havent a clue...

thanks

[jelle]

it is a sql query, so you can enter it in a sql prompt on the commandline, or at a mysql admin program over the web. (phpmyadmin or the likes)

Yes, you will have to have some knowledge, so in some cases reinstalling might be a quicker option.

[mustis]

what was the standard password?

[cyberman]

There's no default password - you have to set it in install procedure.

[sebgonz]

Thanks a lot. This saved my butt big time. Stupid me... I can't believe I forgot to email myself my password.

[kurieuo]

Any chance for there to be a 'forgot password' option at the CMS login that auto resets the password for you?

Handy for other CMS users (besides Admin) who forget password. Saves us having to reset for them.

Cheers

[cyberman]

Any chance for there to be a 'forgot password' option at the CMS login that auto resets the password for you?

Good idea. Perhaps you should add a feature request 

http://dev.cmsmadesimple.org/tracker/?a ... unc=browse

[Franck]

Just submitted it at feature requests