Jump to content

Database password change [prestashop 1.7]


Recommended Posts

I was stupid enough to change my mysql password in the ISPManager and now I can't get my store to work. Can't find where the database password is stored in prestashop 1.7. "settings.inc.php" doesn't seem to have it anymore. Please help ~_~

  • Like 1
Link to comment
Share on other sites

I was stupid enough to change my mysql password in the ISPManager and now I can't get my store to work. Can't find where the database password is stored in prestashop 1.7. "settings.inc.php" doesn't seem to have it anymore. Please help ~_~

Hi,

 

File:

/app/config/parameters.php

Sorry for my English,

  • Like 3
  • Thanks 6
Link to comment
Share on other sites

  • 2 years later...

Did anyone solved it?

I had same problem with my prestashop.

I changed database password , i updated it in parameters.php and then front office was working normal but backoffice wasnt working, returning 500 error , problems related to connection to database.

Then i changed back to old password and all worked perfect.

i am using PS 1.7.5.2

 

  • Like 1
Link to comment
Share on other sites

Hello,

To avoid problems, before changing parameters.php, clear the cache from the frontoffice (advanced parameters-performance). 

After changing parameters.php file, you have to clear cache manually by deleting all the folder into var/cache (prod & dev folders).

Regards

  • Like 3
  • Thanks 5
Link to comment
Share on other sites

  • 5 months later...
  • 3 months later...
On 10/31/2019 at 10:46 AM, David Casatta said:

Hi, unfortunately I changed the database pw in parameters.php without noting the old one ... I have the error 500 both on the backoffic and on the front office, how can I solve?
Thank you very much

Hello! I had the same problem and I was stuck. Turns out deleting /var/cache after changing the parameters.php file repairs the problem.

  • Like 3
Link to comment
Share on other sites

  • 4 weeks later...

Hello Frederic,

 

DON'T TOUCH THIS FIELD:  'secret' => 'v8xWjQHB3d3wBeHLcO5pYJ5.....

 

Database parameters are:

    'database_host' => 'MyHost',

    'database_port' => '',

    'database_name' => 'My_database_name',

    'database_user' => 'My_database_user',

    'database_password' => 'My_database_password',

    'database_prefix' => 'My_database_prefix',

 

And remenber to make a file backup before change it and clear the cache before first loging.

 

Regards

César

 

Link to comment
Share on other sites

I have another question,

I use a share hosting and have installed the shopping cart on one domain.

I copied all the files on another directory to use another domain name.  For some reasons it does not work.   I am using the same database and the same user and password. 

Thanks,

Frederic

Link to comment
Share on other sites

  • 1 month later...
On 5/17/2019 at 12:53 PM, César F. said:

Hello,

To avoid problems, before changing parameters.php, clear the cache from the frontoffice (advanced parameters-performance). 

After changing parameters.php file, you have to clear cache manually by deleting all the folder into var/cache (prod & dev folders).

Regards

Thank you!

Link to comment
Share on other sites

  • 1 month later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...