lost admin password

[yulises]

How can I recovere my admin password ?
I tried to cahnge it in the data base (no luck ..)
I will appriciate for a good description how to do it

Thank you in advance
Nimrod

[michael_s]

You can have the admin panel login screen send you a new password. Click the lost password link.

You can also modify the admin password by directly editing the database password field.

Enter this hash into the field:

05cdeb1aeaffec1c7ae3f12c570a658c:81

This will reset the password to:

admin

[yulises]

Thank you
appriciat you quick replay

[jeep11]

You can have the admin panel login screen send you a new password. Click the lost password link.

You can also modify the admin password by directly editing the database password field.

Enter this hash into the field:

05cdeb1aeaffec1c7ae3f12c570a658c:81

This will reset the password to:

admin

Sorry to ask this but how do you do this in easy newbie laymans terms, via mysql?? I've tried the recover password but it does not recognise my email address? Is there a way to reset it via editing some file somewhere on the server? basically after install I changed my user name via the admin panel but I did not see any way to change the password, all was fine until I tried to change from the default admin@localhost, now I'm stuck??

[michael_s]

Edit the admin password field directly in the database. Use a neato visual editor like phpmyadmin if you don't know how to do it manually (or can't because your host won't let you).

[jeep11]

Worked out myself in the end via PHPmyadmin, thanks for swift reply, appreciated.

[jmelson]

You can have the admin panel login screen send you a new password. Click the lost password link.

You can also modify the admin password by directly editing the database password field.

Enter this hash into the field:

05cdeb1aeaffec1c7ae3f12c570a658c:81

This will reset the password to:

admin

OK, I'm a complete newbie to sql. I can see the existing value with :
select admin_password from admin;

but I haven't figured out how to correctly write a "load data" command to sql to overwrite the old value with the one you show above. I've been trying variations on the form

load data "05cd.......c:81" into table admin;

without any success. The mysql "manual" ia way too thin, it must assume you already know sql.

Thanks,

Jon

[jmelson]

OK, I'm a complete newbie to sql. I can see the existing value with :
select admin_password from admin;

but I haven't figured out how to correctly write a "load data" command to sql to overwrite the old value with the one you show above. I've been trying variations on the form

OK, I think I'm getting real close, now. This is what I have :

insert into admin values ('admin_password','05cdeb1aeaffec1c7ae3f12c570a658 c:81');

and I get :
ERROR 1136 (21S01): Column count doesn't match value count at row 1

Any ideas?

Thanks,

Jon

[jmelson]

OK, I think I'm getting real close, now. This is what I have :

OK, I figured out how to fix the sql database. The command was :

replace into admin() values ('5','n','Jon','Elson','elson','<my email>','05cdeb1aeaffec1c7ae3f12c570a658c:81','n', 'n','n','n');

then I had to delete the left over line with the wrong values :

delete from admin where admin_id=6;

Now the database looks ok, but when I log in as admin (which now works) and try to change my password, it asks for password confirmation, and gives me the wrong password message there! Any idea where it is looking for that password?

Thanks,

Jon

[jmelson]

OK, got it. The first two fields must be '1' admin_id and admin_groups_id. All back to working!

Thanks,

Jon