{"id":21784,"date":"2021-05-27T13:21:51","date_gmt":"2021-05-27T06:21:51","guid":{"rendered":"https:\/\/www.rumahweb.com\/journal\/?p=21784"},"modified":"2021-10-01T12:54:45","modified_gmt":"2021-10-01T05:54:45","slug":"remote-database-rds-mysql-alibaba-cloud-menggunakan-sqlyog","status":"publish","type":"post","link":"https:\/\/www.rumahweb.com\/journal\/remote-database-rds-mysql-alibaba-cloud-menggunakan-sqlyog\/","title":{"rendered":"Remote Database RDS MySQL Alibaba Cloud Menggunakan SQLyog"},"content":{"rendered":"\n<p>Pada panduan ini, kami akan menjelaskan cara remote database RDS MySQL Alibaba menggunakan aplikasi SQLyog. Sebelum melakukan remote database, ada beberapa hal yang perlu Anda persiapkan. Berikut informasi selengkapnya.<\/p>\n\n\n\n\n\n<h2 class=\"wp-block-heading\">Apa saja yang perlu dipersiapkan?<\/h2>\n\n\n\n<ol class=\"wp-block-list\"><li>Pastikan Anda telah melakukan whitelist IP koneksi internet yang akan melakukan remote database. Untuk melakukan whitelist IP koneksi, Anda dapat mengikuti panduan <strong><em><a href=\"https:\/\/www.rumahweb.com\/journal\/whitelist-ip-koneksi-database-rds-mysql-alibaba-cloud\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"whitelist ip koneksi internet\">berikut<\/a>.<\/em><\/strong><\/li><li>Pastikan juga Anda telah mendapatkan informasi berikut:<\/li><\/ol>\n\n\n\n<ul class=\"wp-block-list\"><li>URL Public Endpoint<\/li><li>Account \/ user database\u2019<\/li><li>Nama database<\/li><li>Password user database<\/li><li>Port database default <strong>3306<\/strong><\/li><\/ul>\n\n\n\n<p>Apabila Anda sama sekali belum mendapatkan detail diatas, Anda bisa mempelajari panduan berikut untuk mengaktifkan public endpoin dan konfigurasi databasenya.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.rumahweb.com\/journal\/whitelist-ip-koneksi-database-rds-mysql-alibaba-cloud\/\">Setting whitelist IP Koneksi Database RDS MySQL Alibaba Cloud<\/a><\/li><li><a href=\"https:\/\/www.rumahweb.com\/journal\/aktivasi-public-endpoint-database-rds-mysql-alibaba-cloud\/\" target=\"_blank\" rel=\"noreferrer noopener\">Mengaktifkan Public Endpoint Database RDS MySQL Alibaba Cloud<\/a><\/li><li><a href=\"https:\/\/www.rumahweb.com\/journal\/konfigurasi-database-rds-mysql-alibaba-cloud\/\" target=\"_blank\" rel=\"noreferrer noopener\">Konfigurasi Database RDS MySQL Alibaba Cloud<\/a><\/li><\/ul>\n\n\n\n<p>Jika kebutuhan diatas sudah terpenuhi, silahkan lanjutkan dengan mengikuti langkah langkah dibawah ini.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Cara Remote Database RDS<\/h2>\n\n\n\n<p>1. Buka aplikasi remote database SQLyog yang sudah diinstall pada komputer Anda, lalu klik<strong> File<\/strong> &gt;<strong> New Connection.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-35.png\"><img loading=\"lazy\" decoding=\"async\" width=\"501\" height=\"265\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-35.png\" alt=\"Cara Remote Database RDS melalui mysqlyog image 1\" class=\"wp-image-24693\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-35.png 501w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-35-300x159.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-35-370x196.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-35-270x143.png 270w\" sizes=\"auto, (max-width: 501px) 100vw, 501px\" \/><\/a><\/figure>\n\n\n\n<p>2. Silahkan isikan nama file koneksi database yang digunakan (disarankan disesuaikan dengan nama database).<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-36.png\"><img loading=\"lazy\" decoding=\"async\" width=\"561\" height=\"457\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-36.png\" alt=\"Cara Remote Database RDS melalui mysqlyog image 2\" class=\"wp-image-24694\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-36.png 561w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-36-300x244.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-36-370x301.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-36-270x220.png 270w\" sizes=\"auto, (max-width: 561px) 100vw, 561px\" \/><\/a><\/figure>\n\n\n\n<p>3. Berikut penjelasan konfigurasi yang perlu Anda pahami menggunakan remote database SQLyog :<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Saved Connection : <strong>nama koneksi database<\/strong><\/li><li>MySQL Host Address : <strong>URL Public Endpoint RDS MySQL Alibaba Cloud<\/strong><\/li><li>Username :<strong> username database<\/strong><\/li><li>Password : <strong>password username database&nbsp;<\/strong><\/li><li>Port : port default<strong> 3306<\/strong><\/li><li>Databases : <strong>nama database<\/strong><\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-37.png\"><img loading=\"lazy\" decoding=\"async\" width=\"558\" height=\"452\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-37.png\" alt=\"Cara Remote Database RDS melalui mysqlyog image 3\" class=\"wp-image-24695\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-37.png 558w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-37-300x243.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-37-370x300.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-37-270x219.png 270w\" sizes=\"auto, (max-width: 558px) 100vw, 558px\" \/><\/a><\/figure>\n\n\n\n<p>4. Setelah semuanya diisi, bisa klik tombol<strong> Connect<\/strong>. Apabila konfigurasi remote database benar akan tampil nama database yang nantinya bisa Anda kelola database tanpa harus login console RDS MySQL Alibaba Cloud.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-38.png\"><img loading=\"lazy\" decoding=\"async\" width=\"570\" height=\"290\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-38.png\" alt=\"Cara Remote Database RDS melalui mysqlyog image 4\" class=\"wp-image-24696\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-38.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-38-300x153.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-38-370x188.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-38-270x137.png 270w\" sizes=\"auto, (max-width: 570px) 100vw, 570px\" \/><\/a><\/figure>\n\n\n\n<p>5. Selamat, Anda telah berhasil konfigurasi remote database di layanan menggunakan aplikasi SQLyog di layanan RDS MySQL Alibaba Cloud .<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p><strong>Catatan:<\/strong><br \/>Karena faktor keamanan, Anda tidak dapat melakukan create, grant permission database langsung dari penggunaan remote database ke aplikasi pihak ke 3. Untuk create database, user, password, grant user harus dilakukan melalui console RDS MySQL Alibaba Cloud.<\/p><\/blockquote>\n\n\n\n<p>Demikian<em> <\/em>cara remote database RDS MySQL Alibaba Cloud Menggunakan SQLyog dari Rumahweb, semoga dapat membantu.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pada panduan ini, kami akan menjelaskan cara remote database RDS MySQL Alibaba menggunakan aplikasi SQLyog. Sebelum melakukan remote database, ada beberapa hal yang perlu Anda persiapkan. Berikut informasi selengkapnya. Apa saja yang perlu dipersiapkan? Pastikan Anda telah melakukan whitelist IP koneksi internet yang akan melakukan remote database. Untuk melakukan whitelist IP koneksi, Anda dapat mengikuti [&hellip;]<\/p>\n","protected":false},"author":331,"featured_media":21940,"comment_status":"closed","ping_status":"closed","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":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[1560],"tags":[1562,1561,807],"class_list":{"0":"post-21784","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-rds","8":"tag-alibaba-cloud","9":"tag-rds-mysql","10":"tag-remote-database"},"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/05\/banner-Remote-Database-RDS-MySQL-Alibaba-Cloud-Menggunakan-SQLyog-min.png","jetpack_shortlink":"https:\/\/wp.me\/p8n3G7-5Fm","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/21784","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\/331"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/comments?post=21784"}],"version-history":[{"count":0,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/21784\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media\/21940"}],"wp:attachment":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media?parent=21784"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/categories?post=21784"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/tags?post=21784"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}