{"id":457,"date":"2023-04-14T10:25:56","date_gmt":"2023-04-14T10:25:56","guid":{"rendered":"https:\/\/blog.hostinger.io\/es\/support\/2023\/04\/14\/4605619-como-cambiar-la-zona-horaria-de-la-base-de-datos-en-phpmyadmin-en-hostinger\/"},"modified":"2025-08-26T21:49:50","modified_gmt":"2025-08-26T21:49:50","slug":"4605619-como-cambiar-la-zona-horaria-de-la-base-de-datos-en-phpmyadmin-en-hostinger","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/es\/support\/4605619-como-cambiar-la-zona-horaria-de-la-base-de-datos-en-phpmyadmin-en-hostinger\/","title":{"rendered":"C\u00f3mo Cambiar la Zona Horaria de la Base de Datos en PhpMyAdmin en Hostinger"},"content":{"rendered":"<p class=\"no-margin\">Puedes configurar f&aacute;cilmente la zona horaria de tu <b>sesi&oacute;n de base de datos<\/b> usando un comando SQL en phpMyAdmin. Simplemente <b><a href=\"\/es\/support\/1583545-como-ingresar-a-phpmyadmin-en-hpanel\" target=\"_blank\" class=\"intercom-content-link\">abrt tu base de datos usando phpMyAdmin<\/a><\/b> y ve a la secci&oacute;n <b>SQL<\/b>:<\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/es\/support\/wp-content\/uploads\/sites\/60\/2023\/04\/1d388950-7aa6-4590-849e-f279a7748bf6.jpg\"><\/div><p class=\"no-margin\">Una vez ah&iacute;, inserta el siguiente 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\">Reemplazando <b>+hh<\/b> con la zona horaria UTC. Por ejemplo, UTC-03:00 ser&iacute;a:<\/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\">A continuaci&oacute;n, da clic en el bot&oacute;n <b>Go<\/b> para aplicar los cambios:<\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/es\/support\/wp-content\/uploads\/sites\/60\/2023\/04\/e42b87e4-3d67-4f5a-90c4-5388c9080100.jpg\"><\/div><p class=\"no-margin\">&iexcl;Eso es todo! Has cambiado correctamente la zona horaria de la <b>sesi&oacute;n actual de MySQL<\/b> en tu base de datos.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\"><b>NOTAS<\/b> :<\/p><ul>\n<li>\n<p class=\"no-margin\">Despu&eacute;s de que finalice la <b>sesi&oacute;n actual,<\/b> la zona horaria se cambiar&aacute; a la <b>predeterminada <\/b>(UTC+00:00). Como alternativa, puedes usar la funci&oacute;n <b><a href=\"\/es\/support\/1583192-como-puedo-modificar-la-configuracion-de-zona-horaria-de-php-para-mi-sitio-web\" target=\"_blank\" class=\"intercom-content-link\">PHP date_default_timezone<\/a> <\/b>para configurar la zona horaria de tu sitio web<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\">Si necesitas cambiar permanentemente <b>la zona horaria de todo tu servidor<\/b>, puedes considerar un <b><a href=\"https:\/\/www.hostinger.es\/servidor-vps\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">plan VPS<\/a><\/b><\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Cambiar la zona horaria de una base de datos a trav\u00e9s de phpMyAdmin en 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":[216],"tags":[],"class_list":["post-457","post","type-post","status-publish","format-standard","hentry","category-avanzado"],"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\/es\/support\/wp-json\/wp\/v2\/posts\/457","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/es\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/es\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/es\/support\/wp-json\/wp\/v2\/users\/581"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/es\/support\/wp-json\/wp\/v2\/comments?post=457"}],"version-history":[{"count":1,"href":"https:\/\/www.hostinger.com\/es\/support\/wp-json\/wp\/v2\/posts\/457\/revisions"}],"predecessor-version":[{"id":2548,"href":"https:\/\/www.hostinger.com\/es\/support\/wp-json\/wp\/v2\/posts\/457\/revisions\/2548"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/es\/support\/wp-json\/wp\/v2\/media?parent=457"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/es\/support\/wp-json\/wp\/v2\/categories?post=457"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/es\/support\/wp-json\/wp\/v2\/tags?post=457"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}