{"id":345,"date":"2021-12-12T13:03:31","date_gmt":"2021-12-12T13:03:31","guid":{"rendered":"https:\/\/blog.hostinger.io\/id\/support\/2021\/12\/12\/4605619-bagaimana-cara-mengubah-zona-waktu-database-di-phpmyadmin-di-hostinger\/"},"modified":"2025-08-26T20:05:47","modified_gmt":"2025-08-26T20:05:47","slug":"4605619-bagaimana-cara-mengubah-zona-waktu-database-di-phpmyadmin-di-hostinger","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/id\/support\/4605619-bagaimana-cara-mengubah-zona-waktu-database-di-phpmyadmin-di-hostinger\/","title":{"rendered":"Bagaimana Cara Mengubah Zona Waktu Database di phpMyAdmin di Hostinger"},"content":{"rendered":"<p class=\"no-margin\"><b>Anda dapat dengan mudah mengatur zona waktu sesi database<\/b> Anda dengan menggunakan perintah SQL di phpMyAdmin. Cukup <b><a href=\"\/id\/support\/1583545-cara-mengakses-phpmyadmin-di-hpanel\" target=\"_blank\" class=\"intercom-content-link\">buka database Anda menggunakan phpMyAdmin<\/a><\/b> dan buka bagian <b>SQL<\/b>:<\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container\"><img decoding=\"async\" src=\"\/id\/support\/wp-content\/uploads\/sites\/57\/2021\/12\/4a85c0f0-5cbc-4e95-83ae-9f3244528f8e.jpg\"><\/div><p class=\"no-margin\">Sesampai di sana, masukkan perintah berikut:<\/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\">Mengganti <b>+hh<\/b> dengan zona waktu UTC. Misalnya, UTC-03:00 akan menjadi:<\/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\">Selanjutnya, klik tombol <b>Go<\/b> untuk menerapkan perubahan:<\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container\"><img decoding=\"async\" src=\"\/id\/support\/wp-content\/uploads\/sites\/57\/2021\/12\/5e5e38bf-235b-4921-bfef-32598c1a6450.jpg\"><\/div><p class=\"no-margin\">Selesai! Kini Anda telah berhasil mengubah zona waktu untuk <b>sesi MySQL saat ini<\/b> database.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\"><b>CATATAN:<\/b><\/p><ul>\n<li>\n<p class=\"no-margin\">Setelah <b>sesi saat ini berakhir,<\/b> zona waktu akan diubah ke <b>default <\/b>(UTC+00:00). Sebagai alternatif, Anda dapat menggunakan fungsi <b><a href=\"\/id\/support\/1583192-bagaimana-cara-memodifikasi-pengaturan-php-timezone-untuk-website-saya\" target=\"_blank\" class=\"intercom-content-link\">PHP date_default_timezone<\/a> <\/b>untuk mengatur zona waktu situs web Anda<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\">Jika Anda perlu mengubah <b>zona waktu server global<\/b> Anda secara permanen , Anda dapat mempertimbangkan <b><a href=\"https:\/\/www.hostinger.co.id\/vps-hosting\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">paket VPS<\/a><\/b><\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Mengubah zona waktu database di phpMyAdmin 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-345","post","type-post","status-publish","format-standard","hentry","category-tingkat-lanjut"],"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\/id\/support\/wp-json\/wp\/v2\/posts\/345","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/users\/581"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/comments?post=345"}],"version-history":[{"count":1,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts\/345\/revisions"}],"predecessor-version":[{"id":2116,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts\/345\/revisions\/2116"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/media?parent=345"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/categories?post=345"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/tags?post=345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}