{"id":1381,"date":"2020-01-06T02:45:14","date_gmt":"2020-01-06T02:45:14","guid":{"rendered":"https:\/\/www.jetorbit.com\/panduan\/?p=1381"},"modified":"2022-04-17T00:53:09","modified_gmt":"2022-04-16T17:53:09","slug":"cara-mengakses-dan-menggunakan-remote-mysql-di-cpanel","status":"publish","type":"post","link":"https:\/\/www.jetorbit.com\/panduan\/cara-mengakses-dan-menggunakan-remote-mysql-di-cpanel\/","title":{"rendered":"Cara Mengakses dan Menggunakan Remote Mysql di Cpanel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_81 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Daftar Isi Artikel<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.jetorbit.com\/panduan\/cara-mengakses-dan-menggunakan-remote-mysql-di-cpanel\/#1_Install_software_mysql_client\" >1. Install software mysql client<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.jetorbit.com\/panduan\/cara-mengakses-dan-menggunakan-remote-mysql-di-cpanel\/#2_Konfigurasi_Allow_Host_Remote_Mysql\" >2. Konfigurasi Allow Host Remote Mysql<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.jetorbit.com\/panduan\/cara-mengakses-dan-menggunakan-remote-mysql-di-cpanel\/#3_Remote_Mysql_Melalui_Tunneling_SSH\" >3. Remote Mysql Melalui Tunneling SSH<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.jetorbit.com\/panduan\/cara-mengakses-dan-menggunakan-remote-mysql-di-cpanel\/#3_Whitelist_IP_Internet_Anda\" >3. Whitelist IP Internet Anda<\/a><\/li><\/ul><\/nav><\/div>\n\n<p>Tutorial ini bertujuan untuk mengetahui bagaiman<strong>a cara mengakses remote mysql<\/strong> di cpanel Jetorbit. Berikut langkah langkah untuk mengakses mysql secara remote.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_Install_software_mysql_client\"><\/span>1. Install software mysql client<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Anda perlu lakukan installasi mysql client pada laptop\/PC anda.<\/p>\n\n\n\n<p>Jika anda menggunakan Windows bisa menggunakan HeidiSQL (free) untuk terhubung ke mysql hosting<\/p>\n\n\n\n<p><a href=\"https:\/\/www.heidisql.com\/download.php?download=installer\" target=\"_blank\" rel=\"noopener\">Download HeidiSQL<\/a><\/p>\n\n\n\n<p>untuk pengguna Mac OS, bisa menggunakan Sequel Pro (free). <a href=\"http:\/\/www.sequelpro.com\/\" target=\"_blank\" rel=\"noopener\">Download Sequel Pro<\/a><\/p>\n\n\n\n<p>Setelah mendownload aplikasi mysql client, lakukan installasi sesuai prosedur yang ada.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_Konfigurasi_Allow_Host_Remote_Mysql\"><\/span>2. Konfigurasi Allow Host Remote Mysql<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ol class=\"wp-block-list\"><li>Masuk ke cpanel anda. (baca : <a href=\"https:\/\/www.jetorbit.com\/panduan\/cara-login-ke-cpanel\/\">Cara masuk ke cpanel<\/a>)<\/li><li>Klik menu Remote Mysql<br><img fetchpriority=\"high\" decoding=\"async\" width=\"1035\" height=\"123\" class=\"size-full wp-image-1386 aligncenter\" src=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/01\/menu-remote-mysql-hosting-jetorbit.png\" alt=\"menu remote mysql hosting jetorbit\" srcset=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/01\/menu-remote-mysql-hosting-jetorbit.png 1035w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/01\/menu-remote-mysql-hosting-jetorbit-300x36.png 300w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/01\/menu-remote-mysql-hosting-jetorbit-1024x122.png 1024w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/01\/menu-remote-mysql-hosting-jetorbit-768x91.png 768w\" sizes=\"(max-width: 1035px) 100vw, 1035px\" \/>Kemudian akan muncul tampilan untuk menambahkan Access Host. Disini anda menambahkan host untuk akses, bisa dalam format IP atau domain.<br>Jika anda terhubung melalui IP dinamis (IP yang kerap berubah ubah) masukkan karakter persentas&nbsp;<strong>% <\/strong>sebagai isian bahwa anda membolehkan semua mengakses mysql.<br><em>(Dalam prakteknya, tidak semua IP bisa masuk melalui remote mysql, hanya IP yang sudah anda whitelist saja yang bisa mengakses. Baca tahap 3)<br><\/em><br><img decoding=\"async\" width=\"427\" height=\"402\" class=\"size-full wp-image-1387 aligncenter\" src=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/01\/access-host-remote-mysql-jetorbit-hosting.png\" alt=\"access host remote mysql jetorbit\" srcset=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/01\/access-host-remote-mysql-jetorbit-hosting.png 427w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/01\/access-host-remote-mysql-jetorbit-hosting-300x282.png 300w\" sizes=\"(max-width: 427px) 100vw, 427px\" \/><\/li><li>Klik&nbsp;<strong>Add Host<\/strong><\/li><\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_Remote_Mysql_Melalui_Tunneling_SSH\"><\/span>3. Remote Mysql Melalui Tunneling SSH<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Langkah selanjutnya, anda bisa melakukan koneksi remote mysql menggunakan SSH Tunneling dengan panduan berikut ini : <a href=\"https:\/\/www.jetorbit.com\/panduan\/cara-koneksi-remote-mysql-melalui-tunneling-ssh\/\">Cara Koneksi Remote Mysql Melalui Tunneling SSH<\/a><\/p>\n\n\n\n<h3 class=\"has-cyan-bluish-gray-color has-text-color wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_Whitelist_IP_Internet_Anda\"><\/span>3. W<s>hitelist IP Internet Anda<\/s><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ol class=\"has-cyan-bluish-gray-color has-text-color wp-block-list\"><li><s>Cek IP Anda di\u00a0<a href=\"https:\/\/ipku.in\/\" target=\"_blank\" rel=\"noopener\">https:\/\/ipku.in<\/a><br>Akan muncul tampilan seperti dibawah ini. Catat atau copy angka IP tersebut.<br><\/s><\/li><li><s>Login ke client area\u00a0https:\/\/client.jetorbit.com\/clientarea.php<\/s><\/li><li><s>Setelah login, masuk ke\u00a0<strong>Services\/Layanan <\/strong>(di menu bagian kiri)<strong> -> <\/strong>klik\u00a0<strong>Manage\u00a0<\/strong>di hosting anda<strong><br><\/strong><\/s><\/li><li><s>Klik tab\u00a0<strong>Manage Firewall.\u00a0<\/strong>Lalu pilih\u00a0<strong>Temporary Allow IP<\/strong><\/s><\/li><li><s>Selanjutnya masukkan IP anda yang telah anda copy kan di tahap 1. Masukan beserta alasannya. Dan kemudian klik\u00a0<strong>Add Temporarry Allow<\/strong><\/s><\/li><li><s>IP internet anda akan di whitelist dalam 7 hari kedepan.<\/s><\/li><\/ol>\n\n\n\n<p>Catatan<br>Jika anda mengalamai gagal login lagi dengan remote mysql, beriksa kembali IP anda di <a href=\"http:\/\/ipku.in\" target=\"_blank\" rel=\"noopener\">ipku.in<\/a> Jika IP anda berubah, lakukan whitelist kembali sesuai cara diatas.<\/p>\n\n\n\n<p>Sekian tutorial untuk remote mysql di cpanel. Cara ini berlaku untuk anda yang menggunakan internet dengan IP dinamis (berubah ubah). Jika anda menggunakan layanan internet dengan IP statik, silahkan hubungi kami untuk kami whitelist secara permanen.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tutorial ini bertujuan untuk mengetahui bagaimana cara mengakses remote mysql di cpanel Jetorbit. Berikut langkah langkah untuk mengakses mysql secara remote. 1. Install software mysql client Anda perlu lakukan installasi mysql client pada laptop\/PC anda. Jika anda menggunakan Windows bisa menggunakan HeidiSQL (free) untuk terhubung ke mysql hosting Download HeidiSQL untuk pengguna Mac OS, bisa [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":7409,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[169,168],"class_list":["post-1381","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-hosting","tag-cara-mengakses-remote-mysql","tag-cara-remote-mysql"],"_links":{"self":[{"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/posts\/1381","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/comments?post=1381"}],"version-history":[{"count":3,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/posts\/1381\/revisions"}],"predecessor-version":[{"id":8026,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/posts\/1381\/revisions\/8026"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/media\/7409"}],"wp:attachment":[{"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/media?parent=1381"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/categories?post=1381"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/tags?post=1381"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}