{"id":12110,"date":"2024-04-03T15:38:16","date_gmt":"2024-04-03T08:38:16","guid":{"rendered":"https:\/\/www.rumahweb.com\/journal\/?p=12110"},"modified":"2026-07-02T12:36:41","modified_gmt":"2026-07-02T05:36:41","slug":"setting-database-laravel","status":"publish","type":"post","link":"https:\/\/www.rumahweb.com\/journal\/setting-database-laravel\/","title":{"rendered":"Cara Setting Database Laravel di cPanel Hosting"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Melanjutkan panduan <a href=\"https:\/\/www.rumahweb.com\/journal\/cara-upload-laravel-ke-hosting-cpanel\/\" target=\"_blank\" rel=\"noopener\" title=\"upload laravel ke hosting\">upload Laravel ke hosting<\/a>, selanjutnya kami akan membahas bagaimana cara setting database Laravel di cPanel hosting Rumahweb. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Namun sebelum kami bahas cara setting koneksi database Laravel di cPanel, terlebih dahulu kami akan mengulas sedikit tentang apa itu laravel secara singkat. Simak informasi berikut ini. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Apa itu Laravel?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/blog.rumahweb.com\/laravel-adalah\/\" target=\"_blank\" rel=\"noopener\" title=\"laravel adalah\">Laravel<\/a> adalah framework berbasis bahasa pemrograman PHP yang saat ini mulai banyak digunakan oleh developer di seluruh dunia. Framework Laravel dikenal karena kemudahannya dalam proses pembuatan dan pengelolaan aplikasinya. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Untuk membuat framework laravel, anda bisa membuatnya terlebih dahulu di localhost melalui aplikasi web server local seperti XAMPP atau Laragon. Setelah project laravel anda selesai, Anda bisa mengupload file website dan databasenya ke hosting agar aplikasi Anda dapat diakses secara online. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Saat ini, seluruh hosting Rumahweb telah mendukung Framework Laravel. Anda bisa menggunakan salah satu dari <a href=\"https:\/\/www.rumahweb.com\/hosting-murah\/\" target=\"_blank\" rel=\"noopener\" title=\"hosting murah\">Shared Hosting<\/a>, Cloud Hosting atau Unlimited Hosting agar aplikasi Anda dapat diakses secara online.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Setting Database Laravel<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Sebelum melakukan setting database Laravel, pastikan bahwa file websitenya telah di upload ke hosting Anda dengan benar. Setelah itu, Anda bisa mengikuti panduan berikut. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1. Buat database di cPanel<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Langkah pertama yang perlu Anda lakukan adalah membuat database di cPanel. Berikut langkah-langkahnya : <\/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 Databases.<\/li>\n\n\n\n<li>Klik tombol create database, lalu masukkan nama database yang akan dibuat. <\/li>\n\n\n\n<li>Selanjutnya, buat user database dan masukkan password usernya. <\/li>\n\n\n\n<li>Langkah terakhir, berikan privilege user database. <\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Selengkapnya tentang cara membuat database di cPanel bisa Anda pelajari melalui link berikut : <a href=\"https:\/\/www.rumahweb.com\/journal\/cara-membuat-database\/#Cara_membuat_database_di_cPanel\" target=\"_blank\" rel=\"noopener\" title=\"buat database di cpanel\">cara membuat database di cPanel<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2. Export dan Import database dari localhost<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Bagi Anda yang sebelumnya membuat project laravel melalui Localhost, Anda dapat melakukan export dan import databasenya dari localhost ke hosting. Berikut langkah-langkahnya. <\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Export database localhost<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Pada panduan ini, kami menggunakan web server local XAMPP untuk membuat project laravelnya. Untuk akses ke phpMyAdmin, silahkan ikuti step by step berikut ini. <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Pastikan bahwa database service telah Anda aktifkan di control panel XAMPP. <\/li>\n\n\n\n<li>Setelah aktif, buka browser dan akses link berikut : <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-gridlove-highlight-acc-color\">localhost\/phpmyadmin<\/mark>.<\/li>\n\n\n\n<li>Di sebelah kiri panel phpMyAdmin, akan terlihat database yang sudah Anda buat sebelumnya. Klik pada database laravel yang Anda gunakan, lalu tekan Export.<\/li>\n\n\n\n<li>Setelah itu, klik tombol Go untuk mengunduh databasenya. Backup database akan berupa file dengan ekstensi .sql. <\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/phpmyadmin-3-min.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"487\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/phpmyadmin-3-min-1024x487.jpg\" alt=\"backup database di localhost\" class=\"wp-image-24825\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/phpmyadmin-3-min-1024x487.jpg 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/phpmyadmin-3-min-300x143.jpg 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/phpmyadmin-3-min-768x365.jpg 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/phpmyadmin-3-min-370x176.jpg 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/phpmyadmin-3-min-270x128.jpg 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/phpmyadmin-3-min-570x271.jpg 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/phpmyadmin-3-min-740x352.jpg 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/phpmyadmin-3-min.jpg 1365w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Selengkapnya tentang cara export database di localhost bisa Anda baca referensi <a href=\"https:\/\/www.rumahweb.com\/journal\/cara-backup-database-mysql-di-localhost\/\" target=\"_blank\" rel=\"noopener\" title=\"\">berikut<\/a>.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Import database localhost<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Setelah selesai export database di localhost, selanjutnya Anda dapat mengupload database ke hosting. Pastikan bahwa Anda telah membuat database di cPanel sesuai step 1 di panduan ini. Setelah itu, ikuti langkah berikut :<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Klik menu phpMyAdmin di cPanel hosting Anda. <\/li>\n\n\n\n<li>Klik database yang akan akan digunakan, lalu klik menu Import. <\/li>\n\n\n\n<li>Langkah selanjutnya, klik tombol &#8220;Browse&#8221; untuk mengupload file .sql yang telah Anda backup sebelumnya. <\/li>\n\n\n\n<li>Setelah itu, klik tombol &#8216;Go&#8217; untuk memulai proses import databasenya. <\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Selengkapnya tentang cara import database di phpMyAdmin bisa Anda pelajari pada artikel <a href=\"https:\/\/www.rumahweb.com\/journal\/cara-import-database-di-phpmyadmin\/#Cara_Import_Database_phpMyAdmin\" target=\"_blank\" rel=\"noopener\" title=\"import database phpmyadmin\">berikut<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3. Setting koneksi database<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Setting koneksi database Laravel dilakukan melalui file .env. Untuk melihat file .env ada dimana, Anda bisa melakukan pengecekan pada file index.php seperti pada gambar dibawah ini :<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"928\" height=\"399\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/04\/Screenshot_1.png\" alt=\"cek script index - Panduan Setting Database Laravel di cPanel\" class=\"wp-image-12111\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/04\/Screenshot_1.png 928w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/04\/Screenshot_1-300x129.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/04\/Screenshot_1-768x330.png 768w\" sizes=\"auto, (max-width: 928px) 100vw, 928px\" \/><figcaption class=\"wp-element-caption\">Artinya file .env berada di folder \/home\/usercPanel\/laravel\/<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Setelah mengetahui letak file .env, silahkan inputkan host (localhost), nama database, username dan password user databasenya. Berikut contohnya. <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"767\" height=\"374\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/04\/Screenshot_2.png\" alt=\"file env laravel - Panduan Setting Database Laravel di cPanel\" class=\"wp-image-12112\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/04\/Screenshot_2.png 767w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/04\/Screenshot_2-300x146.png 300w\" sizes=\"auto, (max-width: 767px) 100vw, 767px\" \/><figcaption class=\"wp-element-caption\">pastikan input nama database dan user database sama dengan yang Bapak buat di menu MySql databases, artinya lengkap dengan prefix database dan user prefix seperti screenshoot diatas<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Setelah selesai setting koneksi database tersebut, silahkan Anda mencoba akses kembali website Laravel di hosting.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Demikian panduan koneksi database pada Laravel, selamat mencoba. Jika Anda mengalami kendala dalam proses koneksi database tersebut, Anda bisa menghubungi kami melalui email atau ticket. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Melanjutkan panduan upload Laravel ke hosting, selanjutnya kami akan membahas bagaimana cara setting database Laravel di cPanel hosting Rumahweb. Namun sebelum kami bahas cara setting koneksi database Laravel di cPanel, terlebih dahulu kami akan mengulas sedikit tentang apa itu laravel secara singkat. Simak informasi berikut ini. Apa itu Laravel? Laravel adalah framework berbasis bahasa pemrograman [&hellip;]<\/p>\n","protected":false},"author":329,"featured_media":12202,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[921,796,1497],"class_list":["post-12110","post","type-post","status-publish","format-standard","has-post-thumbnail","category-artikel-tutorial","tag-databsae","tag-laravel","tag-tutorial-laravel"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"Pada panduan kali ini, kami akan menjelaskan apa itu laravel, cara upload serta setting database laravel ke hosting cPanel. Apa itu laravel? laravel adalah\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Lutfi Hanif\"\/>\n\t<meta name=\"google-site-verification\" content=\"wPstUwU5246IbK_1PqwGrc1LoSDnB-9rPbcT8_vSNgQ\" \/>\n\t<meta name=\"keywords\" content=\"setting koneksi database laravel,setting database laravel,setting database laravel cpanel,cara setting database di laravel,databsae,laravel,tutorial laravel\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.rumahweb.com\/journal\/setting-database-laravel\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"id_Id\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Rumahweb Journal \u2013 News, Article, and Tutorial of Web Dev\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Cara Setting Database Laravel di cPanel Hosting - Rumahweb\" \/>\n\t\t<meta property=\"og:description\" content=\"Pada panduan kali ini, kami akan menjelaskan apa itu laravel, cara upload serta setting database laravel ke hosting cPanel. Apa itu laravel? laravel adalah\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.rumahweb.com\/journal\/setting-database-laravel\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/04\/og-image-Panduan-Setting-Koneksi-Database-Laravel.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/04\/og-image-Panduan-Setting-Koneksi-Database-Laravel.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"1011\" \/>\n\t\t<meta property=\"og:image:height\" content=\"700\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2024-04-03T08:38:16+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-07-02T05:36:41+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/RumahwebIndonesia\/\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@rumahwebtweet\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Cara Setting Database Laravel di cPanel Hosting - Rumahweb\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Pada panduan kali ini, kami akan menjelaskan apa itu laravel, cara upload serta setting database laravel ke hosting cPanel. Apa itu laravel? laravel adalah\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@rumahwebtweet\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/04\/og-image-Panduan-Setting-Koneksi-Database-Laravel.jpg\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Cara Setting Database Laravel di cPanel Hosting - Rumahweb","description":"Pada panduan kali ini, kami akan menjelaskan apa itu laravel, cara upload serta setting database laravel ke hosting cPanel. Apa itu laravel? laravel adalah","canonical_url":"https:\/\/www.rumahweb.com\/journal\/setting-database-laravel\/","robots":"max-image-preview:large","keywords":"setting koneksi database laravel,setting database laravel,setting database laravel cpanel,cara setting database di laravel,databsae,laravel,tutorial laravel","webmasterTools":{"google-site-verification":"wPstUwU5246IbK_1PqwGrc1LoSDnB-9rPbcT8_vSNgQ","miscellaneous":""},"schema":null,"og:locale":"id_Id","og:site_name":"Rumahweb Journal \u2013 News, Article, and Tutorial of Web Dev","og:type":"article","og:title":"Cara Setting Database Laravel di cPanel Hosting - Rumahweb","og:description":"Pada panduan kali ini, kami akan menjelaskan apa itu laravel, cara upload serta setting database laravel ke hosting cPanel. Apa itu laravel? laravel adalah","og:url":"https:\/\/www.rumahweb.com\/journal\/setting-database-laravel\/","og:image":"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/04\/og-image-Panduan-Setting-Koneksi-Database-Laravel.jpg","og:image:secure_url":"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/04\/og-image-Panduan-Setting-Koneksi-Database-Laravel.jpg","og:image:width":1011,"og:image:height":700,"article:published_time":"2024-04-03T08:38:16+00:00","article:modified_time":"2026-07-02T05:36:41+00:00","article:publisher":"https:\/\/www.facebook.com\/RumahwebIndonesia\/","twitter:card":"summary_large_image","twitter:site":"@rumahwebtweet","twitter:title":"Cara Setting Database Laravel di cPanel Hosting - Rumahweb","twitter:description":"Pada panduan kali ini, kami akan menjelaskan apa itu laravel, cara upload serta setting database laravel ke hosting cPanel. Apa itu laravel? laravel adalah","twitter:creator":"@rumahwebtweet","twitter:image":"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2019\/04\/og-image-Panduan-Setting-Koneksi-Database-Laravel.jpg"},"aioseo_meta_data":{"post_id":"12110","title":"#post_title - Rumahweb","description":"Pada panduan kali ini, kami akan menjelaskan apa itu laravel, cara upload serta setting database laravel ke hosting cPanel. Apa itu laravel? laravel adalah","keywords":[{"label":"setting koneksi database laravel","value":"setting koneksi database laravel"},{"label":"setting database laravel","value":"setting database laravel"},{"label":"setting database laravel cpanel","value":"setting database laravel cpanel"},{"label":"cara setting database di laravel","value":"cara setting database di laravel"}],"keyphrases":{"focus":{"keyphrase":"setting database laravel","score":91,"analysis":{"keyphraseInTitle":{"score":9,"maxScore":9,"error":0},"keyphraseInDescription":{"score":9,"maxScore":9,"error":0},"keyphraseLength":{"score":9,"maxScore":9,"error":0,"length":3},"keyphraseInURL":{"score":5,"maxScore":5,"error":0},"keyphraseInIntroduction":{"score":9,"maxScore":9,"error":0},"keyphraseInSubHeadings":{"score":3,"maxScore":9,"error":1},"keyphraseInImageAlt":{"score":9,"maxScore":9,"error":0},"keywordDensity":{"type":"best","score":9,"maxScore":9,"error":0}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"Article","isEnabled":true},"graphs":[],"defaultGraph":"Article","defaultPostTypeGraph":""},"schema_type":"default","schema_type_options":"{\"article\":{\"articleType\":\"BlogPosting\"},\"course\":{\"name\":\"\",\"description\":\"\",\"provider\":\"\"},\"faq\":{\"pages\":[]},\"product\":{\"reviews\":[]},\"recipe\":{\"ingredients\":[],\"instructions\":[],\"keywords\":[]},\"software\":{\"reviews\":[],\"operatingSystems\":[]},\"webPage\":{\"webPageType\":\"WebPage\"}}","pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","location":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":{"faqs":[],"keyPoints":[],"schemas":[],"titles":[],"descriptions":[],"socialPosts":{"email":{"subject":"","preview":"","content":""},"linkedin":[],"twitter":[],"facebook":[],"instagram":[]}},"created":"2020-12-21 10:50:05","updated":"2026-07-02 05:37:31","seo_analyzer_scan_date":null},"_links":{"self":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/12110","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\/329"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/comments?post=12110"}],"version-history":[{"count":1,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/12110\/revisions"}],"predecessor-version":[{"id":65954,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/12110\/revisions\/65954"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media\/12202"}],"wp:attachment":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media?parent=12110"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/categories?post=12110"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/tags?post=12110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}