{"id":17334,"date":"2020-11-24T13:07:46","date_gmt":"2020-11-24T06:07:46","guid":{"rendered":"https:\/\/www.rumahweb.com\/journal\/?p=17334"},"modified":"2023-12-06T14:09:33","modified_gmt":"2023-12-06T07:09:33","slug":"cara-remote-database-mysql-dengan-navicat","status":"publish","type":"post","link":"https:\/\/www.rumahweb.com\/journal\/cara-remote-database-mysql-dengan-navicat\/","title":{"rendered":"Cara Remote Database MySQL dengan Navicat di Rumahweb"},"content":{"rendered":"\n<p>Pada panduan ini, kami akan berbagi cara remote database MySQL dengan aplikasi Navicat. Aplikasi ini dapat anda download melalui website resmi Navicat. <\/p>\n\n\n\n\n\n<p>Sebelum kami menjelaskan tentang cara menggunakan remote database di hosting dengan navicat, terlebih dahulu kami akan menjelaskan secara singkat apa itu aplikasi Navicat. Berikut informasi selengkapnya.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Apa itu Navicat?<\/h2>\n\n\n\n<p><strong>Navicat<\/strong> adalah software untuk mengelola berbagai macam database, salah satunya MySQL dan bisa digunakan untuk remote database mysql secara GUI (Graphic User Interface), dimana kita bisa mengkonfigurasi database secara grafic atau dengan secara instan menginstall dan konfigurasi tanpa harus menggunakan script.<\/p>\n\n\n\n<p>Aplikasi Navicat ini digunakan untuk memanipulasi data MySQL, seperti membuat database, membuat tabel, menghapus tabel, dan navicat bisa di gunakan untuk mengubah tipe data MySQL yang biasanya berakhiran (.sql) ke dalam format file Paradox (*.db), file DBase (*.dbf), file Text (*.txt), file HTML (*.htm;*.html), file Excel (*.xls), file Excel 2007 (*.xlsx), file Lotus 1-2-3(*.wk1), QuattroPro (*.wq1), file XML (*.xml), database MS Access (*.mdb). <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Remote Database dengan Navicat<\/h2>\n\n\n\n<p>Berikut adalah langkah-langkah remote database dengan aplikasi Navicat. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1. Persiapan sistem<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Aplikasi Navicat ini terdapat versi yang bisa di <a href=\"https:\/\/www.navicat.com\/en\/products\">download<\/a> secara gratis dan berbayar\/premium. <\/li>\n\n\n\n<li>Fitur remote database tersedia untuk paket Medium dan Large di layanan Share Hosting. Sedangkan untuk layanan Cloud hosting, semua paket telah support remote database.<\/li>\n\n\n\n<li>Sebelum Anda melakukan remote database, silahkan request whitelist IP terlebih dahulu ke email teknis[at]rumahweb.com, dengan menyertakan nama domain beserta IP public koneksi yang digunakan. <br \/><br \/>Apabila IP public Anda dinamis, kami sarankan agar Anda menggunakan layanan Dynamic IP address (<a href=\"https:\/\/www.rumahweb.com\/journal\/apa-itu-ddns-adalah\/\" title=\"ddns adalah\">DDNS<\/a>) yang bisa didapatkan dari pihak ketiga seperti\u00a0noip.com.<\/li>\n<\/ul>\n\n\n\n<p><strong>BACA JUGA : <a href=\"https:\/\/blog.rumahweb.com\/remote-database-adalah\/#Support_Remote_Database_di_Hosting_Rumahweb\" target=\"_blank\" rel=\"noopener\" title=\"\">Support Remote Database di Hosting Rumahweb<\/a><\/strong><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2. Cara remote database<\/h3>\n\n\n\n<p>Berikut langkah-langkah remote database di hosting dengan Navicat :<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Download dan install aplikasi <a href=\"https:\/\/www.navicat.com\/en\/download\/navicat-for-mysql\">Navicat<\/a> terlebih dahulu.<\/li>\n\n\n\n<li>Login ke <a href=\"https:\/\/www.rumahweb.com\/journal\/login-cpanel-hosting-melalui-clientzone\/\">cPanel hosting<\/a>.<\/li>\n\n\n\n<li>Cari menu <strong>Database<\/strong> lalu pilih <strong>Remote MySQL\u00ae<\/strong>.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"769\" height=\"186\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb1.png\" alt=\"image 1 - Panduan Remote Database MySQL dengan Navicat di Rumahweb\" class=\"wp-image-17340\" style=\"width:534px;height:129px\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb1.png 769w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb1-300x73.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb1-370x89.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb1-270x65.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb1-570x138.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb1-740x179.png 740w\" sizes=\"auto, (max-width: 769px) 100vw, 769px\" \/><\/figure>\n<\/div>\n\n\n<p>4. Kemudian bisa tambahkan IP Public koneksi yang Anda gunakan, untuk cek IP Public bisa akses ke <a href=\"https:\/\/ipsaya.com\/\" title=\"https:\/\/ipsaya.com\/\">https:\/\/ipsaya.com\/<\/a>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"881\" height=\"288\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb2.png\" alt=\"image 2 - Panduan Remote Database MySQL dengan Navicat di Rumahweb\" class=\"wp-image-17341\" style=\"width:527px;height:172px\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb2.png 881w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb2-300x98.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb2-768x251.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb2-370x121.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb2-270x88.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb2-570x186.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb2-740x242.png 740w\" sizes=\"auto, (max-width: 881px) 100vw, 881px\" \/><\/figure>\n<\/div>\n\n\n<p>5. Selanjutnya, silahkan masukkan IP Address yang tampil pada https:\/\/ipsaya.com\/ ke kolom Host pada menu Add Access Host di <strong>Remote MySQL\u00ae<\/strong>, lalu klik <strong>Add Host.<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"715\" height=\"403\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb3.png\" alt=\"\" class=\"wp-image-17342\" style=\"width:459px;height:258px\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb3.png 715w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb3-300x169.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb3-370x209.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb3-270x152.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb3-570x321.png 570w\" sizes=\"auto, (max-width: 715px) 100vw, 715px\" \/><\/figure>\n<\/div>\n\n\n<p>6. Setelah Add Host, akan muncul notifikasi IP Statis telah berhasil ditambahkan ke whitelist cPanel.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"574\" height=\"245\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb4.png\" alt=\"\" class=\"wp-image-17343\" style=\"width:434px;height:185px\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb4.png 574w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb4-300x128.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb4-370x158.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb4-270x115.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb4-570x243.png 570w\" sizes=\"auto, (max-width: 574px) 100vw, 574px\" \/><\/figure>\n<\/div>\n\n\n<p>7. Selanjutnya buka aplikasi Navicat yang sudah diinstall pada komputer Anda, lalu klik menu <strong>Connection<\/strong> &gt; <strong>MySQL<\/strong>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"425\" height=\"268\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb5.png\" alt=\"\" class=\"wp-image-17344\" style=\"width:425px;height:268px\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb5.png 425w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb5-300x189.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb5-370x233.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb5-270x170.png 270w\" sizes=\"auto, (max-width: 425px) 100vw, 425px\" \/><\/figure>\n<\/div>\n\n\n<p>8. Berikut penjelasan kolom yang perlu Anda pahami menggunakan remote database dengan aplikasi Navicat :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Connection Name<\/strong> : nama koneksi database<\/li>\n\n\n\n<li><strong>Host<\/strong> : nama domain atau IP hosting tempat server database<\/li>\n\n\n\n<li><strong>Port<\/strong> : port default 3306<\/li>\n\n\n\n<li><strong>User Name<\/strong> : nama username database<\/li>\n\n\n\n<li><strong>Password<\/strong> : password username database<\/li>\n<\/ul>\n\n\n\n<p>9. Selanjutnya klik tombol <strong>OK<\/strong>. Apabila ingin lakukan test koneksi apakah sudah benar atau belum, bisa klik tombol <strong>Test Connection<\/strong>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"561\" height=\"669\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb6.png\" alt=\"\" class=\"wp-image-17345\" style=\"width:399px;height:476px\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb6.png 561w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb6-252x300.png 252w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb6-370x441.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb6-270x322.png 270w\" sizes=\"auto, (max-width: 561px) 100vw, 561px\" \/><\/figure>\n<\/div>\n\n\n<p>10. Selamat, Anda telah berhasil konfigurasi remoted database menggunakan aplikasi Navicat di layanan hosting Rumahweb Indonesia.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"795\" height=\"440\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb7.png\" alt=\"\" class=\"wp-image-17346\" style=\"width:480px;height:265px\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb7.png 795w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb7-300x166.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb7-768x425.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb7-370x205.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb7-270x149.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb7-570x315.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/navicat_rumahweb7-740x410.png 740w\" sizes=\"auto, (max-width: 795px) 100vw, 795px\" \/><\/figure>\n<\/div>\n\n\n<p>Demikian <span style=\"text-decoration: underline;\">panduan tentang membuat remote database dengan Navicat di hosting Rumahweb Indonesia<\/span>. Jika Anda mengalami kendala atau kesulitan, silahkan hubungi bagian teknis kami melalui email ke teknis[at]rumahweb.com.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pada panduan ini, kami akan berbagi cara remote database MySQL dengan aplikasi Navicat. Aplikasi ini dapat anda download melalui website resmi Navicat. Sebelum kami menjelaskan tentang cara menggunakan remote database di hosting dengan navicat, terlebih dahulu kami akan menjelaskan secara singkat apa itu aplikasi Navicat. Berikut informasi selengkapnya. Apa itu Navicat? Navicat adalah software untuk [&hellip;]<\/p>\n","protected":false},"author":336,"featured_media":18628,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[695,8],"tags":[18,135,1442],"class_list":{"0":"post-17334","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-cpanel","8":"category-web-hosting","9":"tag-cpanel","10":"tag-database","11":"tag-navicat"},"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/11\/Banner-Artikel-Navicat-1.png","jetpack_shortlink":"https:\/\/wp.me\/p8n3G7-4vA","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/17334","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/users\/336"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/comments?post=17334"}],"version-history":[{"count":0,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/17334\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media\/18628"}],"wp:attachment":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media?parent=17334"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/categories?post=17334"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/tags?post=17334"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}