{"id":21345,"date":"2024-07-29T03:40:31","date_gmt":"2024-07-29T03:40:31","guid":{"rendered":"https:\/\/hosteko.com\/blog\/?p=21345"},"modified":"2024-07-29T03:40:31","modified_gmt":"2024-07-29T03:40:31","slug":"cara-remote-mysql-melalui-ssh-tunneling","status":"publish","type":"post","link":"https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling","title":{"rendered":"Begini Cara Remote MySQL melalui SSH Tunneling dengan Bantuan HeidiSQL"},"content":{"rendered":"<p>Tahukah kamu bahwa kamu dapat mengontrol database MySQL dari komputer lokal? Inilah yang disebut dengan\u00a0 remote database&#8221;. Kamu dapat mengakses database yang ada di hosting dan mengontrol serta melakukan query secara langsung di komputer lain.<\/p>\n<p>Kamu dapat mengedit data dengan lebih mudah tanpa harus membuka phpmyadmin yang ada di cPanel. Ada beberapa cara untuk melakukan remote MySQL, salah satunya adalah dengan menggunakan SSH Tunneling.<\/p>\n<p>Nah, pada panduan kali ini Hosteko akan menunjukkan cara remote MySQL melalui SSH Tunneling. Maka dari itu, simak sampai akhir ya!<\/p>\n<h2 id=\"Cara-Remote-MySQL-Melalui-SSH-Tunneling\" data-id=\"Cara-Remote-MySQL-Melalui-SSH-Tunneling\"><span id=\"Cara_Remote_MySQL_Melalui_SSH_Tunneling\">Cara Remote MySQL melalui SSH Tunneling<\/span><\/h2>\n<p>Ada beberapa cara untuk melakukan remote MySQL, salah satunya adalah melalui SSH tunneling. Untuk itu, pada panduan kali ini kamu harus melakukan langkah-langkah berikut ini:<\/p>\n<ul>\n<li>Pertama, melakukan SSH Tunneling untuk membuat koneksi dengan hosting agar kamu dapat melakukan remote.<\/li>\n<li>Remote MySQL dengan bantuan HeidiSQL. HeidiSQL mirip dengan phpMyAdmin (untuk pengelolaan MySQL) sehingga memudahkan kamu untuk mengakses data, mengubah query, dan menambahkan data. HeidiSQL hanya tersedia untuk Windows.<\/li>\n<\/ul>\n<h3 id=\"2-Instalasi-HeidiSQL\" data-id=\"2-Instalasi-HeidiSQL\"><span id=\"1_Melakukan_Instalasi_HeidiSQL\">1. Melakukan Instalasi HeidiSQL<\/span><\/h3>\n<p>Sebelum melakukan remote MySQL, kamu harus menginstal HeidiSQL terlebih dahulu. HeidiSQL adalah portal untuk mengelola database MySQL, MariaDB, dan bahkan PostgreSQL.<\/p>\n<p>Fungsinya hampir sama dengan phpMyAdmin. File aplikasi HeidiSQL dapat kamu unduh di https:\/\/www.heidisql.com\/download.php. Selain HeidiSQL, kamu juga bisa menggunakan Navicat, TablePlus, atau yang lainnya.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-21351 size-full\" src=\"https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/Melakukan-Instalasi-HeidiSQL.png\" alt=\"\" width=\"909\" height=\"455\" srcset=\"https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/Melakukan-Instalasi-HeidiSQL.png 909w, https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/Melakukan-Instalasi-HeidiSQL-768x384.png 768w, https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/Melakukan-Instalasi-HeidiSQL-640x320.png 640w, https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/Melakukan-Instalasi-HeidiSQL-400x200.png 400w\" sizes=\"auto, (max-width: 909px) 100vw, 909px\" \/><\/p>\n<h3 id=\"3-Remote-PostgreSQL-Melalui-HeidiSQL\" data-id=\"3-Remote-PostgreSQL-Melalui-HeidiSQL\"><span id=\"2_Melakukan_Konfigurasi_Database\">2. Melakukan Konfigurasi Database<\/span><\/h3>\n<p>Untuk melakukan remote MySQL, silakan buka HeidiSQL, klik &#8220;New&#8221;, dan tambahkan konfigurasi server tujuan yang akan di-remote.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-21354 size-full\" src=\"https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/buka-HeidiSQL.webp\" alt=\"\" width=\"685\" height=\"414\" srcset=\"https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/buka-HeidiSQL.webp 685w, https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/buka-HeidiSQL-640x387.webp 640w, https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/buka-HeidiSQL-400x242.webp 400w\" sizes=\"auto, (max-width: 685px) 100vw, 685px\" \/><\/p>\n<p>Tunggu beberapa saat hingga muncul tampilan berikut. Dalam mengkonfigurasi database, kamu hanya perlu mengkonfigurasi kolom &#8220;Netword Type&#8221;, &#8220;User&#8221;, dan &#8220;Password&#8221;. Biarkan kolom lainnya terisi secara default. Pertama-tama, silakan klik pada tab menu Settings untuk menambahkan konfigurasi setting remote MySQL.<\/p>\n<p>Pada bagian Network type, silakan pilih MariaDB or MySQL (SSH tunnel). Selanjutnya, pada bagian User, silakan masukkan username database yang ada di hosting. Tulis juga password database yang ada di hosting. Setelah konfigurasi database selesai, langsung saja lanjutkan ke langkah ketiga untuk mengkonfigurasi server.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-21355 size-full\" src=\"https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/melakukan-konfigurasi-database.webp\" alt=\"\" width=\"768\" height=\"540\" srcset=\"https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/melakukan-konfigurasi-database.webp 768w, https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/melakukan-konfigurasi-database-640x450.webp 640w, https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/melakukan-konfigurasi-database-400x281.webp 400w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><\/p>\n<h4 style=\"text-align: center\">Catatan: port 3306 adalah port tunnel untuk remote MySQL. Jika port tunneling-nya berbeda maka silakan sesuaikan dengan port tersebut.<\/h4>\n<h3 data-id=\"4-Remote-PostgreSQL-Melalui-SSH-Tunneling-Berhasil\"><span id=\"3_Melakukan_Konfigurasi_Server\">3. Melakukan Konfigurasi Server<\/span><\/h3>\n<p>Dalam melakukan remote MySQL melalui SSH Tunneling, kamu bisa melalukannya secara langsung pada HeidiSQL tanpa menggunakan PuTTY terlebih dahulu. Setelah kamu selesai melakukan konfigurasi database yang akan di remote, kamu harus melakukan konfigurasi lain, yaitu konfigurasi server atau cPanel hosting.<\/p>\n<p>Silakan pilih tab &#8220;SSH tunnel&#8221;. Kamu harus mengisi empat kolom yang meliputi plink.exe location, SSH host + port, username, dan password. Untuk mengisi kolom plink.exe location, kamu bisa download file plink.exe terlebih dahulu.<\/p>\n<p>Jika sudah, silakan masukkan path lokasi file plink.exe yang telah di-download pada kolom plink.exe location. Selanjutnya, masukkan nama domain dan port SSH hosting kamu pada kolom SSH host + port.<\/p>\n<p>Pada bagian Username, silakan masukkan username cPanel hosting kamu. Pada kolom Password, silakan masukkan password cPanel hosting kamu. Jika semuanya sudah selesai, langsung saja klik &#8220;Open&#8221;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-21356 size-full\" src=\"https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/Melakukan-Konfigurasi-Server.webp\" alt=\"\" width=\"768\" height=\"538\" srcset=\"https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/Melakukan-Konfigurasi-Server.webp 768w, https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/Melakukan-Konfigurasi-Server-640x448.webp 640w, https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/Melakukan-Konfigurasi-Server-400x280.webp 400w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><\/p>\n<h3 id=\"4-Remote-PostgreSQL-Melalui-SSH-Tunneling-Berhasil\" data-id=\"4-Remote-PostgreSQL-Melalui-SSH-Tunneling-Berhasil\"><span id=\"4_Remote_MySQL_Melalui_SSH_Tunneling_Berhasil\">4. Remote MySQL Melalui SSH Tunneling Berhasil<\/span><\/h3>\n<p>Selamat! Remote MySQL melalui SSH Tunneling berhasil. Kamu sekarang dapat mengakses database MySQL\u00a0 secara terpisah. Kamu juga dapat mengelola database dan melakukan query sesuai keinginan.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-21358 size-full\" src=\"https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/Remote-MySQL-Melalui-SSH-Tunneling-Berhasil.webp\" alt=\"\" width=\"700\" height=\"447\" srcset=\"https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/Remote-MySQL-Melalui-SSH-Tunneling-Berhasil.webp 700w, https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/Remote-MySQL-Melalui-SSH-Tunneling-Berhasil-640x409.webp 640w, https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/Remote-MySQL-Melalui-SSH-Tunneling-Berhasil-400x255.webp 400w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/p>\n<p>Nah, itulah cara untuk melakukan remote MySQL melalui SSH Tunneling dengan bantuan<\/p>\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-right kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;right&quot;,&quot;id&quot;:&quot;21345&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;3&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;0&quot;,&quot;greet&quot;:&quot;Jadilah yang pertama untuk memberi nilai&quot;,&quot;legend&quot;:&quot;5\\\/5 - (3 votes)&quot;,&quot;size&quot;:&quot;22&quot;,&quot;title&quot;:&quot;Begini Cara Remote MySQL melalui SSH Tunneling dengan Bantuan HeidiSQL&quot;,&quot;width&quot;:&quot;110&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 0px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 0px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 0px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 0px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 0px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 110px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 0px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 0px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 0px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 0px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 0px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 17.6px;\">\n            5\/5 - (3 votes)    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p>Tahukah kamu bahwa kamu dapat mengontrol database MySQL dari komputer lokal? Inilah yang disebut dengan\u00a0 remote database&#8221;. Kamu dapat mengakses database yang ada di hosting dan mengontrol serta melakukan query secara langsung di komputer lain. Kamu dapat mengedit data dengan lebih mudah tanpa harus membuka phpmyadmin yang ada di cPanel. Ada beberapa cara untuk melakukan [&hellip;]<\/p>\n","protected":false},"author":10,"featured_media":21349,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rop_custom_images_group":[],"rop_custom_messages_group":[],"rop_publish_now":"initial","rop_publish_now_accounts":{"twitter_2392824914_2392824914":""},"rop_publish_now_history":[],"rop_publish_now_status":"pending","_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[3],"tags":[9170,9171,9174,9173,2442,9169,9172],"class_list":["post-21345","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-cara-remote-mysql","tag-cara-remote-mysql-melalui-ssh-tunneling","tag-cara-remote-mysql-melalui-ssh-tunneling-dengan-bantuan-heidisql","tag-heidisql","tag-mysql","tag-remote-mysql","tag-ssh-tunneling"],"featured_image_src":{"landsacpe":["https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/Begini-Cara-Remote-MySQL-melalui-SSH-Tunneling-dengan-Bantuan-HeidiSQL-1140x445.png",1140,445,true],"list":["https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/Begini-Cara-Remote-MySQL-melalui-SSH-Tunneling-dengan-Bantuan-HeidiSQL-463x348.png",463,348,true],"medium":["https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/Begini-Cara-Remote-MySQL-melalui-SSH-Tunneling-dengan-Bantuan-HeidiSQL-300x169.png",300,169,true],"full":["https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/Begini-Cara-Remote-MySQL-melalui-SSH-Tunneling-dengan-Bantuan-HeidiSQL.png",1366,768,false]},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Begini Cara Remote MySQL melalui SSH Tunneling dengan Bantuan HeidiSQL - Hosteko Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Begini Cara Remote MySQL melalui SSH Tunneling dengan Bantuan HeidiSQL - Hosteko Blog\" \/>\n<meta property=\"og:description\" content=\"Tahukah kamu bahwa kamu dapat mengontrol database MySQL dari komputer lokal? Inilah yang disebut dengan\u00a0 remote database&#8221;. Kamu dapat mengakses database yang ada di hosting dan mengontrol serta melakukan query secara langsung di komputer lain. Kamu dapat mengedit data dengan lebih mudah tanpa harus membuka phpmyadmin yang ada di cPanel. Ada beberapa cara untuk melakukan [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling\" \/>\n<meta property=\"og:site_name\" content=\"Hosteko Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-07-29T03:40:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/Begini-Cara-Remote-MySQL-melalui-SSH-Tunneling-dengan-Bantuan-HeidiSQL.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1366\" \/>\n\t<meta property=\"og:image:height\" content=\"768\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Dwi H\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dwi H\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling#article\",\"isPartOf\":{\"@id\":\"https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling\"},\"author\":{\"name\":\"Dwi H\",\"@id\":\"https:\/\/hosteko.com\/blog\/#\/schema\/person\/f70006239545aaece294daf39a3ce979\"},\"headline\":\"Begini Cara Remote MySQL melalui SSH Tunneling dengan Bantuan HeidiSQL\",\"datePublished\":\"2024-07-29T03:40:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling\"},\"wordCount\":520,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hosteko.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/Begini-Cara-Remote-MySQL-melalui-SSH-Tunneling-dengan-Bantuan-HeidiSQL.png\",\"keywords\":[\"Cara Remote MySQL\",\"Cara Remote MySQL melalui SSH Tunneling\",\"Cara Remote MySQL melalui SSH Tunneling dengan Bantuan HeidiSQL\",\"HeidiSQL\",\"MySQL\",\"Remote MySQL\",\"SSH Tunneling\"],\"articleSection\":[\"Blog\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling\",\"url\":\"https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling\",\"name\":\"Begini Cara Remote MySQL melalui SSH Tunneling dengan Bantuan HeidiSQL - Hosteko Blog\",\"isPartOf\":{\"@id\":\"https:\/\/hosteko.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/Begini-Cara-Remote-MySQL-melalui-SSH-Tunneling-dengan-Bantuan-HeidiSQL.png\",\"datePublished\":\"2024-07-29T03:40:31+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling#primaryimage\",\"url\":\"https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/Begini-Cara-Remote-MySQL-melalui-SSH-Tunneling-dengan-Bantuan-HeidiSQL.png\",\"contentUrl\":\"https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/Begini-Cara-Remote-MySQL-melalui-SSH-Tunneling-dengan-Bantuan-HeidiSQL.png\",\"width\":1366,\"height\":768},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/hosteko.com\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Begini Cara Remote MySQL melalui SSH Tunneling dengan Bantuan HeidiSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hosteko.com\/blog\/#website\",\"url\":\"https:\/\/hosteko.com\/blog\/\",\"name\":\"Hosteko Blog\",\"description\":\"Berita &amp; Informasi Dunia IT\",\"publisher\":{\"@id\":\"https:\/\/hosteko.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hosteko.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hosteko.com\/blog\/#organization\",\"name\":\"HOSTEKO\",\"url\":\"https:\/\/hosteko.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/hosteko.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2019\/04\/logo-hosteko.png\",\"contentUrl\":\"https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2019\/04\/logo-hosteko.png\",\"width\":195,\"height\":57,\"caption\":\"HOSTEKO\"},\"image\":{\"@id\":\"https:\/\/hosteko.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/hosteko.com\/blog\/#\/schema\/person\/f70006239545aaece294daf39a3ce979\",\"name\":\"Dwi H\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/hosteko.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/60b90505d1564b8ba545efb7a3d2153585f14759dc86b9180ba2fbf5d8805ff2?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/60b90505d1564b8ba545efb7a3d2153585f14759dc86b9180ba2fbf5d8805ff2?s=96&d=mm&r=g\",\"caption\":\"Dwi H\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Begini Cara Remote MySQL melalui SSH Tunneling dengan Bantuan HeidiSQL - Hosteko Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling","og_locale":"en_US","og_type":"article","og_title":"Begini Cara Remote MySQL melalui SSH Tunneling dengan Bantuan HeidiSQL - Hosteko Blog","og_description":"Tahukah kamu bahwa kamu dapat mengontrol database MySQL dari komputer lokal? Inilah yang disebut dengan\u00a0 remote database&#8221;. Kamu dapat mengakses database yang ada di hosting dan mengontrol serta melakukan query secara langsung di komputer lain. Kamu dapat mengedit data dengan lebih mudah tanpa harus membuka phpmyadmin yang ada di cPanel. Ada beberapa cara untuk melakukan [&hellip;]","og_url":"https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling","og_site_name":"Hosteko Blog","article_published_time":"2024-07-29T03:40:31+00:00","og_image":[{"width":1366,"height":768,"url":"https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/Begini-Cara-Remote-MySQL-melalui-SSH-Tunneling-dengan-Bantuan-HeidiSQL.png","type":"image\/png"}],"author":"Dwi H","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Dwi H","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling#article","isPartOf":{"@id":"https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling"},"author":{"name":"Dwi H","@id":"https:\/\/hosteko.com\/blog\/#\/schema\/person\/f70006239545aaece294daf39a3ce979"},"headline":"Begini Cara Remote MySQL melalui SSH Tunneling dengan Bantuan HeidiSQL","datePublished":"2024-07-29T03:40:31+00:00","mainEntityOfPage":{"@id":"https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling"},"wordCount":520,"commentCount":0,"publisher":{"@id":"https:\/\/hosteko.com\/blog\/#organization"},"image":{"@id":"https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling#primaryimage"},"thumbnailUrl":"https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/Begini-Cara-Remote-MySQL-melalui-SSH-Tunneling-dengan-Bantuan-HeidiSQL.png","keywords":["Cara Remote MySQL","Cara Remote MySQL melalui SSH Tunneling","Cara Remote MySQL melalui SSH Tunneling dengan Bantuan HeidiSQL","HeidiSQL","MySQL","Remote MySQL","SSH Tunneling"],"articleSection":["Blog"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling#respond"]}]},{"@type":"WebPage","@id":"https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling","url":"https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling","name":"Begini Cara Remote MySQL melalui SSH Tunneling dengan Bantuan HeidiSQL - Hosteko Blog","isPartOf":{"@id":"https:\/\/hosteko.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling#primaryimage"},"image":{"@id":"https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling#primaryimage"},"thumbnailUrl":"https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/Begini-Cara-Remote-MySQL-melalui-SSH-Tunneling-dengan-Bantuan-HeidiSQL.png","datePublished":"2024-07-29T03:40:31+00:00","breadcrumb":{"@id":"https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling#primaryimage","url":"https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/Begini-Cara-Remote-MySQL-melalui-SSH-Tunneling-dengan-Bantuan-HeidiSQL.png","contentUrl":"https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/Begini-Cara-Remote-MySQL-melalui-SSH-Tunneling-dengan-Bantuan-HeidiSQL.png","width":1366,"height":768},{"@type":"BreadcrumbList","@id":"https:\/\/hosteko.com\/blog\/cara-remote-mysql-melalui-ssh-tunneling#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/hosteko.com\/blog"},{"@type":"ListItem","position":2,"name":"Begini Cara Remote MySQL melalui SSH Tunneling dengan Bantuan HeidiSQL"}]},{"@type":"WebSite","@id":"https:\/\/hosteko.com\/blog\/#website","url":"https:\/\/hosteko.com\/blog\/","name":"Hosteko Blog","description":"Berita &amp; Informasi Dunia IT","publisher":{"@id":"https:\/\/hosteko.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hosteko.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/hosteko.com\/blog\/#organization","name":"HOSTEKO","url":"https:\/\/hosteko.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/hosteko.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2019\/04\/logo-hosteko.png","contentUrl":"https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2019\/04\/logo-hosteko.png","width":195,"height":57,"caption":"HOSTEKO"},"image":{"@id":"https:\/\/hosteko.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/hosteko.com\/blog\/#\/schema\/person\/f70006239545aaece294daf39a3ce979","name":"Dwi H","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/hosteko.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/60b90505d1564b8ba545efb7a3d2153585f14759dc86b9180ba2fbf5d8805ff2?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/60b90505d1564b8ba545efb7a3d2153585f14759dc86b9180ba2fbf5d8805ff2?s=96&d=mm&r=g","caption":"Dwi H"}}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/hosteko.com\/htk-blog\/wp-content\/uploads\/2024\/07\/Begini-Cara-Remote-MySQL-melalui-SSH-Tunneling-dengan-Bantuan-HeidiSQL.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/hosteko.com\/blog\/wp-json\/wp\/v2\/posts\/21345","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hosteko.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hosteko.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hosteko.com\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/hosteko.com\/blog\/wp-json\/wp\/v2\/comments?post=21345"}],"version-history":[{"count":5,"href":"https:\/\/hosteko.com\/blog\/wp-json\/wp\/v2\/posts\/21345\/revisions"}],"predecessor-version":[{"id":21360,"href":"https:\/\/hosteko.com\/blog\/wp-json\/wp\/v2\/posts\/21345\/revisions\/21360"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hosteko.com\/blog\/wp-json\/wp\/v2\/media\/21349"}],"wp:attachment":[{"href":"https:\/\/hosteko.com\/blog\/wp-json\/wp\/v2\/media?parent=21345"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hosteko.com\/blog\/wp-json\/wp\/v2\/categories?post=21345"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hosteko.com\/blog\/wp-json\/wp\/v2\/tags?post=21345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}