Forgotten / Lost Password - Manual Reset via phpMyAdmin

[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 File(s)

•  prestashop_pword_hash.php (2bytes)
  Number of downloads: 1591

[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