{"id":2276,"date":"2022-01-26T22:29:57","date_gmt":"2022-01-26T15:29:57","guid":{"rendered":"https:\/\/www.domosquare.com\/tutorial\/?p=2276"},"modified":"2022-01-26T22:33:38","modified_gmt":"2022-01-26T15:33:38","slug":"remote-mysql-cpanel-via-ssh-tunnel-dengan-sqlyog","status":"publish","type":"post","link":"https:\/\/www.domosquare.com\/tutorial\/hosting\/remote-mysql-cpanel-via-ssh-tunnel-dengan-sqlyog.html","title":{"rendered":"Remote Mysql cPanel via SSH Tunnel dengan SQLYog"},"content":{"rendered":"\n<p>Bagi Anda yang ingin meremote mysql server pada cPanel, Anda bisa memanfaatkan SSH tunnel untuk mengakses database mysql Anda secara remote.<\/p>\n\n\n\n<p>Kelebihan menggunakan SSH tunnel adalah koneksi lebih stabil dibanding web tunnel, dan juga dapat menghindari masalah koneksi IP yang terus berubah-rubah dan perlu diwhitelist di firewall server.<\/p>\n\n\n\n<p>Pada tutorial ini kita akan menggunakan aplikasi SQLyog. Untuk tutorial lain terkait dengan menggunakan heidiSQL Anda bisa cek di URl berikut:<br><a href=\"https:\/\/www.domosquare.com\/tutorial\/cpanel\/remote-database-mysql-di-cpanel-menggunakan-ssh-tunnel.html\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.domosquare.com\/tutorial\/cpanel\/remote-database-mysql-di-cpanel-menggunakan-ssh-tunnel.html<\/a><\/p>\n\n\n\n<p>Setelah di download silahkan diinstall dan lakukan konfigurasi.<\/p>\n\n\n\n<p>Jika Anda belum memiliki history koneksi sebelumnya, silahkan klik tombol New pada jendela &#8220;Connect to Mysql Host&#8221; saat Anda menjalankan SQLyog nya, dan isikan nama koneksi yang ingin Anda buat.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-4.png\"><img loading=\"lazy\" decoding=\"async\" width=\"834\" height=\"678\" src=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-4.png\" alt=\"\" class=\"wp-image-2278\" srcset=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-4.png 834w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-4-300x244.png 300w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-4-768x624.png 768w\" sizes=\"auto, (max-width: 834px) 100vw, 834px\" \/><\/a><\/figure>\n\n\n\n<p>Selanjutnya silahkan isikan detail koneksi mysql Anda sesuai yang sudah Anda buat di cPanel.<br>(<a href=\"https:\/\/www.domosquare.com\/tutorial\/hosting\/menggunakan-fitur-fasilitas-mysql-database-di-c-panel.html\">https:\/\/www.domosquare.com\/tutorial\/hosting\/menggunakan-fitur-fasilitas-mysql-database-di-c-panel.html<\/a>)<\/p>\n\n\n\n<p>Isikan localhost pada MySQL Host Andres, Username diisikan username mysql yang Anda buat di cPanel, begitu juga password serta database nya. Untuk Port silahkan gunakan 3306.<\/p>\n\n\n\n<p>Jika Anda ingin akses semua database pada user mysql pada kolom username, maka silahkan dikosongkan saja kolom database(s) nya.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-5.png\"><img loading=\"lazy\" decoding=\"async\" width=\"834\" height=\"678\" src=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-5.png\" alt=\"\" class=\"wp-image-2279\" srcset=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-5.png 834w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-5-300x244.png 300w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-5-768x624.png 768w\" sizes=\"auto, (max-width: 834px) 100vw, 834px\" \/><\/a><\/figure>\n\n\n\n<p>Selanjutnya, klik tab SSH dan centang Use SSH tunnelling:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-6.png\"><img loading=\"lazy\" decoding=\"async\" width=\"834\" height=\"678\" src=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-6.png\" alt=\"\" class=\"wp-image-2280\" srcset=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-6.png 834w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-6-300x244.png 300w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-6-768x624.png 768w\" sizes=\"auto, (max-width: 834px) 100vw, 834px\" \/><\/a><\/figure>\n\n\n\n<p>Isikan nama domain \/ IP server pada SSH Host Adress, selanjutnya isikan Username dan password seperti password cPanel, serta port yang sudah ditanyakan ke support.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-7.png\"><img loading=\"lazy\" decoding=\"async\" width=\"834\" height=\"678\" src=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-7.png\" alt=\"\" class=\"wp-image-2281\" srcset=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-7.png 834w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-7-300x244.png 300w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-7-768x624.png 768w\" sizes=\"auto, (max-width: 834px) 100vw, 834px\" \/><\/a><\/figure>\n\n\n\n<p>Jika dirasa semua informasi sudah benar, silahkan coba klik tombol &#8220;Test Connection&#8221;.<\/p>\n\n\n\n<p>Anda akan mendapatkan alert sukses jika koneksi sudah benar.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-8.png\"><img loading=\"lazy\" decoding=\"async\" width=\"834\" height=\"678\" src=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-8.png\" alt=\"\" class=\"wp-image-2282\" srcset=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-8.png 834w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-8-300x244.png 300w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-8-768x624.png 768w\" sizes=\"auto, (max-width: 834px) 100vw, 834px\" \/><\/a><\/figure>\n\n\n\n<p>Sekarang silahkan klik tombol Save pada bagian atas untuk menyimpan konfigurasi Anda.<\/p>\n\n\n\n<p>Jika sudah tersimpan, selanjutnya Anda bisa klik tombol connect pada bagian bawah window &#8220;Connect to Mysql Host&#8221;.<\/p>\n\n\n\n<p>Anda akan melihat daftar database Anda pada jendela utama SQLyog saat aplikasinya berhasil terkoneksi:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-10.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"773\" src=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-10-1024x773.png\" alt=\"\" class=\"wp-image-2286\" srcset=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-10-1024x773.png 1024w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-10-300x227.png 300w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-10-768x580.png 768w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-10-1536x1160.png 1536w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2022\/01\/image-10.png 1696w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Bagi Anda yang ingin meremote mysql server pada cPanel, Anda bisa memanfaatkan SSH tunnel untuk mengakses database mysql Anda secara remote. Kelebihan menggunakan SSH tunnel adalah koneksi lebih stabil dibanding web tunnel, dan juga dapat menghindari masalah koneksi IP yang terus berubah-rubah dan perlu diwhitelist di firewall server. Pada tutorial ini kita akan menggunakan aplikasi [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"rating_form_position":"","rating_results_position":"","mr_structured_data_type":"","_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[839,1],"tags":[815],"class_list":["post-2276","post","type-post","status-publish","format-standard","hentry","category-cpanel","category-hosting","tag-mysql"],"jetpack_featured_media_url":"","multi-rating":{"mr_rating_results":[{"adjusted_star_result":0,"star_result":0,"total_max_option_value":5,"adjusted_score_result":0,"score_result":0,"percentage_result":0,"adjusted_percentage_result":0,"count":0,"post_id":2276}]},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/posts\/2276","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/comments?post=2276"}],"version-history":[{"count":2,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/posts\/2276\/revisions"}],"predecessor-version":[{"id":2287,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/posts\/2276\/revisions\/2287"}],"wp:attachment":[{"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/media?parent=2276"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/categories?post=2276"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/tags?post=2276"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}