{"id":2099,"date":"2022-06-11T23:30:50","date_gmt":"2022-06-11T23:30:50","guid":{"rendered":"https:\/\/blog.hostinger.io\/fr\/support\/2022\/06\/11\/4605619-comment-changer-le-fuseau-horaire-de-la-base-de-donnees-sur-phpmyadmin\/"},"modified":"2025-08-26T21:35:49","modified_gmt":"2025-08-26T21:35:49","slug":"4605619-comment-changer-le-fuseau-horaire-de-la-base-de-donnees-sur-phpmyadmin","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/fr\/support\/4605619-comment-changer-le-fuseau-horaire-de-la-base-de-donnees-sur-phpmyadmin\/","title":{"rendered":"Comment Changer Le Fuseau Horaire de la Base de Donn\u00e9es sur phpMyAdmin"},"content":{"rendered":"<p class=\"no-margin\">Vous pouvez facilement d&eacute;finir le fuseau horaire de votre <b>session de base de donn&eacute;es<\/b> en utilisant une commande SQL dans phpMyAdmin. Ouvrez simplement <b><a href=\"\/fr\/support\/1583545\" target=\"_blank\" class=\"intercom-content-link\">votre base de donn&eacute;es &agrave; l&rsquo;aide de phpMyAdmin<\/a><\/b> et acc&eacute;dez &agrave; la section <b>SQL<\/b> :<\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container\"><img decoding=\"async\" src=\"\/fr\/support\/wp-content\/uploads\/sites\/56\/2022\/06\/72ee7b97-5610-4231-b7b7-b3d446fb1885.jpg\"><\/div><p class=\"no-margin\">Une fois l&agrave;, ins&eacute;rez la commande suivante :<\/p><p class=\"no-margin\">\n<\/p><pre><code>SET time_zone = '+hh:00';<\/code><\/pre><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Remplacer <b>+hh<\/b> par le fuseau horaire UTC. Par exemple, UTC-03:00 serait :<\/p><p class=\"no-margin\">\n<\/p><pre><code>SET time_zone = '-03:00';<\/code><\/pre><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Ensuite, cliquez sur le bouton <b>Go<\/b> pour appliquer les modifications :<\/p><div class=\"intercom-container\"><img decoding=\"async\" src=\"\/fr\/support\/wp-content\/uploads\/sites\/56\/2022\/06\/51ab9d29-e655-431e-bec8-50078b3855d0.jpg\"><\/div><p class=\"no-margin\">Ensuite, il suffit de cliquer sur le bouton &ldquo;<b>Go<\/b>&rdquo; et le tour est jou&eacute;, vous avez r&eacute;ussi &agrave; modifier le fuseau horaire de votre base de donn&eacute;es.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">C&rsquo;est &ccedil;a! Vous avez r&eacute;ussi &agrave; modifier le fuseau horaire de la <b>session MySQL en cours<\/b> sur votre base de donn&eacute;es.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\"><b>REMARQUES<\/b> :<\/p><ul>\n<li>\n<p class=\"no-margin\">Apr&egrave;s la <b>fin de la session en cours,<\/b> le fuseau horaire sera remplac&eacute; par <b>celui par d&eacute;faut <\/b>(UTC+00:00). Alternativement, vous pouvez utiliser la fonction <b><a href=\"\/fr\/support\/1583192-comment-puis-je-modifier-le-parametre-de-fuseau-horaire-de-php-pour-mon-site-web\" target=\"_blank\" class=\"intercom-content-link\">PHP date_default_timezone<\/a> <\/b>pour d&eacute;finir le fuseau horaire de votre site Web<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\">Si vous avez besoin de changer d&eacute;finitivement <b>le fuseau horaire de votre serveur global<\/b>, vous pouvez envisager un <b><a href=\"https:\/\/www.hostinger.fr\/vps\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">plan VPS<\/a><\/b><\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Changer le fuseau horaire d&rsquo;une base de donn\u00e9es via phpMyAdmin sur Hostinger<\/p>\n","protected":false},"author":581,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"include_on_kodee":true,"footnotes":""},"categories":[215],"tags":[],"class_list":["post-2099","post","type-post","status-publish","format-standard","hentry","category-avancee"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/support\/4605619-how-to-change-the-database-timezone-on-phpmyadmin-at-hostinger\/","default":1},{"locale":"es-ES","link":"https:\/\/www.hostinger.com\/es\/support\/4605619-como-cambiar-la-zona-horaria-de-la-base-de-datos-en-phpmyadmin-en-hostinger\/","default":0},{"locale":"fr-FR","link":"https:\/\/www.hostinger.com\/fr\/support\/4605619-comment-changer-le-fuseau-horaire-de-la-base-de-donnees-sur-phpmyadmin\/","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/support\/4605619-bagaimana-cara-mengubah-zona-waktu-database-di-phpmyadmin-di-hostinger\/","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/br\/support\/4605619-como-alterar-o-fuso-horario-do-banco-de-dados-no-phpmyadmin-hostinger\/","default":0},{"locale":"uk-UA","link":"https:\/\/www.hostinger.com\/ua\/support\/4605619--------phpmy\/","default":0}],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/posts\/2099","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/users\/581"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/comments?post=2099"}],"version-history":[{"count":1,"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/posts\/2099\/revisions"}],"predecessor-version":[{"id":4190,"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/posts\/2099\/revisions\/4190"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/media?parent=2099"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/categories?post=2099"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/tags?post=2099"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}