{"id":2061,"date":"2022-07-26T03:47:27","date_gmt":"2022-07-26T03:47:27","guid":{"rendered":"https:\/\/blog.hostinger.io\/pt\/support\/2022\/07\/26\/4605619-como-alterar-o-fuso-horario-do-banco-de-dados-no-phpmyadmin-hostinger\/"},"modified":"2025-08-27T06:26:23","modified_gmt":"2025-08-27T06:26:23","slug":"4605619-como-alterar-o-fuso-horario-do-banco-de-dados-no-phpmyadmin-hostinger","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/br\/support\/4605619-como-alterar-o-fuso-horario-do-banco-de-dados-no-phpmyadmin-hostinger\/","title":{"rendered":"Como Alterar o Fuso Hor\u00e1rio do Banco de Dados no phpMyAdmin Hostinger"},"content":{"rendered":"<p class=\"no-margin\">Voc&ecirc; pode definir facilmente o fuso hor&aacute;rio de sua <b>sess&atilde;o de banco de dados<\/b> usando um comando SQL no phpMyAdmin. Basta abrir seu banco de dados usando o phpMyAdmin e ir para a se&ccedil;&atilde;o <b>SQL<\/b> :<\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/br\/support\/wp-content\/uploads\/sites\/59\/2022\/07\/68e7804d-e42f-4c29-8059-92f6fe140f69.jpg\"><\/div><p class=\"no-margin\">Uma vez l&aacute;, insira o seguinte comando:<\/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\">Substituindo <b>+hh<\/b> pelo fuso hor&aacute;rio UTC. Por exemplo, UTC-03:00 seria:<\/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\">Em seguida, clique no bot&atilde;o <b>Executar<\/b> para aplicar as altera&ccedil;&otilde;es.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">&Eacute; isso! Voc&ecirc; alterou com sucesso o fuso hor&aacute;rio da <b>sess&atilde;o MySQL atual<\/b> em seu banco de dados.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\"><b>OBSERVA&Ccedil;&Otilde;ES<\/b>:<\/p><ul>\n<li>\n<p class=\"no-margin\">Ap&oacute;s o <b>t&eacute;rmino da sess&atilde;o atual,<\/b> o fuso hor&aacute;rio ser&aacute; alterado para o <b>padr&atilde;o <\/b>(UTC+00:00).<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\">Se voc&ecirc; precisar alterar permanentemente o <b>fuso hor&aacute;rio do servidor global<\/b> , considere um <b><a href=\"https:\/\/www.hostinger.com.br\/servidor-vps\" target=\"_blank\" class=\"intercom-content-link\">plano VPS<\/a><\/b><\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Alterando o fuso hor\u00e1rio de um banco de dados via phpMyAdmin no 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":[217],"tags":[],"class_list":["post-2061","post","type-post","status-publish","format-standard","hentry","category-avancado"],"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\/br\/support\/wp-json\/wp\/v2\/posts\/2061","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/br\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/br\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/br\/support\/wp-json\/wp\/v2\/users\/581"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/br\/support\/wp-json\/wp\/v2\/comments?post=2061"}],"version-history":[{"count":1,"href":"https:\/\/www.hostinger.com\/br\/support\/wp-json\/wp\/v2\/posts\/2061\/revisions"}],"predecessor-version":[{"id":4801,"href":"https:\/\/www.hostinger.com\/br\/support\/wp-json\/wp\/v2\/posts\/2061\/revisions\/4801"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/br\/support\/wp-json\/wp\/v2\/media?parent=2061"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/br\/support\/wp-json\/wp\/v2\/categories?post=2061"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/br\/support\/wp-json\/wp\/v2\/tags?post=2061"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}