[SOLVED] Can’t log into BO

[Kelvin Ong]

Hi,

Continue from {http://www.prestashop.com/forums/viewthread/72904/general_discussion/solved_cant_log_into_bo}

I’ve similar problem, I’ve tried to access /config/setting.inc.php
I can only see the db details and no {UPDATE ps_employee SET passwd = md5(’_COOKIE_KEY_YOUNEWPASSWORD’) WHERE email = ‘YOUEMAILADDRESS’;}

Please advise solution.

Thanks & regards,

Kelvin Ong

[shokinro]

I’ve similar problem, I’ve tried to access /config/setting.inc.php
I can only see the db details and no {UPDATE ps_employee SET passwd = md5(’_COOKIE_KEY_YOUNEWPASSWORD’) WHERE email = ‘YOUEMAILADDRESS’;}

You will never find the SQL statement there. What you can find is definition of _COOKIE_KEY_ in /config/setting.inc.php, here is an example:

define('_COOKIE_KEY_', '9SvNosdbfyPFgPigOuMsdsd4fcKmb5dVmOdhRvL88fr1GkCDjWmjCiYbRf82');

use the this _COOKIE_KEY_ to create a SQL statement to change your password.

assume your new password is "ABCDEFGH", you email address if "[email protected]", the SQL statement will be

UPDATE ps_employee SET passwd = md5(’9SvNosdbfyPFgPigOuMsdsd4fcKmb5dVmOdhRvL88fr1GkCDjWmjCiYbRf82ABCDEFGH’) WHERE email = ‘[email protected]’;

[shokinro]

For your reference, I just created an image to show the instructions on how to create SQL statement.
You will need to run the created SQL statement against your database to change your password.
You can run the SQL statement via database management tools like MyPhpAdmin.
Hope this help. (See attached)