8 replies to this topic

[system7]

I tried to do this following the instructions here and it kept on failing. I have run into this problem before with a CMS that I created on my own.

I have noticed that when you try and run an md5 through MySQL the result sometimes be different than if you do it via PHP, although you won't notice anything besides failed login attempts with the new password. I think what really happens is that the syntax gets messed up or there are errors between copying and pasting / extra white space characters (ie. there is either a leading or trailing space that you may not notice). By the very nature of running a hash the values should be the same from SQL or PHP, it shouldn't matter.

So after screwing around trying to do it with SQL I went ahead and created a simple PHP script to create the correct hash and it worked.

See attached file for the script... follow the commented instructions.


Good Luck!

Attached Files

•  prestashop_pword_hash.php   2bytes   1713 downloads

[pjssms]

I found this somewehre else and it worked.

UPDATE `ps_employee` SET `passwd` = MD5('<_COOKIE_>password') WHERE `ps_employee`.`id_employee` = 1;

Where cookie is from config file and password is the password you want.

[dkfranc]

The attached file worked perfect. Just follow the instructions given.

Thanks a lot

[RemiB]

It worked perfectly for me! Thanks!

pjssms, on 06 October 2010 - 12:56 PM, said:

I found this somewehre else and it worked.

UPDATE `ps_employee` SET `passwd` = MD5('<_COOKIE_>password') WHERE `ps_employee`.`id_employee` = 1;

Where cookie is from config file and password is the password you want.

[skipperfoto]

THANK YOU!!!!! it works like a charm!

[bluswall267]

I too have lost the password to the admin page. I read the replies but they are too advanced for me. I what is PHPMYADMIN and where can I find it?
My question is this: How do I find or reset the address to go to my admin page?
I would be grateful for any help

[Pippo3000]

From 06 October 2010 - 12:56 PM:

I found this somewehre else and it worked.

UPDATE `ps_employee` SET `passwd` = MD5('<_COOKIE_>password') WHERE `ps_employee`.`id_employee` = 1;

Where cookie is from config file and password is the password you want.

worked also for me. thanks

[aletomsic]

guys i'm having exactly the same problem, but i can't fix it with the above instructions. i've even tried the php script. i am able to execute the query with no problem, but the login problem remains. any other ideas? this si the sql sintax of my command:

UPDATE ps_employee SET passwd=md5('ILGE3SN1jaNM6hErPDYPBWgCBPpOSBYfaxfJsikAcMimaJF5ZwJPhwQz123456789') WHERE `id_employee`=3;

it runs successfully but does not solve the problem. i have also tried with 'email' instead of 'id_employee'.

please help!

[aletomsic]

guys i'm having exactly the same problem, but i can't fix it with the above instructions. i've even tried the php script. i am able to execute the query with no problem, but the login problem remains. any other ideas? this si the sql sintax of my command:

UPDATE ps_employee SET passwd=md5('ILGE3SN1jaNM6hErPDYPBWgCBPpOSBYfaxfJsikAcMimaJF5ZwJPhwQz123456789') WHERE `id_employee`=3;

it runs successfully but does not solve the problem. i have also tried with 'email' instead of 'id_employee'.

please help!