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

 

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

  • Thanks 2

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 1

Share this post


Link to post
Share on other sites

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

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