{"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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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":{"footnotes":""},"categories":[1560],"tags":[1562,1561,807],"class_list":["post-21784","post","type-post","status-publish","format-standard","has-post-thumbnail","category-rds","tag-alibaba-cloud","tag-rds-mysql","tag-remote-database"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.9 - aioseo.com -->\n\t<meta name=\"description\" content=\"Selain bisa dikelola langsung melalui panel Alibaba, RDS MySQL Alibaba Cloud juga bisa dikelola melalui remote database. Berikut adalah langkah-langkah remote\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Benny Eko Priharyanto\"\/>\n\t<meta name=\"google-site-verification\" content=\"wPstUwU5246IbK_1PqwGrc1LoSDnB-9rPbcT8_vSNgQ\" \/>\n\t<meta name=\"keywords\" content=\"remote database mysql,cara remote database,cara remote database mysql,remote database rds,remote database rds mysql,remote database mysql rds,alibaba cloud,rds mysql,remote database\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.rumahweb.com\/journal\/remote-database-rds-mysql-alibaba-cloud-menggunakan-sqlyog\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.9\" \/>\n\t\t<meta property=\"og:locale\" content=\"id_Id\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Rumahweb Journal \u2013 News, Article, and Tutorial of Web Dev\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Remote Database RDS MySQL Alibaba Cloud Menggunakan SQLyog\" \/>\n\t\t<meta property=\"og:description\" content=\"Selain bisa dikelola langsung melalui panel Alibaba, RDS MySQL Alibaba Cloud juga bisa dikelola melalui remote database. Berikut adalah langkah-langkah remote\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.rumahweb.com\/journal\/remote-database-rds-mysql-alibaba-cloud-menggunakan-sqlyog\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/05\/banner-Remote-Database-RDS-MySQL-Alibaba-Cloud-Menggunakan-SQLyog-min.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/05\/banner-Remote-Database-RDS-MySQL-Alibaba-Cloud-Menggunakan-SQLyog-min.png\" \/>\n\t\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2021-05-27T06:21:51+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2021-10-01T05:54:45+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/RumahwebIndonesia\/\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@rumahwebtweet\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Remote Database RDS MySQL Alibaba Cloud Menggunakan SQLyog\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Selain bisa dikelola langsung melalui panel Alibaba, RDS MySQL Alibaba Cloud juga bisa dikelola melalui remote database. Berikut adalah langkah-langkah remote\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@rumahwebtweet\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/05\/banner-Remote-Database-RDS-MySQL-Alibaba-Cloud-Menggunakan-SQLyog-min.png\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Remote Database RDS MySQL Alibaba Cloud Menggunakan SQLyog","description":"Selain bisa dikelola langsung melalui panel Alibaba, RDS MySQL Alibaba Cloud juga bisa dikelola melalui remote database. Berikut adalah langkah-langkah remote","canonical_url":"https:\/\/www.rumahweb.com\/journal\/remote-database-rds-mysql-alibaba-cloud-menggunakan-sqlyog\/","robots":"max-image-preview:large","keywords":"remote database mysql,cara remote database,cara remote database mysql,remote database rds,remote database rds mysql,remote database mysql rds,alibaba cloud,rds mysql,remote database","webmasterTools":{"google-site-verification":"wPstUwU5246IbK_1PqwGrc1LoSDnB-9rPbcT8_vSNgQ","miscellaneous":""},"schema":null,"og:locale":"id_Id","og:site_name":"Rumahweb Journal \u2013 News, Article, and Tutorial of Web Dev","og:type":"article","og:title":"Remote Database RDS MySQL Alibaba Cloud Menggunakan SQLyog","og:description":"Selain bisa dikelola langsung melalui panel Alibaba, RDS MySQL Alibaba Cloud juga bisa dikelola melalui remote database. Berikut adalah langkah-langkah remote","og:url":"https:\/\/www.rumahweb.com\/journal\/remote-database-rds-mysql-alibaba-cloud-menggunakan-sqlyog\/","og:image":"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/05\/banner-Remote-Database-RDS-MySQL-Alibaba-Cloud-Menggunakan-SQLyog-min.png","og:image:secure_url":"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/05\/banner-Remote-Database-RDS-MySQL-Alibaba-Cloud-Menggunakan-SQLyog-min.png","og:image:width":1200,"og:image:height":630,"article:published_time":"2021-05-27T06:21:51+00:00","article:modified_time":"2021-10-01T05:54:45+00:00","article:publisher":"https:\/\/www.facebook.com\/RumahwebIndonesia\/","twitter:card":"summary_large_image","twitter:site":"@rumahwebtweet","twitter:title":"Remote Database RDS MySQL Alibaba Cloud Menggunakan SQLyog","twitter:description":"Selain bisa dikelola langsung melalui panel Alibaba, RDS MySQL Alibaba Cloud juga bisa dikelola melalui remote database. Berikut adalah langkah-langkah remote","twitter:creator":"@rumahwebtweet","twitter:image":"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/05\/banner-Remote-Database-RDS-MySQL-Alibaba-Cloud-Menggunakan-SQLyog-min.png"},"aioseo_meta_data":{"post_id":"21784","title":null,"description":"Selain bisa dikelola langsung melalui panel Alibaba, RDS MySQL Alibaba Cloud juga bisa dikelola melalui remote database. Berikut adalah langkah-langkah&nbsp;remote","keywords":[{"label":"remote database mysql","value":"remote database mysql"},{"label":" cara remote database","value":" cara remote database"},{"label":" cara remote database mysql","value":" cara remote database mysql"},{"label":" remote database rds","value":" remote database rds"},{"label":" remote database rds mysql","value":" remote database rds mysql"},{"label":"remote database mysql rds","value":"remote database mysql rds"}],"keyphrases":{"focus":{"keyphrase":"remote database","score":100,"analysis":{"keyphraseInTitle":{"title":"Focus Keyphrase in SEO title","description":"Focus Keyphrase found in SEO title.","score":9,"maxScore":9,"error":0},"keyphraseInDescription":{"title":"Focus keyphrase in meta description","description":"Focus keyphrase found in meta description.","score":9,"maxScore":9,"error":0},"keyphraseInURL":{"title":"Focus Keyphrase in URL","description":"Focus Keyphrase used in the URL.","score":5,"maxScore":5,"error":0},"keyphraseLength":{"title":"Focus keyphrase length","description":"Good job!","score":9,"maxScore":9,"error":0,"length":2},"keyphraseInIntroduction":{"title":"Focus keyphrase in introduction","description":"Your Focus keyphrase appears in the first paragraph. Well done!","score":9,"maxScore":9,"error":0},"keyphraseInSubHeadings":{"title":"Focus Keyphrase in Subheadings","description":"Your H2 and H3 subheadings reflects the topic of your copy. Good job!","score":9,"maxScore":9,"error":0},"keyphraseInImageAlt":{"title":"Focus keyphrase in image alt attributes","description":"Focus keyphrase found in image alt attribute(s).","score":9,"maxScore":9,"error":0}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":[],"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[],"defaultGraph":"Article","defaultPostTypeGraph":""},"schema_type":"default","schema_type_options":"{\"article\":{\"articleType\":\"BlogPosting\"},\"course\":{\"name\":\"\",\"description\":\"\",\"provider\":\"\"},\"faq\":{\"pages\":[]},\"product\":{\"reviews\":[]},\"recipe\":{\"ingredients\":[],\"instructions\":[],\"keywords\":[]},\"software\":{\"reviews\":[],\"operatingSystems\":[]},\"webPage\":{\"webPageType\":\"WebPage\"}}","pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","location":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2021-05-25 09:44:37","updated":"2026-04-19 04:08:12","seo_analyzer_scan_date":null},"_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}]}}