{"id":907,"date":"2026-06-29T16:26:01","date_gmt":"2026-06-29T13:26:01","guid":{"rendered":"https:\/\/presta.site\/blog\/?p=907"},"modified":"2026-06-29T16:26:01","modified_gmt":"2026-06-29T13:26:01","slug":"comment-modifier-les-parametres-de-connexion-a-la-base-de-donnees-dans-prestashop","status":"publish","type":"post","link":"https:\/\/presta.site\/blog\/fr\/comment-modifier-les-parametres-de-connexion-a-la-base-de-donnees-dans-prestashop\/","title":{"rendered":"Comment modifier les param\u00e8tres de connexion \u00e0 la base de donn\u00e9es dans PrestaShop"},"content":{"rendered":"<p>Le plus souvent, vous pouvez avoir besoin de modifier les param\u00e8tres de la base de donn\u00e9es apr\u00e8s un changement d&#8217;h\u00e9bergement.<br \/>\nVoici comment vous pouvez faire cela :<\/p>\n<p><!--more--><br \/>\n<strong>Soyez prudent avec ces param\u00e8tres. Une configuration incorrecte cassera votre site.<\/strong><\/p>\n<h2>PrestaShop 1.7<\/h2>\n<ol>\n<li>\u00c0 l&#8217;aide de votre client FTP ou gestionnaire de fichiers, naviguez jusqu&#8217;\u00e0 la <b>racine de PrestaShop<\/b> et ouvrez ce fichier : <strong>\/app\/config\/parameters.php<\/strong><\/li>\n<li>Trouvez les lignes avec les param\u00e8tres <strong>database_host<\/strong>, <strong>database_name<\/strong>, <strong>database_user<\/strong> et <strong>database_password<\/strong>.\n<\/li>\n<li>Remplacez les valeurs existantes de ces param\u00e8tres par les nouvelles.<\/li>\n<li>Enregistrez le fichier et t\u00e9l\u00e9versez-le \u00e0 nouveau sur le serveur.<\/li>\n<p>Tout est fait ! Ouvrez votre site dans le navigateur et v\u00e9rifiez s&#8217;il fonctionne.\n<\/ol>\n<p><b>IMPORTANT :<\/b> il se peut parfois que vous deviez vider manuellement le cache du site pour appliquer les param\u00e8tres. Supprimez tout le <b>contenu<\/b> du dossier &#8220;\/var\/cache\/&#8221; situ\u00e9 \u00e0 la racine du site. Vous pouvez le faire en utilisant le gestionnaire de fichiers de votre h\u00e9bergement ou par FTP. &#8220;\/var\/cache\/&#8221; contient les dossiers &#8220;dev&#8221;, &#8220;prod&#8221; et similaires. <b>Faites attention de ne rien supprimer d&#8217;autre.<\/b><\/p>\n<p>Voici un exemple de configuration :<\/p>\n<div class=\"codecolorer-container php blackboard\" style=\"overflow:auto;white-space:nowrap;\"><table cellspacing=\"0\" cellpadding=\"0\"><tbody><tr><td class=\"line-numbers\"><div>1<br \/>2<br \/>3<br \/>4<br \/>5<br \/>6<br \/>7<br \/>8<br \/>9<br \/>10<br \/>11<br \/>12<br \/>13<br \/>14<br \/>15<br \/>16<br \/>17<br \/>18<br \/>19<br \/>20<br \/>21<br \/>22<br \/>23<br \/>24<br \/><\/div><\/td><td><div class=\"php codecolorer\"><span class=\"kw2\">&lt;?php<\/span> <span class=\"kw1\">return<\/span> <a href=\"http:\/\/www.php.net\/array\"><span class=\"kw3\">array<\/span><\/a> <span class=\"br0\">&#40;<\/span><br \/>\n&nbsp; <span class=\"st_h\">'parameters'<\/span> <span class=\"sy0\">=&gt;<\/span> <br \/>\n&nbsp; <a href=\"http:\/\/www.php.net\/array\"><span class=\"kw3\">array<\/span><\/a> <span class=\"br0\">&#40;<\/span><br \/>\n&nbsp; &nbsp; <span class=\"st_h\">'database_host'<\/span> <span class=\"sy0\">=&gt;<\/span> <span class=\"st_h\">'127.0.0.1'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp; &nbsp; <span class=\"st_h\">'database_port'<\/span> <span class=\"sy0\">=&gt;<\/span> <span class=\"st_h\">''<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp; &nbsp; <span class=\"st_h\">'database_name'<\/span> <span class=\"sy0\">=&gt;<\/span> <span class=\"st_h\">'your_database_name'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp; &nbsp; <span class=\"st_h\">'database_user'<\/span> <span class=\"sy0\">=&gt;<\/span> <span class=\"st_h\">'your_database_user'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp; &nbsp; <span class=\"st_h\">'database_password'<\/span> <span class=\"sy0\">=&gt;<\/span> <span class=\"st_h\">'your_database_password'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp; &nbsp; <span class=\"st_h\">'database_prefix'<\/span> <span class=\"sy0\">=&gt;<\/span> <span class=\"st_h\">'ps_'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp; &nbsp; <span class=\"st_h\">'database_engine'<\/span> <span class=\"sy0\">=&gt;<\/span> <span class=\"st_h\">'InnoDB'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp; &nbsp; <span class=\"st_h\">'mailer_transport'<\/span> <span class=\"sy0\">=&gt;<\/span> <span class=\"st_h\">'smtp'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp; &nbsp; <span class=\"st_h\">'mailer_host'<\/span> <span class=\"sy0\">=&gt;<\/span> <span class=\"st_h\">'127.0.0.1'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp; &nbsp; <span class=\"st_h\">'mailer_user'<\/span> <span class=\"sy0\">=&gt;<\/span> <span class=\"kw4\">NULL<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp; &nbsp; <span class=\"st_h\">'mailer_password'<\/span> <span class=\"sy0\">=&gt;<\/span> <span class=\"kw4\">NULL<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp; &nbsp; <span class=\"st_h\">'secret'<\/span> <span class=\"sy0\">=&gt;<\/span> <span class=\"st_h\">'Vz6rVXVYNWYt7E6Fvfvdfvg34MCdc97h3IttReewVIxNOu7wHAoS'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp; &nbsp; <span class=\"st_h\">'ps_caching'<\/span> <span class=\"sy0\">=&gt;<\/span> <span class=\"st_h\">'CacheMemcache'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp; &nbsp; <span class=\"st_h\">'ps_cache_enable'<\/span> <span class=\"sy0\">=&gt;<\/span> <span class=\"kw4\">false<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp; &nbsp; <span class=\"st_h\">'ps_creation_date'<\/span> <span class=\"sy0\">=&gt;<\/span> <span class=\"st_h\">'2017-05-22'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp; &nbsp; <span class=\"st_h\">'locale'<\/span> <span class=\"sy0\">=&gt;<\/span> <span class=\"st_h\">'en-US'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp; &nbsp; <span class=\"st_h\">'cookie_key'<\/span> <span class=\"sy0\">=&gt;<\/span> <span class=\"st_h\">'xduROM3yvjDSym43CvfdvFDVD47YG8zCrVruNFjjZ3NUb7Ut9'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp; &nbsp; <span class=\"st_h\">'cookie_iv'<\/span> <span class=\"sy0\">=&gt;<\/span> <span class=\"st_h\">'7kBvdfvgh'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp; &nbsp; <span class=\"st_h\">'new_cookie_key'<\/span> <span class=\"sy0\">=&gt;<\/span> <span class=\"st_h\">'def00000766ffa61aae49b279evfsdvsdfvsfdvfdvwerr324r3frdfveb1afedc8702a964f0a1f6828bf1623ca54efad10ed4bbfb289beec62b01a3062d4c3ce78254157'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp; <span class=\"br0\">&#41;<\/span><span class=\"sy0\">,<\/span><br \/>\n<span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n<h2>PrestaShop 1.5 &#8211; 1.6<\/h2>\n<ol>\n<li>\u00c0 l&#8217;aide de votre client FTP ou gestionnaire de fichiers, ouvrez ce fichier : <strong>\/config\/settings.inc.php<\/strong><\/li>\n<li>Trouvez les lignes avec les param\u00e8tres <strong>_DB_SERVER_<\/strong>, <strong>_DB_NAME_<\/strong>, <strong>_DB_USER_<\/strong> et <strong>_DB_PASSWD_<\/strong>.\n<\/li>\n<li>Remplacez les valeurs existantes de ces param\u00e8tres par les nouvelles.<\/li>\n<li>Enregistrez le fichier et t\u00e9l\u00e9versez-le \u00e0 nouveau sur le serveur.<\/li>\n<p>Tout est fait ! Ouvrez votre site dans le navigateur et v\u00e9rifiez s&#8217;il fonctionne.\n<\/ol>\n<p>Voici un exemple de configuration :<\/p>\n<div class=\"codecolorer-container php blackboard\" style=\"overflow:auto;white-space:nowrap;\"><table cellspacing=\"0\" cellpadding=\"0\"><tbody><tr><td class=\"line-numbers\"><div>1<br \/>2<br \/>3<br \/>4<br \/>5<br \/>6<br \/>7<br \/>8<br \/>9<br \/>10<br \/>11<br \/>12<br \/>13<br \/>14<br \/>15<br \/>16<br \/><\/div><\/td><td><div class=\"php codecolorer\"><span class=\"kw2\">&lt;?php<\/span><br \/>\n<a href=\"http:\/\/www.php.net\/define\"><span class=\"kw3\">define<\/span><\/a><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'_DB_SERVER_'<\/span><span class=\"sy0\">,<\/span> <span class=\"st_h\">'localhost'<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\n<a href=\"http:\/\/www.php.net\/define\"><span class=\"kw3\">define<\/span><\/a><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'_DB_NAME_'<\/span><span class=\"sy0\">,<\/span> <span class=\"st_h\">'your_database_name'<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\n<a href=\"http:\/\/www.php.net\/define\"><span class=\"kw3\">define<\/span><\/a><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'_DB_USER_'<\/span><span class=\"sy0\">,<\/span> <span class=\"st_h\">'your_database_user'<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\n<a href=\"http:\/\/www.php.net\/define\"><span class=\"kw3\">define<\/span><\/a><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'_DB_PASSWD_'<\/span><span class=\"sy0\">,<\/span> <span class=\"st_h\">'your_database_password'<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\n<a href=\"http:\/\/www.php.net\/define\"><span class=\"kw3\">define<\/span><\/a><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'_DB_PREFIX_'<\/span><span class=\"sy0\">,<\/span> <span class=\"st_h\">'ps_'<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\n<a href=\"http:\/\/www.php.net\/define\"><span class=\"kw3\">define<\/span><\/a><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'_MYSQL_ENGINE_'<\/span><span class=\"sy0\">,<\/span> <span class=\"st_h\">'InnoDB'<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\n<a href=\"http:\/\/www.php.net\/define\"><span class=\"kw3\">define<\/span><\/a><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'_PS_CACHING_SYSTEM_'<\/span><span class=\"sy0\">,<\/span> <span class=\"st_h\">'CacheApc'<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\n<a href=\"http:\/\/www.php.net\/define\"><span class=\"kw3\">define<\/span><\/a><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'_PS_CACHE_ENABLED_'<\/span><span class=\"sy0\">,<\/span> <span class=\"st_h\">'0'<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\n<a href=\"http:\/\/www.php.net\/define\"><span class=\"kw3\">define<\/span><\/a><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'_COOKIE_KEY_'<\/span><span class=\"sy0\">,<\/span> <span class=\"st_h\">'VydXpBBvqfdVyGyVY44qVfFTvL23AG1szj0Avsd271PtuNw5CbORvvOIs'<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\n<a href=\"http:\/\/www.php.net\/define\"><span class=\"kw3\">define<\/span><\/a><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'_COOKIE_IV_'<\/span><span class=\"sy0\">,<\/span> <span class=\"st_h\">'PIx53ASw'<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\n<a href=\"http:\/\/www.php.net\/define\"><span class=\"kw3\">define<\/span><\/a><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'_PS_CREATION_DATE_'<\/span><span class=\"sy0\">,<\/span> <span class=\"st_h\">'2017-05-07'<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\n<a href=\"http:\/\/www.php.net\/define\"><span class=\"kw3\">define<\/span><\/a><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'_PS_VERSION_'<\/span><span class=\"sy0\">,<\/span> <span class=\"st_h\">'1.6.1.14'<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\n<a href=\"http:\/\/www.php.net\/define\"><span class=\"kw3\">define<\/span><\/a><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'_RIJNDAEL_KEY_'<\/span><span class=\"sy0\">,<\/span> <span class=\"st_h\">'4H8PRpv43fsdDSuZXUx9iLiiwRb2af5'<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\n<a href=\"http:\/\/www.php.net\/define\"><span class=\"kw3\">define<\/span><\/a><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'_RIJNDAEL_IV_'<\/span><span class=\"sy0\">,<\/span> <span class=\"st_h\">'8Xav8t+xvdft54D+k\/KI1g=='<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\n<a href=\"http:\/\/www.php.net\/define\"><span class=\"kw3\">define<\/span><\/a><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'_PS_DIRECTORY_'<\/span><span class=\"sy0\">,<\/span> <span class=\"st_h\">'\/..\/..\/'<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Le plus souvent, vous pouvez avoir besoin de modifier les param\u00e8tres de la base de donn\u00e9es apr\u00e8s un changement d&#8217;h\u00e9bergement. Voici comment vous pouvez faire cela :<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[100],"tags":[],"class_list":["post-907","post","type-post","status-publish","format-standard","hentry","category-tutoriels-et-guides"],"_links":{"self":[{"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/posts\/907","targetHints":{"allow":["GET"]}}],"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=907"}],"version-history":[{"count":1,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/posts\/907\/revisions"}],"predecessor-version":[{"id":951,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/posts\/907\/revisions\/951"}],"wp:attachment":[{"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/media?parent=907"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/categories?post=907"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/tags?post=907"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}