{"id":484,"date":"2017-07-04T15:56:58","date_gmt":"2017-07-04T12:56:58","guid":{"rendered":"http:\/\/presta.site\/blog\/?p=484"},"modified":"2022-01-19T15:26:24","modified_gmt":"2022-01-19T12:26:24","slug":"how-to-change-database-connection-settings-in-prestashop","status":"publish","type":"post","link":"https:\/\/presta.site\/blog\/en\/how-to-change-database-connection-settings-in-prestashop\/","title":{"rendered":"How to change database connection settings in PrestaShop"},"content":{"rendered":"

Most frequently you may need to change database settings after moving to new hosting.
\nHere is how you can do that:<\/p>\n


\nBe careful with these settings. Incorrect config will break your site.<\/strong><\/p>\n

PrestaShop 1.7<\/h2>\n
    \n
  1. Using your FTP client or file manager navigate to your PrestaShop root<\/b> and open this file: \/app\/config\/parameters.php<\/strong><\/li>\n
  2. Find the lines with database_host<\/strong>, database_name<\/strong>, database_user<\/strong> and database_password<\/strong> parameters.\n<\/li>\n
  3. Replace existing values of those params by the new ones.<\/li>\n
  4. Save the file and upload it back to the server.<\/li>\n

    All done! Open your site in the browser and check whether it works.\n<\/ol>\n

    IMPORTANT:<\/b> sometimes you might need to manually clear the site cache to apply the settings. Delete all content<\/b> of folder «\/var\/cache\/» under the site root. You can do it by using your hosting file manager or by FTP. «\/var\/cache\/» contains folders «dev», «prod» and similar. Be careful not to delete something else.<\/b><\/p>\n

    Here is an example config:<\/p>\n

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    <\/div><\/td>
    <?php<\/span> return<\/span> array<\/span><\/a> (<\/span>
    \n  'parameters'<\/span> =><\/span>
    \n      array<\/span><\/a> (<\/span>
    \n    'database_host'<\/span> =><\/span> '127.0.0.1'<\/span>,<\/span>
    \n    'database_port'<\/span> =><\/span> ''<\/span>,<\/span>
    \n    'database_name'<\/span> =><\/span> 'your_database_name'<\/span>,<\/span>
    \n    'database_user'<\/span> =><\/span> 'your_database_user'<\/span>,<\/span>
    \n    'database_password'<\/span> =><\/span> 'your_database_password'<\/span>,<\/span>
    \n    'database_prefix'<\/span> =><\/span> 'ps_'<\/span>,<\/span>
    \n    'database_engine'<\/span> =><\/span> 'InnoDB'<\/span>,<\/span>
    \n    'mailer_transport'<\/span> =><\/span> 'smtp'<\/span>,<\/span>
    \n    'mailer_host'<\/span> =><\/span> '127.0.0.1'<\/span>,<\/span>
    \n    'mailer_user'<\/span> =><\/span> NULL<\/span>,<\/span>
    \n    'mailer_password'<\/span> =><\/span> NULL<\/span>,<\/span>
    \n    'secret'<\/span> =><\/span> 'Vz6rVXVYNWYt7E6Fvfvdfvg34MCdc97h3IttReewVIxNOu7wHAoS'<\/span>,<\/span>
    \n    'ps_caching'<\/span> =><\/span> 'CacheMemcache'<\/span>,<\/span>
    \n    'ps_cache_enable'<\/span> =><\/span> false<\/span>,<\/span>
    \n    'ps_creation_date'<\/span> =><\/span> '2017-05-22'<\/span>,<\/span>
    \n    'locale'<\/span> =><\/span> 'en-US'<\/span>,<\/span>
    \n    'cookie_key'<\/span> =><\/span> 'xduROM3yvjDSym43CvfdvFDVD47YG8zCrVruNFjjZ3NUb7Ut9'<\/span>,<\/span>
    \n    'cookie_iv'<\/span> =><\/span> '7kBvdfvgh'<\/span>,<\/span>
    \n    'new_cookie_key'<\/span> =><\/span> 'def00000766ffa61aae49b279evfsdvsdfvsfdvfdvwerr324r3frdfveb1afedc8702a964f0a1f6828bf1623ca54efad10ed4bbfb289beec62b01a3062d4c3ce78254157'<\/span>,<\/span>
    \n  )<\/span>,<\/span>
    \n)<\/span>;<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

    PrestaShop 1.5 — 1.6<\/h2>\n
      \n
    1. Using your FTP client or file manager open this file: \/config\/settings.inc.php<\/strong><\/li>\n
    2. Find the lines with _DB_SERVER_<\/strong>, _DB_NAME_<\/strong>, _DB_USER_<\/strong> and _DB_PASSWD_<\/strong> parameters.\n<\/li>\n
    3. Replace existing values of that params with the new ones.<\/li>\n
    4. Save the file and upload it back to the server.<\/li>\n

      All done! Open your site in the browser and check whether it works.\n<\/ol>\n

      Here is an example config:<\/p>\n

      1
      2
      3
      4
      5
      6
      7
      8
      9
      10
      11
      12
      13
      14
      15
      16
      <\/div><\/td>
      <?php<\/span>
      \ndefine<\/span><\/a>(<\/span>'_DB_SERVER_'<\/span>,<\/span> 'localhost'<\/span>)<\/span>;<\/span>
      \n      define<\/span><\/a>(<\/span>'_DB_NAME_'<\/span>,<\/span> 'your_database_name'<\/span>)<\/span>;<\/span>
      \n      define<\/span><\/a>(<\/span>'_DB_USER_'<\/span>,<\/span> 'your_database_user'<\/span>)<\/span>;<\/span>
      \n      define<\/span><\/a>(<\/span>'_DB_PASSWD_'<\/span>,<\/span> 'your_database_password'<\/span>)<\/span>;<\/span>
      \n      define<\/span><\/a>(<\/span>'_DB_PREFIX_'<\/span>,<\/span> 'ps_'<\/span>)<\/span>;<\/span>
      \n      define<\/span><\/a>(<\/span>'_MYSQL_ENGINE_'<\/span>,<\/span> 'InnoDB'<\/span>)<\/span>;<\/span>
      \n      define<\/span><\/a>(<\/span>'_PS_CACHING_SYSTEM_'<\/span>,<\/span> 'CacheApc'<\/span>)<\/span>;<\/span>
      \n      define<\/span><\/a>(<\/span>'_PS_CACHE_ENABLED_'<\/span>,<\/span> '0'<\/span>)<\/span>;<\/span>
      \n      define<\/span><\/a>(<\/span>'_COOKIE_KEY_'<\/span>,<\/span> 'VydXpBBvqfdVyGyVY44qVfFTvL23AG1szj0Avsd271PtuNw5CbORvvOIs'<\/span>)<\/span>;<\/span>
      \n      define<\/span><\/a>(<\/span>'_COOKIE_IV_'<\/span>,<\/span> 'PIx53ASw'<\/span>)<\/span>;<\/span>
      \n      define<\/span><\/a>(<\/span>'_PS_CREATION_DATE_'<\/span>,<\/span> '2017-05-07'<\/span>)<\/span>;<\/span>
      \n      define<\/span><\/a>(<\/span>'_PS_VERSION_'<\/span>,<\/span> '1.6.1.14'<\/span>)<\/span>;<\/span>
      \n      define<\/span><\/a>(<\/span>'_RIJNDAEL_KEY_'<\/span>,<\/span> '4H8PRpv43fsdDSuZXUx9iLiiwRb2af5'<\/span>)<\/span>;<\/span>
      \n      define<\/span><\/a>(<\/span>'_RIJNDAEL_IV_'<\/span>,<\/span> '8Xav8t+xvdft54D+k\/KI1g=='<\/span>)<\/span>;<\/span>
      \n      define<\/span><\/a>(<\/span>'_PS_DIRECTORY_'<\/span>,<\/span> '\/..\/..\/'<\/span>)<\/span>;<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n","protected":false},"excerpt":{"rendered":"

      Most frequently you may need to change database settings after moving to new hosting. Here is how you can do that:<\/p>\n","protected":false},"author":1,"featured_media":496,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/posts\/484"}],"collection":[{"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/comments?post=484"}],"version-history":[{"count":22,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/posts\/484\/revisions"}],"predecessor-version":[{"id":621,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/posts\/484\/revisions\/621"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/media\/496"}],"wp:attachment":[{"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/media?parent=484"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/categories?post=484"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/tags?post=484"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}