PrestaShop Forums: Setting configuration database user and password in database - PrestaShop Forums

Jump to content


Welcome to the PrestaShop Forum! We hope you'll share your comments and suggestions with us. We ask that you please post in English to the main sections of the PrestaShop Forum. If you want to write in another language, please post in the corresponding PrestaShop Community section below.

Please note that PrestaShop Community sections are largely self-moderated. PrestaShop team members may or may not participate in non-English sections. To improve the chances of receiving feedback to your question or comment, please post it in English to the main sections of our Forum.

NYC

Vous parlez français ? par ici !


Setting configuration database user and password in database


Setting configuration database user and password in database

#1 dankimhi

    PrestaShop Newbie

  • 10 Mar 2010
  • Members
  • Pip
  • 9 posts

Posted 08 July 2010 - 10:18 AM

Hello,

I have lost access to my backoffice due to a problem with the database user's password.
Could you please indicate how to set the user's name and password directly in the database (which table, field and value)?

Thanks,

Dan

#2

    PrestaShop Newbie

  • 15 Dec 2011
  • Members
  • Pip
  • 0 posts

Posted 09 July 2010 - 07:33 AM

this here
config/settings.inc.php

#3

    PrestaShop Newbie

  • 15 Dec 2011
  • Members
  • Pip
  • 0 posts

Posted 09 July 2010 - 10:51 AM

Get your COOKIE_KEY from config/settings.inc.php, then add a password with at least 8 characters after it, then run the concatenated string through an MD5 generator like the one here, then put the result in the passwd field of the employee in the ps_employee table.

#4

    PrestaShop Newbie

  • 15 Dec 2011
  • Members
  • Pip
  • 0 posts

Posted 09 July 2010 - 10:55 AM

From 1278669094:

Get your COOKIE_KEY from config/settings.inc.php, then add a password with at least 8 characters after it, then run the concatenated string through an MD5 generator like the one here, then put the result in the passwd field of the employee in the ps_employee table.
or newadmin.php upload your admin folder and create new admin.

Attached File(s)







1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users