{"id":346,"date":"2021-11-12T09:35:15","date_gmt":"2021-11-12T09:35:15","guid":{"rendered":"https:\/\/blog.hostinger.io\/id\/support\/2021\/11\/12\/4602010-bagaimana-cara-setup-akses-remote-mysql-di-cpanel-di-hostinger\/"},"modified":"2025-08-26T20:07:48","modified_gmt":"2025-08-26T20:07:48","slug":"4602010-bagaimana-cara-setup-akses-remote-mysql-di-cpanel-di-hostinger","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/id\/support\/4602010-bagaimana-cara-setup-akses-remote-mysql-di-cpanel-di-hostinger\/","title":{"rendered":"Bagaimana Cara Setup Akses Remote MySQL di cPanel di Hostinger"},"content":{"rendered":"<p class=\"no-margin\">Sebelum membuat sambungan remote ke database, IP yang bekerja melalui sambungan remote harus diizinkan di akun Anda terlebih dulu. Untuk mengizinkan koneksi remote, masuk ke akun <b>cPanel <\/b>dan cari menu <b>Remote MySQL<\/b> yang ada di bagian <b>Databases<\/b>.<\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/id\/support\/wp-content\/uploads\/sites\/57\/2021\/11\/a9a53f57-dbd5-4077-b8b0-5565a915d11d.jpg\"><\/div><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Di halaman yang baru, Anda akan melihat kolom <b>Host (% wildcard is allowed)<\/b>. Isi alamat IP yang akan menjadi asal koneksi remote. Apabila Anda ingin membuat sambungan dari IP mana pun, masukkan simbol %. Anda juga bisa memberi deskripsi singkat mengenai remote host di kolom Comment:<\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/id\/support\/wp-content\/uploads\/sites\/57\/2021\/11\/7b226f19-587c-4fa5-a95e-660802c69d4e.jpg\"><\/div><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Klik <b>Add Host<\/b> dan host baru akan muncul di bagian <b>Manage Access Hosts<\/b>:<\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container\"><img decoding=\"async\" src=\"\/id\/support\/wp-content\/uploads\/sites\/57\/2021\/11\/a13f17ac-ff59-4ec4-97f8-e523b1045ef9.jpg\"><\/div><p class=\"no-margin\"><b>CATATAN<\/b><\/p><ul>\n<li>\n<p class=\"no-margin\">Untuk membuat koneksi remote, Anda juga memerlukan hostname server MySQL. Hostname server ini sama dengan alamat IP.<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\">Setelah koneksi remote MySQL di-setup, hak akses ke <b>semua database Anda<\/b> akan diberikan (diperlukan verifikasi username dan password untuk database tertentu yang dihubungkan).<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\">Sebagian besar server menggunakan <i>load balance<\/i>. Bisa saja request (atau permintaan) datang dari berbagai IP. Oleh karena itu, kami sarankan untuk menggunakan opsi wildcard (%) pada saat menambahkan koneksi remote (diperlukan verifikasi username dan password).<\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Mengaktifkan koneksi remote MySQL di cPanel<\/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":[170],"tags":[],"class_list":["post-346","post","type-post","status-publish","format-standard","hentry","category-mysql"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/support\/4602010-how-to-set-up-remote-mysql-access-on-cpanel-at-hostinger\/","default":1},{"locale":"es-ES","link":"https:\/\/www.hostinger.com\/es\/support\/4602010-como-configurar-un-acceso-remoto-a-mysql-en-cpanel-en-hostinger\/","default":0},{"locale":"fr-FR","link":"https:\/\/www.hostinger.com\/fr\/support\/4602010-comment-configurer-l-acces-distant-a-mysql-sur-cpanel-chez-hostinger\/","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/support\/4602010-bagaimana-cara-setup-akses-remote-mysql-di-cpanel-di-hostinger\/","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/br\/support\/4602010-como-configurar-o-acesso-remoto-ao-mysql-no-cpanel-hostinger\/","default":0}],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts\/346","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=346"}],"version-history":[{"count":1,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts\/346\/revisions"}],"predecessor-version":[{"id":2341,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts\/346\/revisions\/2341"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/media?parent=346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/categories?post=346"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/tags?post=346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}