{"id":13683,"date":"2024-01-04T17:03:10","date_gmt":"2024-01-04T10:03:10","guid":{"rendered":"https:\/\/www.rumahweb.com\/journal\/?p=13683"},"modified":"2024-01-04T17:07:28","modified_gmt":"2024-01-04T10:07:28","slug":"cara-mengubah-domain-di-wordpress","status":"publish","type":"post","link":"https:\/\/www.rumahweb.com\/journal\/cara-mengubah-domain-di-wordpress\/","title":{"rendered":"Cara Mengubah Domain di WordPress Melalui phpMyAdmin"},"content":{"rendered":"\n<p>Terkadang, kita perlu mengubah nama domain pada website karena satu atau beberapa alasan. Bagi Anda yang telah menggunakan <a href=\"https:\/\/blog.rumahweb.com\/wordpress-adalah\/\" target=\"_blank\" rel=\"noopener\" title=\"wordpress adalah\">WordPress<\/a> dan ingin mengubah nama domainnya, simak panduan berikut untuk mengetahui cara mengubah domain di WordPress melalui phpMyAdmin. <\/p>\n\n\n\n\n\n<h2 class=\"wp-block-heading\">Mengapa perlu mengubah nama domain di WordPress?<\/h2>\n\n\n\n<p>Ada beberapa alasan yang mungkin melatarbelakangi Anda untuk mengubah nama domain pada website. Berikut kami rangkumkan beberapa alasan yang sering terjadi pada pelanggan Rumahweb. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1. Rebranding<\/h3>\n\n\n\n<p>Rebranding adalah alasan kuat beberapa pelanggan Rumahweb untuk mengubah nama domain mereka.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. Baru mengonlinekan website dari localhost<\/h3>\n\n\n\n<p>Jika sebelumnya Anda membuat website WordPress di localhost, maka secara default URL website anda adalah localhost\/namaweb. Namun setelah Anda menguploadnya ke hosting, Anda perlu mengubah URL tersebut menjadi nama domain Anda sendiri. <\/p>\n\n\n\n<p>Pelajari cara upload website WordPress dari localhost ke cPanel hosting pada panduan berikut : <a href=\"https:\/\/www.rumahweb.com\/journal\/upload-wordpress-step-by-step-ke-server-hosting\/\">Upload WordPress ke Hosting<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3. SEO<\/h3>\n\n\n\n<p>Ada beberapa pelanggan Rumahweb yang mengubah nama domain pada WordPress mereka karena alasan SEO. Contohnya seperti domain lama mereka di banned oleh Google Adsense karena melanggar TOS, di Deindex oleh Google, bahkan hingga di block oleh Internet Positif Kominfo.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Hal yang perlu disiapkan<\/h2>\n\n\n\n<p>Berikut adalah beberapa hal dasar yang perlu Anda siapkan untuk mengubah nama domain di WordPress melalui phpMyAdmin.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1. Mengetahui Nama Database Dan Prefix Table<\/h3>\n\n\n\n<p>Untuk mengetahui nama database bisa melalui file wp-config.php yang terletak di directory root website Anda. Pada domain utama, biasanya file ini terletak di \/public_html. <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Klik kanan pada file wp-config.php, lalu klik view untuk melihat detailnya. Cari baris yang diawali &#8220;DB_NAME&#8221;<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"762\" height=\"103\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_1.png\" alt=\"mengetahui nama database di wordpress\" class=\"wp-image-44603\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_1.png 762w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_1-300x41.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_1-370x50.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_1-270x36.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_1-570x77.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_1-740x100.png 740w\" sizes=\"auto, (max-width: 762px) 100vw, 762px\" \/><\/a><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Cari baru yang diawali &#8220;$table_prefix&#8221;<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_2.png\"><img loading=\"lazy\" decoding=\"async\" width=\"765\" height=\"178\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_2.png\" alt=\"mengetahui prefix database wordpress\" class=\"wp-image-44605\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_2.png 765w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_2-300x70.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_2-370x86.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_2-270x63.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_2-570x133.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_2-740x172.png 740w\" sizes=\"auto, (max-width: 765px) 100vw, 765px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">2. Backup database<\/h3>\n\n\n\n<p>Sebelum melakukan perubahan nama domain di WordPress, ada baiknya Anda melakukan backup database terlebih dahulu untuk menghindari kehilangan data di Database ketika proses perubahan nama database tersebut. <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Login ke cPanel hosting Anda.<\/li>\n\n\n\n<li>Cari menu <strong>phpMyAdmin <\/strong>pada kolom Databases seperti pada gambar berikut.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_3.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"592\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_3-1024x592.png\" alt=\"phpmyadmin di cpanel\" class=\"wp-image-44608\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_3-1024x592.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_3-300x173.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_3-768x444.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_3-370x214.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_3-270x156.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_3-570x329.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_3-740x428.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_3.png 1258w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption class=\"wp-element-caption\">pada cPanel<\/figcaption><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Pilih database yang Anda gunakan, lalu klik menu Export. Unduhlah database ke local komputer Anda. <\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">3. Nama domain lama dan baru<\/h3>\n\n\n\n<p>Nama domain lama adalah nama domain yang saat ini di setting sebagai default URL pada website Anda. Sedangkan nama domain baru adalah nama domain yang akan anda gunakan. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Cara mengubah domain di WordPress<\/h2>\n\n\n\n<p>Berikut adalah cara mengubah nama domain di WordPress melalui phpMyAdmin. <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Login ke cPanel hosting Anda. <\/li>\n\n\n\n<li>Klik menu phpMyAdmin, lalu pilih database website WordPress yang akan di ubah.<\/li>\n\n\n\n<li>Klik tanda plus (+) di depan nama database tersebut.<\/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\/2024\/01\/phpmyadmin_5.png\"><img loading=\"lazy\" decoding=\"async\" width=\"357\" height=\"529\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_5.png\" alt=\"Tabel database wordpress\" class=\"wp-image-44613\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_5.png 357w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_5-202x300.png 202w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_5-270x400.png 270w\" sizes=\"auto, (max-width: 357px) 100vw, 357px\" \/><\/a><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\" start=\"4\">\n<li>Cari table <strong>prefix_options<\/strong>, lalu pada <strong>siteurl <\/strong>dan <strong>home<\/strong> silahkan ubah nama domain Anda. <\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_6.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"511\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_6-1024x511.png\" alt=\"mengubah domain di wordpress\" class=\"wp-image-44614\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_6-1024x511.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_6-300x150.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_6-768x383.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_6-370x185.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_6-270x135.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_6-570x284.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_6-740x369.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2024\/01\/phpmyadmin_6.png 1102w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"5\">\n<li>Klik menu SQL pada phpMyAdmin, dan jalankan perintah berikut: <\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>UPDATE *prefix*_posts SET guid = replace(guid, 'urllama.com', 'urlbaru.com');\nUPDATE *prefix*_posts SET post_content = replace(post_content, 'urllama.com', 'urlbaru.com');\nUPDATE *prefix*_postmeta SET meta_value = replace(meta_value, 'urllama.com', 'urlbaru.com');<\/code><\/pre>\n\n\n\n<p><strong>Keterangan<\/strong>: <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ubah *prefix* sesuai yang ada di wp_config.php.<\/li>\n\n\n\n<li>Ubah urllama.com dan urlbaru.com sesuai perubahan yang ingin Anda lakukan.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"351\" height=\"54\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/10\/wordpress_update_domain6.png\" alt=\"\" class=\"wp-image-13694\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/10\/wordpress_update_domain6.png 351w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/10\/wordpress_update_domain6-300x46.png 300w\" sizes=\"auto, (max-width: 351px) 100vw, 351px\" \/><\/figure>\n<\/div>\n\n\n<p>Jika query benar, maka akan muncul centang hijau seperti screenshoot diatas.<\/p>\n\n\n\n<p>Sampai tahap ini, cara mengubah domain di WordPress telah selesai. Selanjutnya, Anda dapat mengakses nama domain yang baru untuk memastikan perubahan telah berhasil. <\/p>\n\n\n\n<p>Demikian artikel kami tentang <span style=\"text-decoration: underline;\">cara mengubah domain di WordPress<\/span>, semoga bermanfaat.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Terkadang, kita perlu mengubah nama domain pada website karena satu atau beberapa alasan. Bagi Anda yang telah menggunakan WordPress dan ingin mengubah nama domainnya, simak panduan berikut untuk mengetahui cara mengubah domain di WordPress melalui phpMyAdmin. Mengapa perlu mengubah nama domain di WordPress? Ada beberapa alasan yang mungkin melatarbelakangi Anda untuk mengubah nama domain pada [&hellip;]<\/p>\n","protected":false},"author":323,"featured_media":13749,"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":[463],"tags":[36,1000,14],"class_list":{"0":"post-13683","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-wordpress","8":"tag-domain","9":"tag-tutorial-wordpress","10":"tag-wordpress"},"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/10\/Mengubah-Domain-di-CMS-WordPress-Melalui-PhpMyAdmin.jpg","jetpack_shortlink":"https:\/\/wp.me\/p8n3G7-3yH","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/13683","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=13683"}],"version-history":[{"count":0,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/13683\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media\/13749"}],"wp:attachment":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media?parent=13683"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/categories?post=13683"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/tags?post=13683"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}