{"id":3995,"date":"2010-10-28T04:24:16","date_gmt":"2010-10-27T20:24:16","guid":{"rendered":"http:\/\/inertz.com\/blog\/?p=3995"},"modified":"2010-10-28T04:28:15","modified_gmt":"2010-10-27T20:28:15","slug":"guna-remote-mysql-dalam-wordpress","status":"publish","type":"post","link":"https:\/\/inertz.com\/blog\/guna-remote-mysql-dalam-wordpress\/","title":{"rendered":"Guna remote MySQL dalam WordPress"},"content":{"rendered":"<p>Blog ini sekarang berada di US tetapi database masih lagi dalam hosting Malaysia.<\/p>\n<p>Kenapa begitu? Ini adalah kerana untuk update WordPress dan plugins, lebih pantas jika berada di server US.<\/p>\n<p>Perlu ada 2 hosting jika mahu setting seperti ini.<\/p>\n<p>Perkara yang perlu adalah;<\/p>\n<p>1. Setting &#8220;Remote Database Access Hosts&#8221; dalam panel database dan letakkan IP server yang mahu akses ke MySQL.<\/p>\n<p>2. Setting wp-config.php pada hosting yang lagi satu. Pastikan hostname adalah betul.<\/p>\n<p><a href=\"http:\/\/inertz.com\/blog\/wp-content\/uploads\/2010\/10\/remote_mysql1.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3996\" title=\"remote_mysql1\" src=\"http:\/\/inertz.com\/blog\/wp-content\/uploads\/2010\/10\/remote_mysql1.gif\" alt=\"\" width=\"469\" height=\"145\" srcset=\"https:\/\/inertz.com\/blog\/wp-content\/uploads\/2010\/10\/remote_mysql1.gif 469w, https:\/\/inertz.com\/blog\/wp-content\/uploads\/2010\/10\/remote_mysql1-300x92.gif 300w\" sizes=\"auto, (max-width: 469px) 100vw, 469px\" \/><\/a><a href=\"http:\/\/inertz.com\/blog\/wp-content\/uploads\/2010\/10\/remote_mysql2.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-3997\" title=\"remote_mysql2\" src=\"http:\/\/inertz.com\/blog\/wp-content\/uploads\/2010\/10\/remote_mysql2-620x245.gif\" alt=\"\" width=\"620\" height=\"245\" srcset=\"https:\/\/inertz.com\/blog\/wp-content\/uploads\/2010\/10\/remote_mysql2-620x245.gif 620w, https:\/\/inertz.com\/blog\/wp-content\/uploads\/2010\/10\/remote_mysql2-300x118.gif 300w, https:\/\/inertz.com\/blog\/wp-content\/uploads\/2010\/10\/remote_mysql2.gif 742w\" sizes=\"auto, (max-width: 620px) 100vw, 620px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/inertz.com\/blog\/wp-content\/uploads\/2010\/10\/remote_mysql3.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-3998\" title=\"remote_mysql3\" src=\"http:\/\/inertz.com\/blog\/wp-content\/uploads\/2010\/10\/remote_mysql3-620x174.gif\" alt=\"\" width=\"620\" height=\"174\" srcset=\"https:\/\/inertz.com\/blog\/wp-content\/uploads\/2010\/10\/remote_mysql3-620x174.gif 620w, https:\/\/inertz.com\/blog\/wp-content\/uploads\/2010\/10\/remote_mysql3-300x84.gif 300w, https:\/\/inertz.com\/blog\/wp-content\/uploads\/2010\/10\/remote_mysql3.gif 746w\" sizes=\"auto, (max-width: 620px) 100vw, 620px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Blog ini sekarang berada di US tetapi database masih lagi dalam hosting Malaysia. Kenapa begitu? Ini adalah kerana untuk update WordPress dan plugins, lebih pantas jika berada di server US. Perlu ada 2 hosting jika mahu setting seperti ini. Perkara yang perlu adalah; 1. Setting &#8220;Remote Database Access Hosts&#8221; dalam panel database dan letakkan IP [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[1569,3008,4270,4269,209],"class_list":["post-3995","post","type-post","status-publish","format-standard","hentry","tag-dalam","tag-guna","tag-mysql","tag-remote","tag-wordpress"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Guna remote MySQL dalam Wordpress - https:\/\/inertz.com\/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:\/\/inertz.com\/blog\/guna-remote-mysql-dalam-wordpress\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Guna remote MySQL dalam Wordpress - https:\/\/inertz.com\/blog\" \/>\n<meta property=\"og:description\" content=\"Blog ini sekarang berada di US tetapi database masih lagi dalam hosting Malaysia. Kenapa begitu? Ini adalah kerana untuk update WordPress dan plugins, lebih pantas jika berada di server US. Perlu ada 2 hosting jika mahu setting seperti ini. Perkara yang perlu adalah; 1. Setting &#8220;Remote Database Access Hosts&#8221; dalam panel database dan letakkan IP [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/inertz.com\/blog\/guna-remote-mysql-dalam-wordpress\/\" \/>\n<meta property=\"og:site_name\" content=\"https:\/\/inertz.com\/blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/inertz\" \/>\n<meta property=\"article:author\" content=\"https:\/\/web.facebook.com\/inertz\" \/>\n<meta property=\"article:published_time\" content=\"2010-10-27T20:24:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2010-10-27T20:28:15+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/inertz.com\/blog\/wp-content\/uploads\/2010\/10\/remote_mysql1.gif\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/inertz\" \/>\n<meta name=\"twitter:site\" content=\"@inertz\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Guna remote MySQL dalam Wordpress - https:\/\/inertz.com\/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:\/\/inertz.com\/blog\/guna-remote-mysql-dalam-wordpress\/","og_locale":"en_US","og_type":"article","og_title":"Guna remote MySQL dalam Wordpress - https:\/\/inertz.com\/blog","og_description":"Blog ini sekarang berada di US tetapi database masih lagi dalam hosting Malaysia. Kenapa begitu? Ini adalah kerana untuk update WordPress dan plugins, lebih pantas jika berada di server US. Perlu ada 2 hosting jika mahu setting seperti ini. Perkara yang perlu adalah; 1. Setting &#8220;Remote Database Access Hosts&#8221; dalam panel database dan letakkan IP [&hellip;]","og_url":"https:\/\/inertz.com\/blog\/guna-remote-mysql-dalam-wordpress\/","og_site_name":"https:\/\/inertz.com\/blog","article_publisher":"https:\/\/facebook.com\/inertz","article_author":"https:\/\/web.facebook.com\/inertz","article_published_time":"2010-10-27T20:24:16+00:00","article_modified_time":"2010-10-27T20:28:15+00:00","og_image":[{"url":"http:\/\/inertz.com\/blog\/wp-content\/uploads\/2010\/10\/remote_mysql1.gif","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/inertz","twitter_site":"@inertz","twitter_misc":{"Written by":"admin"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/inertz.com\/blog\/guna-remote-mysql-dalam-wordpress\/#article","isPartOf":{"@id":"https:\/\/inertz.com\/blog\/guna-remote-mysql-dalam-wordpress\/"},"author":{"name":"admin","@id":"https:\/\/inertz.com\/blog\/#\/schema\/person\/d27d47b78673d67d4de15a57cd609ed9"},"headline":"Guna remote MySQL dalam WordPress","datePublished":"2010-10-27T20:24:16+00:00","dateModified":"2010-10-27T20:28:15+00:00","mainEntityOfPage":{"@id":"https:\/\/inertz.com\/blog\/guna-remote-mysql-dalam-wordpress\/"},"wordCount":76,"commentCount":1,"publisher":{"@id":"https:\/\/inertz.com\/blog\/#organization"},"image":{"@id":"https:\/\/inertz.com\/blog\/guna-remote-mysql-dalam-wordpress\/#primaryimage"},"thumbnailUrl":"http:\/\/inertz.com\/blog\/wp-content\/uploads\/2010\/10\/remote_mysql1.gif","keywords":["dalam","guna","mysql","remote","wordpress"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/inertz.com\/blog\/guna-remote-mysql-dalam-wordpress\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/inertz.com\/blog\/guna-remote-mysql-dalam-wordpress\/","url":"https:\/\/inertz.com\/blog\/guna-remote-mysql-dalam-wordpress\/","name":"Guna remote MySQL dalam Wordpress - https:\/\/inertz.com\/blog","isPartOf":{"@id":"https:\/\/inertz.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/inertz.com\/blog\/guna-remote-mysql-dalam-wordpress\/#primaryimage"},"image":{"@id":"https:\/\/inertz.com\/blog\/guna-remote-mysql-dalam-wordpress\/#primaryimage"},"thumbnailUrl":"http:\/\/inertz.com\/blog\/wp-content\/uploads\/2010\/10\/remote_mysql1.gif","datePublished":"2010-10-27T20:24:16+00:00","dateModified":"2010-10-27T20:28:15+00:00","breadcrumb":{"@id":"https:\/\/inertz.com\/blog\/guna-remote-mysql-dalam-wordpress\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/inertz.com\/blog\/guna-remote-mysql-dalam-wordpress\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/inertz.com\/blog\/guna-remote-mysql-dalam-wordpress\/#primaryimage","url":"https:\/\/inertz.com\/blog\/wp-content\/uploads\/2010\/10\/remote_mysql1.gif","contentUrl":"https:\/\/inertz.com\/blog\/wp-content\/uploads\/2010\/10\/remote_mysql1.gif","width":"469","height":"145"},{"@type":"BreadcrumbList","@id":"https:\/\/inertz.com\/blog\/guna-remote-mysql-dalam-wordpress\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/inertz.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Guna remote MySQL dalam WordPress"}]},{"@type":"WebSite","@id":"https:\/\/inertz.com\/blog\/#website","url":"https:\/\/inertz.com\/blog\/","name":"https:\/\/inertz.com\/blog","description":"19 tahun blog belum pupus","publisher":{"@id":"https:\/\/inertz.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/inertz.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/inertz.com\/blog\/#organization","name":"https:\/\/inertz.com\/blog","url":"https:\/\/inertz.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/inertz.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/inertz.com\/blog\/wp-content\/uploads\/2021\/05\/server.png","contentUrl":"https:\/\/inertz.com\/blog\/wp-content\/uploads\/2021\/05\/server.png","width":512,"height":512,"caption":"https:\/\/inertz.com\/blog"},"image":{"@id":"https:\/\/inertz.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/facebook.com\/inertz","https:\/\/x.com\/inertz"]},{"@type":"Person","@id":"https:\/\/inertz.com\/blog\/#\/schema\/person\/d27d47b78673d67d4de15a57cd609ed9","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/inertz.com\/blog\/wp-content\/litespeed\/avatar\/9cb42e3829b77fd9cc6fefd707ea0f1a.jpg?ver=1780245170","url":"https:\/\/inertz.com\/blog\/wp-content\/litespeed\/avatar\/9cb42e3829b77fd9cc6fefd707ea0f1a.jpg?ver=1780245170","contentUrl":"https:\/\/inertz.com\/blog\/wp-content\/litespeed\/avatar\/9cb42e3829b77fd9cc6fefd707ea0f1a.jpg?ver=1780245170","caption":"admin"},"sameAs":["http:\/\/inertz.com\/blog","https:\/\/web.facebook.com\/inertz","https:\/\/www.instagram.com\/inertz\/","https:\/\/www.linkedin.com\/in\/inertz\/","https:\/\/x.com\/https:\/\/twitter.com\/inertz"],"url":"https:\/\/inertz.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/inertz.com\/blog\/wp-json\/wp\/v2\/posts\/3995","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/inertz.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/inertz.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/inertz.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/inertz.com\/blog\/wp-json\/wp\/v2\/comments?post=3995"}],"version-history":[{"count":0,"href":"https:\/\/inertz.com\/blog\/wp-json\/wp\/v2\/posts\/3995\/revisions"}],"wp:attachment":[{"href":"https:\/\/inertz.com\/blog\/wp-json\/wp\/v2\/media?parent=3995"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/inertz.com\/blog\/wp-json\/wp\/v2\/categories?post=3995"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/inertz.com\/blog\/wp-json\/wp\/v2\/tags?post=3995"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}