admin locked out, mail module was not working - pw reset, what now?

[zoolkhan]

i am still in the process of installation and configuration, so the mail module functionality was not
confirmed to be working when i did this:

a) clicked "send details" to see _if_ the mailing works, unaware that "sending details" equals resetting password
(i expected my current details to be sent to the given addres, not a whole new password)

b) tried to logon with my password which i believed was not changed - three times wrong (suspected typos)

c) bang, locked out.   I have never received the new "reset password" since mailing is not yet functional

-- now where can i look for the current password, so i get back in?

thanks a lot.
zool

ps: i do also speak german fluid, incase the knowing person prefers it.

[crnogorac081]

Hi,

login to your database and execute this sql query:


UPDATE `users` SET `user_id` = 1, `group_id` = 1, `active` = 1, `username` = 'admin', `password` = '21232f297a57a5a7438 94a0e4a801fc3', `remember_key` = '', `last_reset` = 0, `display_name` = 'Administrator', `email` = 'your@email.com', `timezone` = 0, `date_format` = '', `time_format` = '', `language` = '', `home_folder` = '', `login_when` = 1116871899, `login_ip` = '127.0.0.1' WHERE  `user_id` = '1';

it will reset your password to "admin"

cheers

[crnogorac081]

Also chech this FAQ:

http://help.websitebaker.org/pages/en/faq.php#question_24

cheers

[zoolkhan]

thanks a lot, and appologies for not finding it in teh f.a.q. myself

[crnogorac081]

np. just next time, please dont double post..

[BerndJM]

just for information:
deleted your double post.