{"id":42418,"date":"2023-10-04T16:57:53","date_gmt":"2023-10-04T09:57:53","guid":{"rendered":"https:\/\/www.rumahweb.com\/journal\/?p=42418"},"modified":"2023-10-04T16:57:54","modified_gmt":"2023-10-04T09:57:54","slug":"remote-database-mysql-cyberpanel","status":"publish","type":"post","link":"https:\/\/www.rumahweb.com\/journal\/remote-database-mysql-cyberpanel\/","title":{"rendered":"Cara Remote Database MySQL di CyberPanel"},"content":{"rendered":"\n<p>CyberPanel adalah salah satu control panel gratis yang dapat digunakan untuk memudahkan Anda dalam mengelola server. Selain file manager yang digunakan untuk mengelola file, CyberPanel juga dilengkapi dengan fitur remote database. Dalam artikel ini, kami akan berbagi cara  remote database MySQL di CyberPanel dengan aplikasi HeidiSQL.<\/p>\n\n\n\n\n\n<p>Sebelum kami menjelaskan tentang cara menggunakan remote database di CyberPanel dengan HeidiSQL, terlebih dahulu kami akan menjelaskan secara singkat apa itu remote database. Berikut informasi selengkapnya.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Pengertian Remote Database<\/h2>\n\n\n\n<p>Remote Database adalah salah satu cara untuk mengakses dan mengelola database di server melalui perangkat lain. Ada beberapa cara yang dapat Anda gunakan untuk mengelola database pada server. Anda dapat mengakses database server secara langsung melalui browser atau menggunakan aplikasi pihak ketiga, yang biasa kita kenal dengan istilah \u2018remote database\u2019.<\/p>\n\n\n\n<p>Umumnya, remote database dikelola melalui port 3306, yang juga digunakan oleh CyberPanel. Namun, Anda dapat melakukan modifikasi pada port database sesuai dengan kebutuhan.<\/p>\n\n\n\n<p>Selain memastikan port telah terbuka, pastikan juga Anda telah menginstall aplikasi remote database seperti HeidiSQL, Navicat, Workbench atau SQLyog. Aplikasi tersebut dapat Anda download dan install secara gratis di komputer atau laptop. <\/p>\n\n\n\n<p>Informasi selengkapnya tentang cara install CyberPanel bisa dilihat pada link berikut : <a href=\"https:\/\/www.rumahweb.com\/journal\/cara-install-cyberpanel\/\">Install CyerPanel<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Remote Database MySQL di CyberPanel<\/h2>\n\n\n\n<p>Ada beberapa tahapan yang perlu Anda persiapkan untuk melakukan remote database di CyberPanel.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1. Akses Menu Database di CyberPanel<\/h3>\n\n\n\n<p>Sebelum melakukan remote database, pastikan bahwa Anda telah membuat dan mengimpor database yang akan digunakan ke CyberPanel. Setelah database siap, maka Anda bisa melanjutkan untuk step berikutnya. <\/p>\n\n\n\n<p>Informasi selengkapnya tentang cara membuat database di CyberPanel bisa dilihat pada link berikut: <a href=\"https:\/\/www.rumahweb.com\/journal\/membuat-database-di-cyberpanel\/\">Cara Membuat Database CyberPanel<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2. Open Port MySQL dan IP Public di Firewall<\/h3>\n\n\n\n<p>Secara umum, untuk melakukan remote database di server diperlukan port 3306 dengan setting allow (whitelist). Berikut cara open port 3306 di CyberPanel:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Silakan akses login ke url\u00a0 <strong>https:\/\/IPVPS_Anda:8090<\/strong>, kemudian isikan username dan password yang digunakan. Lalu klik tombol <strong>Sign In<\/strong>.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Login-CyberPanel.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Login-CyberPanel-1024x519.png\" alt=\"Login CyberPanel\" class=\"wp-image-42438\" style=\"width:586px;height:297px\" width=\"586\" height=\"297\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Login-CyberPanel-1024x519.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Login-CyberPanel-300x152.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Login-CyberPanel-768x389.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Login-CyberPanel-370x188.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Login-CyberPanel-270x137.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Login-CyberPanel-570x289.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Login-CyberPanel-740x375.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Login-CyberPanel.png 1327w\" sizes=\"auto, (max-width: 586px) 100vw, 586px\" \/><\/a><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li>Selanjutnya, anda dapat mengakses menu database melalui dua cara sesuai kebiasaan Anda.<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Pertama, dengan mengakses menu Database di bagian Available Function.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Kedua, dengan mengakses menu Database melalui sidebar seperti gambar berikut.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Menu-Database-CyberPanel.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Menu-Database-CyberPanel-1024x616.png\" alt=\"Menu Database CyberPanel\" class=\"wp-image-42422\" style=\"width:583px;height:351px\" width=\"583\" height=\"351\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Menu-Database-CyberPanel-1024x616.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Menu-Database-CyberPanel-300x180.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Menu-Database-CyberPanel-768x462.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Menu-Database-CyberPanel-370x223.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Menu-Database-CyberPanel-270x162.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Menu-Database-CyberPanel-570x343.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Menu-Database-CyberPanel-740x445.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Menu-Database-CyberPanel.png 1074w\" sizes=\"auto, (max-width: 583px) 100vw, 583px\" \/><\/a><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\" start=\"3\">\n<li>Pastikan bahwa Anda telah mengetahui nama database, username database dan password database yang akan digunakan. Detail informasi database juga bisa dilihat pada Menu <strong>Database<\/strong> > <strong>List Database<\/strong>.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/List-DB-CyberPanel.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/List-DB-CyberPanel-1024x505.png\" alt=\"List DB CyberPanel\" class=\"wp-image-42423\" style=\"width:586px;height:289px\" width=\"586\" height=\"289\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/List-DB-CyberPanel-1024x505.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/List-DB-CyberPanel-300x148.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/List-DB-CyberPanel-768x379.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/List-DB-CyberPanel-370x183.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/List-DB-CyberPanel-270x133.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/List-DB-CyberPanel-570x281.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/List-DB-CyberPanel-740x365.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/List-DB-CyberPanel.png 1074w\" sizes=\"auto, (max-width: 586px) 100vw, 586px\" \/><\/a><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\" start=\"4\">\n<li>Kemudian buka browser seperti Google Chrome, Microsoft Edge, atau yang lain seperti browser Firefox. Kemudian akses website penyedia informasi <a href=\"https:\/\/www.rumahweb.com\/journal\/apa-itu-ip-public-adalah\/\" title=\"ip public adalah\">IP public<\/a> seperti <strong>ipsaya.com<\/strong> atau <strong>whatismyip.com<\/strong>. Lalu catat IP address yang muncul yang nantinya akan di allow pada CSF\/Firewall CyberPanel.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/IP-Public-Internet.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/IP-Public-Internet.png\" alt=\"IP Public Internet\" class=\"wp-image-42425\" style=\"width:612px;height:350px\" width=\"612\" height=\"350\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/IP-Public-Internet.png 1013w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/IP-Public-Internet-300x171.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/IP-Public-Internet-768x439.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/IP-Public-Internet-370x211.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/IP-Public-Internet-270x154.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/IP-Public-Internet-570x326.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/IP-Public-Internet-740x423.png 740w\" sizes=\"auto, (max-width: 612px) 100vw, 612px\" \/><\/a><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\" start=\"5\">\n<li>Untuk manage firewall di CyberPanel bisa klik Menu <strong>Security<\/strong> > <strong>CSF<\/strong>.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Menu-Security-CSF.png\"><img loading=\"lazy\" decoding=\"async\" width=\"298\" height=\"362\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Menu-Security-CSF.png\" alt=\"Menu Security CSF\" class=\"wp-image-42426\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Menu-Security-CSF.png 298w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Menu-Security-CSF-247x300.png 247w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Menu-Security-CSF-270x328.png 270w\" sizes=\"auto, (max-width: 298px) 100vw, 298px\" \/><\/a><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\" start=\"6\">\n<li>Pada submenu CSF, silakan klik bagian General lalu isikan port <strong>3306<\/strong> pada <strong><em>TCP IN Ports<\/em><\/strong> dan <strong><em>TCP Out Ports<\/em><\/strong> kemudian klik tombol Save bagian kanan kolom port.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Allow-Port-3306.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Allow-Port-3306-1024x597.png\" alt=\"Allow Port 3306\" class=\"wp-image-42428\" style=\"width:602px;height:351px\" width=\"602\" height=\"351\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Allow-Port-3306-1024x597.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Allow-Port-3306-300x175.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Allow-Port-3306-768x448.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Allow-Port-3306-370x216.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Allow-Port-3306-270x157.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Allow-Port-3306-570x332.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Allow-Port-3306-740x431.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Allow-Port-3306.png 1060w\" sizes=\"auto, (max-width: 602px) 100vw, 602px\" \/><\/a><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\" start=\"7\">\n<li>Masih di submenu CSF, selanjutnya klik bagian CSF kemudian isikan IP Address yang didapat dari pengecekan IP Public dikolom <strong><em>Allow IP<\/em><\/strong> dan klik tombol Save.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Whitelist-IP-Public.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Whitelist-IP-Public-1024x329.png\" alt=\"Whitelist IP Public\" class=\"wp-image-42429\" style=\"width:601px;height:193px\" width=\"601\" height=\"193\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Whitelist-IP-Public-1024x329.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Whitelist-IP-Public-300x96.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Whitelist-IP-Public-768x247.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Whitelist-IP-Public-370x119.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Whitelist-IP-Public-270x87.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Whitelist-IP-Public-570x183.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Whitelist-IP-Public-740x238.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Whitelist-IP-Public.png 1071w\" sizes=\"auto, (max-width: 601px) 100vw, 601px\" \/><\/a><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\" start=\"8\">\n<li>Kembali lagi ke Menu <strong>Database<\/strong> >\u00a0 <strong>List Database<\/strong> > pilih nama website atau nama domain Anda > pilih nama database yang akan diremote, lalu klik <strong>Manage<\/strong>.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Manage-Database-Remote.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Manage-Database-Remote.png\" alt=\"Manage Database Remote\" class=\"wp-image-42430\" style=\"width:614px;height:270px\" width=\"614\" height=\"270\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Manage-Database-Remote.png 959w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Manage-Database-Remote-300x132.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Manage-Database-Remote-768x338.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Manage-Database-Remote-370x163.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Manage-Database-Remote-270x119.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Manage-Database-Remote-570x251.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Manage-Database-Remote-740x326.png 740w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\" start=\"9\">\n<li>Selanjutnya pada kolom <strong><em>Allow Remote Access on following IP<\/em><\/strong> silahkan isikan IP Public anda dan klik tombol Save Changes.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Allo-IP-Public.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Allo-IP-Public.png\" alt=\"Allow IP Public\" class=\"wp-image-42431\" style=\"width:623px;height:235px\" width=\"623\" height=\"235\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Allo-IP-Public.png 896w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Allo-IP-Public-300x113.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Allo-IP-Public-768x290.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Allo-IP-Public-370x140.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Allo-IP-Public-270x102.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Allo-IP-Public-570x215.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Allo-IP-Public-740x279.png 740w\" sizes=\"auto, (max-width: 623px) 100vw, 623px\" \/><\/a><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\">Step 3. Remote DB di aplikasi HeidiSQL<\/h3>\n\n\n\n<p>HeidiSQL adalah salah satu aplikasi berbasis Windows yang berfungsi untuk remote database. Dengan HeidiSQL, Anda dapat melihat data, mengubah\/mengedit data, membuat tabel, dan mengedit tabel di database tidak perlu login ke phpMyAdmin di CyerPanel.<\/p>\n\n\n\n<p>Aplikasi HeidiSQL dapat di download melalui link berikut: <a href=\"https:\/\/www.heidisql.com\/download.php\" target=\"_blank\" rel=\"noopener\" title=\"\">Download HeidiSQL<\/a><\/p>\n\n\n\n<p>Setelah memastikan database dan aplikasi HeidiSQL siap, Anda bisa mengikuti panduan berikut untuk remote database mysql di cyberPanel.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Buka aplikasi HeidiSQL yang sebelumnya sudah terinstall, kemudian klik <strong>New<\/strong>.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Session-Manager-HeidiSQL.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Session-Manager-HeidiSQL.png\" alt=\"Session Manager HeidiSQL\" class=\"wp-image-42433\" style=\"width:548px;height:389px\" width=\"548\" height=\"389\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Session-Manager-HeidiSQL.png 686w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Session-Manager-HeidiSQL-300x213.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Session-Manager-HeidiSQL-370x263.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Session-Manager-HeidiSQL-270x192.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Session-Manager-HeidiSQL-570x405.png 570w\" sizes=\"auto, (max-width: 548px) 100vw, 548px\" \/><\/a><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li>Berikut penjelasan konfigurasi <strong>Session Manager<\/strong> yang perlu Anda pahami untuk menggunakan remote database dengan aplikasi HeidiSQL:<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Network Type<\/strong> : MySQL (TCP\/IP)<\/li>\n\n\n\n<li><strong>Library<\/strong> : libmariadb.dll<\/li>\n\n\n\n<li><strong>Hostname\/IP<\/strong> : isikan nama domain atau IP VPS lokasi server database<\/li>\n\n\n\n<li><strong>Username<\/strong> : username database<\/li>\n\n\n\n<li><strong>Password<\/strong> : password username database&nbsp;<\/li>\n\n\n\n<li><strong>Port<\/strong> : port default 3306<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Konfigurasi-Koneksi-DB.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Konfigurasi-Koneksi-DB.png\" alt=\"Konfigurasi Koneksi remote database\" class=\"wp-image-42434\" style=\"width:602px;height:425px\" width=\"602\" height=\"425\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Konfigurasi-Koneksi-DB.png 683w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Konfigurasi-Koneksi-DB-300x212.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Konfigurasi-Koneksi-DB-370x261.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Konfigurasi-Koneksi-DB-270x191.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Konfigurasi-Koneksi-DB-570x402.png 570w\" sizes=\"auto, (max-width: 602px) 100vw, 602px\" \/><\/a><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\" start=\"3\">\n<li>Setelah semuanya diisi, lanjut klik tombol <strong>Open<\/strong> dan jika muncul popup konfigurasi klik tombol <strong>Yes<\/strong> untuk melanjutkan.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Save-Setting-Remote-DB.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Save-Setting-Remote-DB.png\" alt=\"Save Setting Remote DB\" class=\"wp-image-42435\" style=\"width:374px;height:161px\" width=\"374\" height=\"161\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Save-Setting-Remote-DB.png 355w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Save-Setting-Remote-DB-300x129.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Save-Setting-Remote-DB-270x116.png 270w\" sizes=\"auto, (max-width: 374px) 100vw, 374px\" \/><\/a><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\" start=\"4\">\n<li>Selamat, anda telah berhasil konfigurasi remote database menggunakan aplikasi HeidiSQL di VPS Server menggunakan CyberPanel.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Remote-DB-Connected.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Remote-DB-Connected.png\" alt=\"Remote database Connected\" class=\"wp-image-42436\" style=\"width:607px;height:364px\" width=\"607\" height=\"364\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Remote-DB-Connected.png 867w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Remote-DB-Connected-300x180.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Remote-DB-Connected-768x461.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Remote-DB-Connected-370x222.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Remote-DB-Connected-270x162.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Remote-DB-Connected-570x342.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2023\/09\/Remote-DB-Connected-740x444.png 740w\" sizes=\"auto, (max-width: 607px) 100vw, 607px\" \/><\/a><\/figure>\n<\/div>\n\n\n<p>Demikian artikel kami tentang cara remote database MySQL di CyberPanel. Semoga bermanfaat.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>CyberPanel adalah salah satu control panel gratis yang dapat digunakan untuk memudahkan Anda dalam mengelola server. Selain file manager yang digunakan untuk mengelola file, CyberPanel juga dilengkapi dengan fitur remote database. Dalam artikel ini, kami akan berbagi cara remote database MySQL di CyberPanel dengan aplikasi HeidiSQL. Sebelum kami menjelaskan tentang cara menggunakan remote database di [&hellip;]<\/p>\n","protected":false},"author":336,"featured_media":42609,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[686],"tags":[677,807,2045],"class_list":{"0":"post-42418","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-cyberpanel","8":"tag-cyberpanel","9":"tag-remote-database","10":"tag-remote-mysql"},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/42418","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=42418"}],"version-history":[{"count":0,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/42418\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media\/42609"}],"wp:attachment":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media?parent=42418"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/categories?post=42418"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/tags?post=42418"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}