Database password change [prestashop 1.7]

[rampa]

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 ~_~

[nadie]

  On 4/10/2017 at 9:45 PM, rampa said:

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,

[rampa]

  On 4/10/2017 at 9:57 PM, nadie said:

/app/config/parameters.php

Sorry for my English,

 

Phew! It's there. Thank you very much!

[lanterneled]

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

 

[César F.]

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

[markoroots]

Great Cèsar, many thanks, it work. :)

[David Casatta]

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

[Rainmaker3]

  On 10/31/2019 at 8: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

Expand  

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

[GF moraleda GmbH]

Do I have to delete the whole content of var/cache ? Thanks for advice

[GF moraleda GmbH]

Thanks it worked ... Merci beaucoup

[César F.]

Hello,

 

Only delete these folders:

var/cache/prod

var/cache/dev

 

[GF moraleda GmbH]

Thanks it has worked :))

[schvarzy]

Hello,

One question, when I opened the parameters.php files, I can see that the password is like 'secret' => 'v8xWjQHB3d3wBeHLcO5pYJ5.....

How would you enter the new one there?  The number is scrambled and the one I have is not....

Thanks

Frederic

Edited March 30, 2020 by schvarzy (see edit history)

[César F.]

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

 

[schvarzy]

Thanks Cesar....

I had it in front of my nose but did not see it.....  Getting old I guess...

Merci

Belle journee et restez a la maison

[schvarzy]

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

[schvarzy]

Seems that I have forgotten to upload quite a few files.....  not sure why this happened....  uploading now....  Will keep you posted...

 

[Sasha Chirico]

  On 5/17/2019 at 10:53 AM, 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

Expand  

Thank you!

[luisleitaoaudio]

I have a video explain where is the file i. prestastashop 1.7