{"id":7648,"date":"2018-09-04T06:39:27","date_gmt":"2018-09-04T06:39:27","guid":{"rendered":"https:\/\/idwebhost.com\/tutorial\/?post_type=dt_articles&#038;p=7648"},"modified":"2022-07-27T11:11:15","modified_gmt":"2022-07-27T04:11:15","slug":"setting-database-wordpress","status":"publish","type":"dt_articles","link":"https:\/\/idwebhost.com\/tutorial\/kb\/setting-database-wordpress\/","title":{"rendered":"Cara Setting Koneksi Database WordPress"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">Installasi wordpress dihosting baik upload dari localhost ataupun memindahkan dari hosting lain salah satu langkah penting adalah melakukan setting koneksi database. Kamu bisa ikuti langkah langkah berikut ini:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Buat database dahulu di akun hosting yang baru. Login ke cpanel lalu buat dari menu mySQLDatabases.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-7376 size-large\" src=\"https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP12-1024x483.jpg\" alt=\"Cara Setting Koneksi Database WordPress 1\" width=\"1024\" height=\"483\" srcset=\"https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP12-1024x483.jpg 1024w, https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP12-300x141.jpg 300w, https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP12-768x362.jpg 768w, https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP12.jpg 1141w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Pada menu create new database masukkan nama database yang baru kemudian klik tombol create database.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-7377 size-full\" src=\"https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP4.jpg\" alt=\"Cara Setting Koneksi Database WordPress 2\" width=\"855\" height=\"360\" srcset=\"https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP4.jpg 855w, https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP4-300x126.jpg 300w, https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP4-768x323.jpg 768w\" sizes=\"(max-width: 855px) 100vw, 855px\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Berikan hak akses untuk user tersebut dari menu add user to database.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-7380 size-full\" src=\"https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP5.jpg\" alt=\"Cara Setting Koneksi Database WordPress 3\" width=\"943\" height=\"450\" srcset=\"https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP5.jpg 943w, https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP5-300x143.jpg 300w, https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP5-768x366.jpg 768w\" sizes=\"(max-width: 943px) 100vw, 943px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-7381 size-full\" src=\"https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP6.jpg\" alt=\"Cara Setting Koneksi Database WordPress 4\" width=\"859\" height=\"324\" srcset=\"https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP6.jpg 859w, https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP6-300x113.jpg 300w, https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP6-768x290.jpg 768w\" sizes=\"(max-width: 859px) 100vw, 859px\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Centang all previleges untuk memberikan akses penuh kepada user database tersebut.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-7382 size-full\" src=\"https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP7.jpg\" alt=\"Cara Setting Koneksi Database WordPress 5\" width=\"791\" height=\"599\" srcset=\"https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP7.jpg 791w, https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP7-300x227.jpg 300w, https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP7-768x582.jpg 768w\" sizes=\"(max-width: 791px) 100vw, 791px\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Bila wordpress di upload dari localhost ada kemungkinan url web masih memakai <\/span><i><span style=\"font-weight: 400;\">localhost<\/span><\/i><span style=\"font-weight: 400;\">, sebelum diimport perlu disesuaikan dahulu dengan url website baru. Cara paling mudah untuk merubah bisa gunakan software notepad++ atau sublime. Pilih menu search dan replace ( shortcut ctrl+h ), kemudian cari url yang masih <\/span><i><span style=\"font-weight: 400;\">localhost<\/span><\/i><span style=\"font-weight: 400;\"> diganti dengan nama domain -mu.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-7385 size-full\" src=\"https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP8.jpg\" alt=\"Cara Setting Koneksi Database WordPress 6\" width=\"944\" height=\"553\" srcset=\"https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP8.jpg 944w, https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP8-300x176.jpg 300w, https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP8-768x450.jpg 768w\" sizes=\"(max-width: 944px) 100vw, 944px\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Import database bisa dilakukan melalui menu phpMyAdmin dicPanel.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-7383 size-full\" src=\"https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP13.jpg\" alt=\"Cara Setting Koneksi Database WordPress 7\" width=\"978\" height=\"460\" srcset=\"https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP13.jpg 978w, https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP13-300x141.jpg 300w, https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP13-768x361.jpg 768w\" sizes=\"(max-width: 978px) 100vw, 978px\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Proses import pilih database yang sudah dibuat tadi, \u00a0kemudian pilih menu import.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-7384 size-large\" src=\"https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP9-1024x342.jpg\" alt=\"Cara Setting Koneksi Database WordPress 8\" width=\"1024\" height=\"342\" srcset=\"https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP9-1024x342.jpg 1024w, https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP9-300x100.jpg 300w, https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP9-768x257.jpg 768w, https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP9.jpg 1368w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Klik menu choose file, akan muncul pop-up untuk memilih database yang ada di PC untuk diimport kemudian klik Go .<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-7387 size-large\" src=\"https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP10-1-1024x379.jpg\" alt=\"Cara Setting Koneksi Database WordPress 9\" width=\"1024\" height=\"379\" srcset=\"https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP10-1-1024x379.jpg 1024w, https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP10-1-300x111.jpg 300w, https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP10-1-768x284.jpg 768w, https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP10-1.jpg 1428w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Setelah database berhasil diimport, perlu setting agar database yang diimport sebelumnya bisa terkoneksi dengan wordpress yang sudah diinstall. Masuk ke menu <a href=\"https:\/\/idwebhost.com\/blog\/cara-menghapus-file-di-file-manager\/\">file manager<\/a> kemudian masuk ke folder wordpress diinstall. Default file koneksi database wordpress adalah <\/span><i><span style=\"font-weight: 400;\">wp-config.php<\/span><\/i><span style=\"font-weight: 400;\">. Klik kanan dan pilih menu edit.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-7388 size-full\" src=\"https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP.jpg\" alt=\"Cara Setting Koneksi Database WordPress\" width=\"678\" height=\"469\" srcset=\"https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP.jpg 678w, https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP-300x208.jpg 300w\" sizes=\"(max-width: 678px) 100vw, 678px\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Nama user dan password database disamakan dengan yang sebelumnya dibuat di menu MySQL Databases. Database prefix juga disamakan, untuk database prefix bisa dilihat dari phpMyAdmin. Setelah semua dirasa cocok silahkan klik save.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-7389 size-large\" src=\"https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP15-1024x357.jpg\" alt=\"Cara Setting Koneksi Database WordPress\" width=\"1024\" height=\"357\" srcset=\"https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP15-1024x357.jpg 1024w, https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP15-300x105.jpg 300w, https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP15-768x268.jpg 768w, https:\/\/idwebhost.com\/tutorial\/wp-content\/uploads\/2018\/08\/settingDBWP15.jpg 1590w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Apabila sudah, coba akses pada website. Jika semua langkah yang dilakukan sesuai maka website bisa diakses dengan baik.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Masih bingung? Kamu bisa hubungi tim customer service terbaik kami melalui :<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Live Chat<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Email ( info@idwebhost.com, billing@idwebhost.com, support@idwebhost.com )<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Hotline (0274) 415585<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Selamat menikmati layanan kami \ud83d\ude42<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Installasi wordpress dihosting baik upload dari localhost ataupun memindahkan dari hosting lain salah satu langkah penting adalah melakukan setting koneksi database. Kamu bisa ikuti langkah langkah berikut ini: Buat database dahulu di akun hosting yang baru. Login ke cpanel lalu buat dari menu mySQLDatabases. &nbsp; Pada menu create new database masukkan nama database yang baru [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"amp_status":""},"article_entries":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/idwebhost.com\/tutorial\/wp-json\/wp\/v2\/dt_articles\/7648"}],"collection":[{"href":"https:\/\/idwebhost.com\/tutorial\/wp-json\/wp\/v2\/dt_articles"}],"about":[{"href":"https:\/\/idwebhost.com\/tutorial\/wp-json\/wp\/v2\/types\/dt_articles"}],"author":[{"embeddable":true,"href":"https:\/\/idwebhost.com\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/idwebhost.com\/tutorial\/wp-json\/wp\/v2\/comments?post=7648"}],"version-history":[{"count":3,"href":"https:\/\/idwebhost.com\/tutorial\/wp-json\/wp\/v2\/dt_articles\/7648\/revisions"}],"predecessor-version":[{"id":9007,"href":"https:\/\/idwebhost.com\/tutorial\/wp-json\/wp\/v2\/dt_articles\/7648\/revisions\/9007"}],"wp:attachment":[{"href":"https:\/\/idwebhost.com\/tutorial\/wp-json\/wp\/v2\/media?parent=7648"}],"wp:term":[{"taxonomy":"article_entries","embeddable":true,"href":"https:\/\/idwebhost.com\/tutorial\/wp-json\/wp\/v2\/article_entries?post=7648"},{"taxonomy":"tags","embeddable":true,"href":"https:\/\/idwebhost.com\/tutorial\/wp-json\/wp\/v2\/tags?post=7648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}