Jump to content
rampa

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

Share this post


Link to post
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 2
  • Thanks 5

Share this post


Link to post
Share on other sites
/app/config/parameters.php

Sorry for my English,

 

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
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 2
  • Thanks 4

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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 2

Share this post


Link to post
Share on other sites

Hello,

 

Only delete these folders:

var/cache/prod

var/cache/dev

 

  • Like 1

Share this post


Link to post
Share on other sites
Posted (edited)

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 by schvarzy (see edit history)

Share this post


Link to post
Share on other sites

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

 

Share this post


Link to post
Share on other sites

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 :)

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

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

 

Share this post


Link to post
Share on other sites
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!

Share this post


Link to post
Share on other sites

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...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More