{"id":45648,"date":"2025-09-08T17:12:23","date_gmt":"2025-09-08T10:12:23","guid":{"rendered":"\/id\/tutorial\/?p=45648"},"modified":"2025-12-18T23:26:39","modified_gmt":"2025-12-18T16:26:39","slug":"cara-mengubah-url-wordpress-phpmyadmin","status":"publish","type":"post","link":"\/id\/tutorial\/cara-mengubah-url-wordpress-phpmyadmin\/","title":{"rendered":"Cara mengubah URL WordPress di database MySQL menggunakan phpMyAdmin"},"content":{"rendered":"<p class=\"wp-block-paragraph\">WordPress menyimpan semua data website Anda di database MySQL, termasuk URL halamannya. Jadi, kalau perlu mengganti URL WordPress, Anda juga harus melakukan perubahan langsung di MySQL.<\/p><p class=\"wp-block-paragraph\">Sayangnya, proses ini bisa cukup merepotkan ketika Anda perlu mengubah domain dan URL website. Tidak hanya alamat website yang akan berubah, tapi semua internal link yang tersimpan di dalam database juga akan rusak.<\/p><p class=\"wp-block-paragraph\">Untungnya, ada cara yang cukup mudah untuk melakukannya. Di artikel ini, kami akan menjelaskan cara mengubah URL WordPress di database MySQL menggunakan phpMyAdmin, memastikan semua link ikut diganti tanpa masalah. Yuk, lanjutkan membaca!<\/p><h2 class=\"wp-block-heading\" id=\"h-1-temukan-nama-database-mysql-wordpress\">1. Temukan nama database MySQL WordPress<\/h2><p class=\"wp-block-paragraph\">Langkah ini bisa dilewati kalau Anda hanya memiliki satu database <a href=\"\/id\/tutorial\/apa-itu-mysql\/\">MySQL<\/a>. Namun, kalau ada beberapa database dan Anda tidak yakin mana yang terhubung dengan WordPress, ikuti langkah-langkah di bagian ini.<\/p><p class=\"wp-block-paragraph\">WordPress menyimpan nama database MySQL beserta kredensialnya di file <a href=\"\/id\/tutorial\/wp-config-php\/\">wp-config.php<\/a>, yang bisa Anda temukan di direktori root penginstalan WordPress:<\/p><ol class=\"wp-block-list\">\n<li>Masuk ke hPanel, lalu buka <strong>Website<\/strong> &rarr; <strong>Daftar website<\/strong>.<\/li>\n\n\n\n<li>Pilih <strong>Dashboard<\/strong> di samping website Anda, lalu buka <a href=\"\/id\/tutorial\/cara-menggunakan-file-manager-hostinger\/\">File Manager<\/a>.<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"6a616eca098f8\"}' data-wp-interactive=\"core\/image\" data-wp-key=\"6a616eca098f8\" class=\"aligncenter size-large wp-lightbox-container\"><img decoding=\"async\" width=\"2026\" height=\"1036\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2021\/05\/memilih-file-manager-hpanel.png\/w=1024,h=1024,fit=scale-down\" alt=\"tampilan memilih menu file manager hostinger di halaman dashboard hpanel\" class=\"wp-image-43914\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2021\/05\/memilih-file-manager-hpanel.png\/w=2026,fit=scale-down 2026w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2021\/05\/memilih-file-manager-hpanel.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2021\/05\/memilih-file-manager-hpanel.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2021\/05\/memilih-file-manager-hpanel.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2021\/05\/memilih-file-manager-hpanel.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 2026px) 100vw, 2026px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" data-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on--click=\"actions.showLightbox\" data-wp-style--right=\"state.thisImage.buttonRight\" data-wp-style--top=\"state.thisImage.buttonTop\">\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\"><\/path>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div><ol start=\"3\" class=\"wp-block-list\">\n<li>Cari dan buka file <strong>wp-config.php<\/strong>, lalu temukan baris dengan parameter <strong>DB_NAME<\/strong>. Nilai yang tercantum di baris ini adalah nama database Anda. Misalnya, nama database MySQL kami adalah sebagai berikut:<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"6a616eca0a7af\"}' data-wp-interactive=\"core\/image\" data-wp-key=\"6a616eca0a7af\" class=\"aligncenter size-full is-resized wp-lightbox-container\"><img decoding=\"async\" width=\"954\" height=\"632\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2025\/09\/nama-database.png\/public\" alt=\"Tampilan nama database di file wp-config.php\" class=\"wp-image-45653\" style=\"width:794px;height:auto\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2025\/09\/nama-database.png\/w=954,fit=scale-down 954w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2025\/09\/nama-database.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2025\/09\/nama-database.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2025\/09\/nama-database.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 954px) 100vw, 954px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" data-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on--click=\"actions.showLightbox\" data-wp-style--right=\"state.thisImage.buttonRight\" data-wp-style--top=\"state.thisImage.buttonTop\">\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\"><\/path>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"\/id\/wordpress-hosting\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" width=\"1024\" height=\"300\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2024\/06\/ID-New-WP_in-text-banner.png\/public\" alt=\"\" class=\"wp-image-37614\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2024\/06\/ID-New-WP_in-text-banner.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2024\/06\/ID-New-WP_in-text-banner.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2024\/06\/ID-New-WP_in-text-banner.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2024\/06\/ID-New-WP_in-text-banner.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n<\/div><h2 class=\"wp-block-heading\" id=\"h-2-ganti-url-wordpress-di-database-mysql\">2. Ganti URL WordPress di database MySQL<\/h2><p class=\"wp-block-paragraph\">Setelah mengetahui nama database, lanjutkan dengan mengganti URL melalui phpMyAdmin.<\/p><ol class=\"wp-block-list\">\n<li><a href=\"\/id\/tutorial\/cara-masuk-ke-phpmyadmin\/\">Buka phpMyAdmin<\/a> dari control panel hosting Anda.<\/li>\n\n\n\n<li>Di panel kiri, pilih database yang terhubung dengan WordPress, lalu klik tab <strong>SQL<\/strong>.<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"6a616eca0c5d0\"}' data-wp-interactive=\"core\/image\" data-wp-key=\"6a616eca0c5d0\" class=\"aligncenter size-full wp-lightbox-container\"><img decoding=\"async\" width=\"1024\" height=\"325\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2025\/09\/nama-database-phpmyadmin.png\/public\" alt=\"Tampilan tab SQL di phpMyAdmin dengan nama database yang dipilih di sidebar kiri\" class=\"wp-image-45654\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2025\/09\/nama-database-phpmyadmin.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2025\/09\/nama-database-phpmyadmin.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2025\/09\/nama-database-phpmyadmin.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2025\/09\/nama-database-phpmyadmin.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" data-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on--click=\"actions.showLightbox\" data-wp-style--right=\"state.thisImage.buttonRight\" data-wp-style--top=\"state.thisImage.buttonTop\">\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\"><\/path>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div><ol start=\"3\" class=\"wp-block-list\">\n<li>Masukkan kueri SQL berikut ini:<\/li>\n<\/ol><pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">UPDATE wp_options SET option_value = replace(option_value, 'oldurl.com', 'newurl.com') WHERE option_name = 'home' OR option_name = 'siteurl'; \nUPDATE wp_posts SET guid = replace(guid, 'oldurl.com','newurl.com'); \nUPDATE wp_posts SET post_content = replace(post_content, 'oldurl.com', 'newurl.com'); \nUPDATE wp_postmeta SET meta_value = replace(meta_value, 'oldurl.com','newurl.com');<\/pre><p class=\"wp-block-paragraph\">Ganti <strong>oldurl.com<\/strong> dengan URL lama website Anda, dan <strong>newurl.com<\/strong> dengan alamat yang baru.<\/p><p>\n\n\n<div class=\"announcement-block announcement-block--important\">\n            <span class=\"announcement-block__heading\">\n                <svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                    <path fill-rule=\"evenodd\" clip-rule=\"evenodd\"\n                          d=\"M12 22.5C17.799 22.5 22.5 17.799 22.5 12C22.5 6.20101 17.799 1.5 12 1.5C6.20101 1.5 1.5 6.20101 1.5 12C1.5 17.799 6.20101 22.5 12 22.5ZM13.637 7.65198C13.637 6.74791 12.9041 6.01501 12 6.01501C11.0959 6.01501 10.363 6.74791 10.363 7.65198C10.5335 9.53749 10.875 13.383 10.875 13.383C10.875 14.0043 11.3787 14.508 12 14.508C12.6213 14.508 13.125 14.0043 13.125 13.383V13.38L13.637 7.65198ZM11.9927 15.714C11.3714 15.714 10.8677 16.2177 10.8677 16.839C10.8677 17.4603 11.3714 17.964 11.9927 17.964H12.0073C12.6286 17.964 13.1323 17.4603 13.1323 16.839C13.1323 16.2177 12.6286 15.714 12.0073 15.714H11.9927Z\"\n                          fill=\"#FEA419\"\/>\n                <\/svg>\n                Important\n            <\/span>\n            <p class=\"announcement-block__content\">\n                <strong>Penting!<\/strong> Nama tabel di database Anda mungkin tidak diawali dengan <strong>wp_<\/strong>. Periksa prefix tabel yang benar di phpMyAdmin (panel kiri), lalu sesuaikan query di atas.\n            <\/p><\/div>\n\n\n\n<\/p><p class=\"wp-block-paragraph\">Setelah itu, tekan <strong>Go<\/strong>. Kalau berhasil, Anda akan melihat pesan sukses beserta jumlah baris yang diubah. Jumlah ini bisa berbeda-beda tergantung pada ukuran website WordPress Anda.<\/p><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"6a616eca0d708\"}' data-wp-interactive=\"core\/image\" data-wp-key=\"6a616eca0d708\" class=\"aligncenter size-large wp-lightbox-container\"><img decoding=\"async\" width=\"1613\" height=\"612\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2025\/09\/notifikasi-berhasil-ganti-url.png\/w=1024,h=1024,fit=scale-down\" alt=\"Tampilan pesan sukses setelah mengganti url WordPress di phpMyAdmin\" class=\"wp-image-45656\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2025\/09\/notifikasi-berhasil-ganti-url.png\/w=1613,fit=scale-down 1613w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2025\/09\/notifikasi-berhasil-ganti-url.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2025\/09\/notifikasi-berhasil-ganti-url.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2025\/09\/notifikasi-berhasil-ganti-url.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2025\/09\/notifikasi-berhasil-ganti-url.png\/w=768,fit=scale-down 768w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2025\/09\/notifikasi-berhasil-ganti-url.png\/w=1536,fit=scale-down 1536w\" sizes=\"(max-width: 1613px) 100vw, 1613px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" data-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on--click=\"actions.showLightbox\" data-wp-style--right=\"state.thisImage.buttonRight\" data-wp-style--top=\"state.thisImage.buttonTop\">\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\"><\/path>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div><p class=\"wp-block-paragraph\">Terakhir, lakukan verifikasi dengan membuka tabel <strong>wp_options<\/strong>. Pastikan nilai <strong>option_value<\/strong> pada <strong>siteurl<\/strong> dan <strong>home<\/strong> sudah menampilkan URL yang baru.<\/p><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"6a616eca0e467\"}' data-wp-interactive=\"core\/image\" data-wp-key=\"6a616eca0e467\" class=\"aligncenter size-large wp-lightbox-container\"><img decoding=\"async\" width=\"1316\" height=\"626\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2025\/09\/url-baru-di-tabel-wp-options.png\/w=1024,h=1024,fit=scale-down\" alt=\"Tampilan tabel wp_options di phpMyAdmin dengan tampilan url lama dan url baru\" class=\"wp-image-45657\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2025\/09\/url-baru-di-tabel-wp-options.png\/w=1316,fit=scale-down 1316w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2025\/09\/url-baru-di-tabel-wp-options.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2025\/09\/url-baru-di-tabel-wp-options.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2025\/09\/url-baru-di-tabel-wp-options.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2025\/09\/url-baru-di-tabel-wp-options.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 1316px) 100vw, 1316px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" data-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on--click=\"actions.showLightbox\" data-wp-style--right=\"state.thisImage.buttonRight\" data-wp-style--top=\"state.thisImage.buttonTop\">\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\"><\/path>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div><p class=\"wp-block-paragraph\">Kalau muncul error dan query gagal dijalankan, periksa kembali apakah ada kesalahan penulisan atau prefix tabel yang tidak sesuai. Apabila masalah tetap muncul, segera hubungi tim dukungan provider hosting Anda untuk mendapatkan bantuan.<\/p><h2 class=\"wp-block-heading\" id=\"h-kesimpulan\">Kesimpulan<\/h2><p class=\"wp-block-paragraph\">Melalui artikel ini, Anda baru saja mempelajari cara mengubah URL WordPress langsung di database MySQL menggunakan phpMyAdmin.<\/p><p class=\"wp-block-paragraph\">Langkah-langkahnya sebenarnya cukup mudah, Anda hanya perlu memastikan database yang digunakan benar, lalu menjalankan beberapa baris query SQL untuk mengganti URL lama dengan yang baru. Setelah itu, pastikan URL lama sudah sepenuhnya berubah ke URL yang baru.<\/p><p class=\"wp-block-paragraph\">Mudah-mudahan tutorial ini bisa membantu Anda melakukan langkah-langkahnya tanpa masalah, ya. Kalau masih ada pertanyaan, jangan ragu untuk menuliskannya di kolom komentar di bawah artikel ini.<\/p><p>\n\n\n        <div class=\"protip\">\n            <div class=\"protip__heading\">\n                <svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                    <path d=\"M1.49234 23.5024C1.23229 23.5024 0.972242 23.4024 0.782206 23.2123C0.562165 22.9923 0.452144 22.6822 0.502153 22.3722C0.562165 21.9221 1.14227 17.9113 3.00262 16.351C3.63274 15.8209 4.43289 15.5509 5.26305 15.5609C6.09321 15.5909 6.87335 15.9109 7.47347 16.4911C8.6937 17.6913 8.76371 19.6717 7.6435 20.9919C6.0832 22.8523 2.08245 23.4324 1.63237 23.4924C1.59236 23.4924 1.54235 23.4924 1.50234 23.4924L1.49234 23.5024ZM5.16303 17.5613C4.84297 17.5613 4.53291 17.6713 4.29287 17.8813C3.60274 18.4614 3.07264 19.9317 2.75258 21.242C4.06282 20.9219 5.5331 20.3918 6.11321 19.7017C6.55329 19.1716 6.54329 18.3814 6.0832 17.9213C5.85316 17.7013 5.5431 17.5713 5.20304 17.5613C5.19304 17.5613 5.17303 17.5613 5.16303 17.5613ZM11.7243 21.8821C11.4942 21.8821 11.2642 21.8021 11.0841 21.652C10.8541 21.462 10.7241 21.1819 10.7241 20.8819V15.9109L8.08358 13.2705H3.11264C2.81259 13.2705 2.53254 13.1404 2.3425 12.9104C2.15246 12.6803 2.07245 12.3803 2.12246 12.0902C2.19247 11.7102 2.84259 8.36953 4.70294 7.12929C6.33325 6.04909 8.96375 6.49918 10.244 6.80923C11.5442 4.96889 13.2546 3.4286 15.2349 2.33839C17.4553 1.11816 19.9858 0.518051 22.4963 0.498047C23.0464 0.498047 23.4865 0.948132 23.4865 1.49824C23.4865 5.0389 22.3763 9.97983 17.1753 13.7605C17.4853 15.0408 17.9354 17.6613 16.8552 19.2816C15.615 21.1419 12.2744 21.7921 11.8943 21.8621C11.8343 21.8721 11.7743 21.8821 11.7143 21.8821H11.7243ZM12.7245 16.181V19.6016C13.7146 19.2916 14.7948 18.7915 15.2049 18.1814C15.675 17.4812 15.605 16.091 15.385 14.9008C14.5248 15.3808 13.6346 15.8109 12.7245 16.181ZM9.66388 12.0302L11.9643 14.3307C13.1845 13.8306 14.3648 13.2204 15.485 12.5103C19.9358 9.51974 21.2361 5.60901 21.4561 2.53843C19.6157 2.67846 17.8254 3.20856 16.2051 4.09872C14.2847 5.14892 12.6544 6.68921 11.4942 8.54956C10.7841 9.65977 10.174 10.82 9.66388 12.0302ZM4.39289 11.2701H7.81353C8.1936 10.3599 8.63368 9.46974 9.11377 8.60957C7.92355 8.38953 6.51329 8.31952 5.81315 8.78961C5.19304 9.19968 4.70294 10.3099 4.39289 11.2701Z\" fill=\"#673DE6\"\/>\n                <\/svg>\n                <p class=\"protip__title\">\n                    Tutorial teknis WordPress lainnya                <\/p>\n            <\/div>\n            <p class=\"protip__content\"><a href=\"\/id\/tutorial\/cara-membuat-file-htaccess-wordpress\/\">Cara membuat file .htaccess WordPress di cPanel dan hPanel<\/a><br>\n<a href=\"\/id\/tutorial\/cara-search-and-replace-database-wordpress\/\">Cara melakukan search and replace di database WordPress<\/a><br>\n<a href=\"\/id\/tutorial\/wp_query-wordpress\/\">Tutorial penggunaan WP_Query WordPress + contohnya<\/a><br>\n<a href=\"\/id\/tutorial\/cara-install-wordpress-di-xampp\/\">Cara menggunakan XAMPP untuk membuat website WordPress lokal<\/a><br>\n<a href=\"\/id\/tutorial\/cara-mempercepat-wordpress\/\">Cara mempercepat website WordPress<\/a><\/p>\n                    <\/div>\n        \n\n\n\n<\/p><h2 class=\"wp-block-heading\" id=\"h-tanya-jawab-faq-cara-mengubah-url-wordpress-phpmyadmin\">Tanya jawab (FAQ) cara mengubah URL WordPress phpMyAdmin<\/h2><p class=\"wp-block-paragraph\">Berikut adalah beberapa pertanyaan yang sering diajukan tentang cara mengubah URL WordPress di phpMyAdmin.<\/p><div id=\"rank-math-faq\" class=\"rank-math-block\">\n<div class=\"rank-math-list \">\n<div id=\"faq-question-69442b3f1170c\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">Bagaimana cara mengubah URL di MySQL?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Untuk mengganti URL di MySQL, Anda perlu memahami langkah-langkah teknisnya. Pertama, buka database tempat URL tersimpan, yang biasanya ada di folder data penginstalan MySQL. Setelah itu, gunakan editor teks untuk menemukan dan mengganti semua URL lama dengan URL baru.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-69442b3f1170f\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">Bagaimana cara menghubungkan WordPress ke MySQL?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Masuk ke akun hosting Anda dan buka phpMyAdmin. Setelah itu, klik menu <strong>Import<\/strong>, lalu klik tombol <strong>Choose file<\/strong>. Pilih database WordPress Anda untuk menghubungkannya.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-69442b3f11710\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">Apakah bisa mengubah nama database WordPress?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Ya, tentu saja. Setelah masuk ke phpMyAdmin dari akun hosting Anda, buka tab <strong>Operations<\/strong>. Pada bagian <strong>Rename database to<\/strong>, masukkan nama database yang baru, kemudian klik <strong>Go<\/strong>.<\/p>\n\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>WordPress menyimpan semua data website Anda di database MySQL, termasuk URL halamannya. Jadi, kalau perlu mengganti URL WordPress, Anda juga harus melakukan perubahan langsung di MySQL. Sayangnya, proses ini bisa cukup merepotkan ketika Anda perlu mengubah domain dan URL website. Tidak hanya alamat website yang akan berubah, tapi semua internal link yang tersimpan di dalam [&#8230;]<\/p>\n<p><a class=\"btn btn-secondary understrap-read-more-link\" href=\"\/id\/tutorial\/cara-mengubah-url-wordpress-phpmyadmin\/\">Read More&#8230;<\/a><\/p>\n","protected":false},"author":190,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_title":"Cara mengubah URL WordPress di phpMyAdmin (MySQL)","rank_math_description":"Mencari cara untuk mengubah URL website? Yuk, baca tutorial ini untuk mempelajari cara mengubah URL WordPress di MySQL menggunakan phpMyAdmin!","rank_math_focus_keyword":"Cara mengubah URL WordPress phpMyAdmin","footnotes":""},"categories":[4859],"tags":[],"class_list":["post-45648","post","type-post","status-publish","format-standard","hentry","category-wordpress"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/tutorials\/how-to-change-wordpress-urls-in-mysql-database\/","default":1},{"locale":"pt-BR","link":"https:\/\/www.hostinger.com\/br\/tutoriais\/como-mudar-url-do-wordpress-no-banco-de-dados\/","default":0},{"locale":"fr-FR","link":"https:\/\/www.hostinger.com\/fr\/tutoriels\/modifier-url-wordpress-dans-base-de-donnees\/","default":0},{"locale":"es-ES","link":"https:\/\/www.hostinger.com\/es\/tutoriales\/como-cambiar-la-url-de-wordpress\/","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/tutorial\/cara-mengubah-url-wordpress-phpmyadmin\/","default":0},{"locale":"en-PH","link":"https:\/\/www.hostinger.com\/ph\/tutorials\/how-to-change-wordpress-urls-in-mysql-database\/","default":0},{"locale":"en-MY","link":"https:\/\/www.hostinger.com\/my\/tutorials\/how-to-change-wordpress-urls-in-mysql-database\/","default":0},{"locale":"en-GB","link":"https:\/\/www.hostinger.com\/uk\/tutorials\/how-to-change-wordpress-urls-in-mysql-database\/","default":0},{"locale":"en-IN","link":"https:\/\/www.hostinger.com\/in\/tutorials\/how-to-change-wordpress-urls-in-mysql-database\/","default":0},{"locale":"en-CA","link":"https:\/\/www.hostinger.com\/ca\/tutorials\/how-to-change-wordpress-urls-in-mysql-database\/","default":0},{"locale":"en-AU","link":"https:\/\/www.hostinger.com\/au\/tutorials\/how-to-change-wordpress-urls-in-mysql-database\/","default":0},{"locale":"en-NG","link":"https:\/\/www.hostinger.com\/ng\/tutorials\/how-to-change-wordpress-urls-in-mysql-database\/","default":0},{"locale":"es-AR","link":"https:\/\/www.hostinger.com\/ar\/tutoriales\/como-cambiar-la-url-de-wordpress\/","default":0},{"locale":"es-MX","link":"https:\/\/www.hostinger.com\/mx\/tutoriales\/como-cambiar-la-url-de-wordpress\/","default":0},{"locale":"es-CO","link":"https:\/\/www.hostinger.com\/co\/tutoriales\/como-cambiar-la-url-de-wordpress\/","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/pt\/tutoriais\/como-mudar-url-do-wordpress-no-banco-de-dados\/","default":0}],"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/id\/tutorial\/wp-json\/wp\/v2\/posts\/45648","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/id\/tutorial\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/id\/tutorial\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/tutorial\/wp-json\/wp\/v2\/users\/190"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/tutorial\/wp-json\/wp\/v2\/comments?post=45648"}],"version-history":[{"count":6,"href":"https:\/\/www.hostinger.com\/id\/tutorial\/wp-json\/wp\/v2\/posts\/45648\/revisions"}],"predecessor-version":[{"id":46964,"href":"https:\/\/www.hostinger.com\/id\/tutorial\/wp-json\/wp\/v2\/posts\/45648\/revisions\/46964"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/id\/tutorial\/wp-json\/wp\/v2\/media?parent=45648"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/tutorial\/wp-json\/wp\/v2\/categories?post=45648"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/tutorial\/wp-json\/wp\/v2\/tags?post=45648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}