Reset password from database on PS 1.7

[Vee.K727]

So I installed Prestashop 1.7 on localhost and have lost my password. I can't reset it the normal way so I'll have to manually change it in the database (right?). It doesn't seem like the password in the database is a simple md5 hash so I haven't tried editing it directly.

 

I saw a post on Stack overflow suggesting to obtain _COOKIE_KEY_ from settings.inc.php file and using 

md5(_COOKIE_KEY_.$password);

to generate password hash for db. Problem is the said file is now empty and only has a comment in it

// Deprecated 1.7

I can't find where the key is now. Can anyone help me with this?

[rocky]

I had a look at my PrestaShop v1.7.0.4 test site and it appears to be on line 20 of app/config/parameters.php.

[Vee.K727]

Thanks rocky. Is it cookie_key or new_cookie_key that is being used?

[rocky]

I'm not sure. Maybe new_cookie_key. Try both and see which one works and let us know.

[Damiano97]

Sorry I would have a question. Why does not the md5(cookie_key.$password) match the passwd in the db? thank you

Edited July 14, 2017 by Damiano97 (see edit history)

[Puriom]

You have to use cookie_key, NOT  new_cookie_key .