{"id":11091,"date":"2019-01-28T17:02:17","date_gmt":"2019-01-28T10:02:17","guid":{"rendered":"https:\/\/www.rumahweb.com\/journal\/?p=11091"},"modified":"2019-01-28T21:28:41","modified_gmt":"2019-01-28T14:28:41","slug":"cara-remote-database-pada-vps-plesk","status":"publish","type":"post","link":"https:\/\/www.rumahweb.com\/journal\/cara-remote-database-pada-vps-plesk\/","title":{"rendered":"Cara Remote Database Pada VPS Plesk"},"content":{"rendered":"\n<p>Pada artikel kali ini, <a href=\"https:\/\/rumahweb.com\/\">Rumahweb<\/a> akan membahas cara melakukan <strong>remote database VPS Plesk Panel<\/strong>.  Sebelum melakukan remote database, yang perlu dilakukan pertama kali adalah cek setting firewall dan port SQL pada VPS Anda. <\/p>\n\n\n\n<p>Supaya lebih jelas, silahkan menyimak langkah-langkah cara setting <em>remote database<\/em><strong> <\/strong>di VPS Plesk Panel berikut ini;<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>1. Silakan login ke root Plesk Panel melalui https:\/\/ipvps:8443.<br \/>2. Kemudian pastikan firewall akses MySql (dbremote) dalam keadaan allow. Anda dapat mengecekannya dari menu &#8220;Tools &amp; Settings&#8221; &gt; &#8220;Firewall&#8221; .<br \/><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"482\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/01\/remote-3-1024x482.png\" alt=\"\" class=\"wp-image-11096\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/01\/remote-3-1024x482.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/01\/remote-3-300x141.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/01\/remote-3-768x362.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/01\/remote-3.png 1353w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>3. Login ke SSH VPS, kemudian edit file \/etc\/my.cnf.<br \/>4. Pada bagian &#8220;bind-address = ::ffff:127.0.0.1&#8221; silakan di edit dengan memberi tanda #, sehingga menjadi &#8220;#bind-address = ::ffff:127.0.0.1&#8221;<br \/><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"992\" height=\"603\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/01\/remote2.png\" alt=\"\" class=\"wp-image-11097\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/01\/remote2.png 992w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/01\/remote2-300x182.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/01\/remote2-768x467.png 768w\" sizes=\"auto, (max-width: 992px) 100vw, 992px\" \/><\/figure>\n\n\n\n<p>5.  Restart MySQL dengan perintah service mysql restart.<br \/>6. Terakhir, tes Remote database dengan perintah ( mysql -u rumahweb -h 103.123.123.123 -p -D nama_database )<br \/><br \/><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"741\" height=\"204\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/01\/remote3-1.png\" alt=\"\" class=\"wp-image-11099\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/01\/remote3-1.png 741w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/01\/remote3-1-300x83.png 300w\" sizes=\"auto, (max-width: 741px) 100vw, 741px\" \/><\/figure>\n\n\n\n<p>Demikian panduan <u>cara remote database VPS Plesk Panel<\/u> dari Rumahweb Indonesia. Apabila Anda ada pertanyaan terkait remote database ini, silakan menghubungi support teknis untuk dibantu lebih lanjut. Terimakasih \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pada artikel kali ini, Rumahweb akan membahas cara melakukan remote database VPS Plesk Panel. Sebelum melakukan remote database, yang perlu dilakukan pertama kali adalah cek setting firewall dan port SQL pada VPS Anda. Supaya lebih jelas, silahkan menyimak langkah-langkah cara setting remote database di VPS Plesk Panel berikut ini;<\/p>\n","protected":false},"author":323,"featured_media":11279,"comment_status":"closed","ping_status":"open","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":[196],"tags":[232,807,809,810],"class_list":{"0":"post-11091","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-plesk-panel","8":"tag-plesk-panel","9":"tag-remote-database","10":"tag-setting-database","11":"tag-vps-plesk"},"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/01\/banner-artikel-Cara-Remote-Database-VPS-Plesk-Panel.png","jetpack_shortlink":"https:\/\/wp.me\/p8n3G7-2ST","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/11091","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\/323"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/comments?post=11091"}],"version-history":[{"count":0,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/11091\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media\/11279"}],"wp:attachment":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media?parent=11091"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/categories?post=11091"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/tags?post=11091"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}