{"id":6435,"date":"2019-01-16T14:00:52","date_gmt":"2019-01-16T08:30:52","guid":{"rendered":"https:\/\/www.hiddentechies.com\/blog\/?p=6435"},"modified":"2024-04-09T18:27:02","modified_gmt":"2024-04-09T12:57:02","slug":"database-connection-prestashop","status":"publish","type":"post","link":"https:\/\/www.hiddentechies.com\/blog\/prestashop\/database-connection-prestashop\/","title":{"rendered":"How to Change Database Connection in PrestaShop 1.7?"},"content":{"rendered":"<p>While, you are moving to new domain you may need to change database setting. In this tutorial, I will guide you to change database setting in PrestaShop 1.7.<\/p>\n<div style=\"display: block; float: left; width: 100%; padding: 30px 0; background: black; border-radius: 5px; margin: 0 0 25px 0;\">\n<p style=\"text-align: center;\"><a style=\"color: #fff; font-size: 28px; font-weight: 600;\" href=\"https:\/\/www.hiddentechies.com\/blog\/prestashop\/top-free-prestashop-1-7-5-themes\/\" target=\"_blank\" rel=\"noopener noreferrer\"> Top Free PrestaShop 1.7.5 Themes for 2019 <\/a><\/p>\n<\/div>\n<div style=\"display: block; float: left; width: 100%; border-radius: 5px; margin: 0 0 25px 0;\"><a style=\"color: #fff; font-size: 28px; font-weight: 600;\" href=\"https:\/\/addons.prestashop.com\/en\/analytics-statistics\/92705-google-analytics-google-analytics-4-ga4-integration.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13583\" src=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/11\/google-analytics-prestashop-ga4.gif\" alt=\"\" width=\"780\" height=\"110\" \/><\/a><\/div>\n<p class=\"ht-sub-heading\">Follow the below steps to:<\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Connect to FTP server or file manager and open the file: <strong>\/app\/config\/parameters.php<\/strong><\/li>\n<li>Find the parameters with <strong>database_host, database_name, database_user and database_password<\/strong>.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<pre>          'parameters' =&gt; \r\n          array (\r\n            'database_host' =&gt; '127.0.0.1',\r\n            'database_port' =&gt; '',\r\n            'database_name' =&gt; 'db_name',\r\n            'database_user' =&gt; 'db_user',\r\n            'database_password' =&gt; 'db_password',\r\n            'database_prefix' =&gt; 'ps_',\r\n            'database_engine' =&gt; 'InnoDB',\r\n            'mailer_transport' =&gt; 'smtp',\r\n            'mailer_host' =&gt; '127.0.0.1',\r\n            'mailer_user' =&gt; NULL,\r\n            'mailer_password' =&gt; NULL,\r\n            'secret' =&gt; 'ItZfL8iSIRbCApWhsEPU08DpYRTRfAfo4aYiH7FasdHN0O90y0glXUxk',\r\n            'ps_caching' =&gt; 'CacheMemcache',\r\n            'ps_cache_enable' =&gt; false,\r\n            'ps_creation_date' =&gt; '2018-12-27',\r\n            'locale' =&gt; 'en-US',\r\n            'cookie_key' =&gt; 'NtAb1tHTS0vTDiLhxYPgjbh9z2smq3ui4STNwCWypoA4QcuJK7hjmPrb',\r\n            'cookie_iv' =&gt; '38DiI3T7',\r\n            'new_cookie_key' =&gt; 'def000007db62c115928fe5628596548a3d21b7630b7dafe9e4f9b1c5806e07d5f20f96a6e715d896a3a58cfc7bd3c477329add96cac963712eff4c0261de13669a7a76d',\r\n          ),\r\n\r\n<\/pre>\n<ul>\n<li>Replace existing values of that params with the new ones.<\/li>\n<li><strong>Save<\/strong> the file to apply changes.<\/li>\n<li>Now, Remove all the files inside the folders <strong>cache\/smarty\/compile\/<\/strong> and <strong>cache\/smarty\/cache\/<\/strong>, except the <strong>index.php<\/strong> files.<\/li>\n<li>Log into your PrestaShop back-office on new domain and verify if everything is working properly<\/li>\n<\/ul>\n<p>Hopefully, this tutorial will help you.<\/p>\n<div class=\"angwp_12010 _ning_cont _ning_hidden _ning_outer _align_center responsive\" data-size=\"custom\" data-bid=\"12010\" data-aid=\"0\" style=\"max-width:800px; width:100%;height:inherit;\"><div class=\"_ning_label _left\" style=\"\"><\/div><div class=\"_ning_inner\" style=\"\"><a href=\"https:\/\/www.hiddentechies.com\/blog?_dnlink=12010&t=1779604150\" class=\"strack_cli _ning_link\" target=\"_blank\">&nbsp;<\/a><div class=\"_ning_elmt\"><img decoding=\"async\" src=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/angwp\/items\/12010\/Banner-2.png\" \/><\/div><\/div><\/div><div class=\"clear\"><\/div>","protected":false},"excerpt":{"rendered":"<p>While, you are moving to new domain you may need to change database setting. In this tutorial, I will guide you to change database setting in PrestaShop 1.7. Top Free PrestaShop 1.7.5 Themes for 2019 Follow the below steps to: Connect to FTP server or file manager and open the file: \/app\/config\/parameters.php Find the parameters&#8230; <\/p>\n<div class=\"actions\"><a href=\"https:\/\/www.hiddentechies.com\/blog\/prestashop\/database-connection-prestashop\/\">Continue Reading<\/a><\/div>\n","protected":false},"author":1,"featured_media":6598,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[221,222,2139,2],"tags":[608],"_links":{"self":[{"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/posts\/6435"}],"collection":[{"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/comments?post=6435"}],"version-history":[{"count":14,"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/posts\/6435\/revisions"}],"predecessor-version":[{"id":13598,"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/posts\/6435\/revisions\/13598"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/media\/6598"}],"wp:attachment":[{"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/media?parent=6435"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/categories?post=6435"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/tags?post=6435"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}