{"id":1042,"date":"2020-08-25T15:20:03","date_gmt":"2020-08-25T08:20:03","guid":{"rendered":"https:\/\/www.jagoweb.com\/kb\/?post_type=ht_kb&#038;p=1042"},"modified":"2022-10-31T15:34:31","modified_gmt":"2022-10-31T08:34:31","slug":"cara-membuat-database-di-xampp-localhost-vps-windows","status":"publish","type":"ht_kb","link":"https:\/\/www.jagoweb.com\/kb\/knowledge-base-jagoweb\/cara-membuat-database-di-xampp-localhost-vps-windows\/","title":{"rendered":"Cara Membuat Database di XAMPP\/Localhost VPS Windows"},"content":{"rendered":"<p><strong>Cara Membuat Database di XAMPP\/Localhost &#8211; <\/strong>XAMPP adalah perangkat lunak yang terdiri atas Apache, MySQL, dan PHP yang memungkinkan Anda memiliki server lokal. Dengan menggunakan server lokal ini, Anda bisa memulai untuk mendevelop website atau aplikasi dan juga\u00a0membuat database.<\/p>\n<p>Seperti halnya membuat database di Panel Hosting, cara pembuatan database di Localhost atau XAMPP sendiri sangatlah mudah. Berikut adalah caranya:<\/p>\n<p>&nbsp;<\/p>\n<p>1. Pertama, kita harus login ke phpMyAdmin di localhost terlebih dahulu, dengan masuk ke alamat <span style=\"color: #ff0000;\">localhost\/phpmyadmin\u00a0<\/span><\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-1045\" src=\"https:\/\/www.jagoweb.com\/kb\/wp-content\/uploads\/2020\/08\/mysql2.jpg\" alt=\"\" width=\"1135\" height=\"158\" srcset=\"https:\/\/www.jagoweb.com\/kb\/wp-content\/uploads\/2020\/08\/mysql2.jpg 1135w, https:\/\/www.jagoweb.com\/kb\/wp-content\/uploads\/2020\/08\/mysql2-300x42.jpg 300w, https:\/\/www.jagoweb.com\/kb\/wp-content\/uploads\/2020\/08\/mysql2-1024x143.jpg 1024w, https:\/\/www.jagoweb.com\/kb\/wp-content\/uploads\/2020\/08\/mysql2-768x107.jpg 768w, https:\/\/www.jagoweb.com\/kb\/wp-content\/uploads\/2020\/08\/mysql2-50x7.jpg 50w, https:\/\/www.jagoweb.com\/kb\/wp-content\/uploads\/2020\/08\/mysql2-920x128.jpg 920w, https:\/\/www.jagoweb.com\/kb\/wp-content\/uploads\/2020\/08\/mysql2-600x84.jpg 600w, https:\/\/www.jagoweb.com\/kb\/wp-content\/uploads\/2020\/08\/mysql2-320x45.jpg 320w\" sizes=\"(max-width: 1135px) 100vw, 1135px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>2.\u00a0 Lalu klik menu\u00a0<strong>Databases\u00a0<\/strong>dan isikan nama databasenya &gt; klik tombol <strong>Create<\/strong><\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-1048\" src=\"https:\/\/www.jagoweb.com\/kb\/wp-content\/uploads\/2020\/08\/mysql5.jpg\" alt=\"\" width=\"383\" height=\"96\" srcset=\"https:\/\/www.jagoweb.com\/kb\/wp-content\/uploads\/2020\/08\/mysql5.jpg 383w, https:\/\/www.jagoweb.com\/kb\/wp-content\/uploads\/2020\/08\/mysql5-300x75.jpg 300w, https:\/\/www.jagoweb.com\/kb\/wp-content\/uploads\/2020\/08\/mysql5-50x13.jpg 50w, https:\/\/www.jagoweb.com\/kb\/wp-content\/uploads\/2020\/08\/mysql5-320x80.jpg 320w\" sizes=\"(max-width: 383px) 100vw, 383px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>3. Selanjutnya kita create user database di menu\u00a0<strong>Previleges\u00a0<\/strong>&gt; dan klik tombol\u00a0<strong>Add User<\/strong><\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-1049\" src=\"https:\/\/www.jagoweb.com\/kb\/wp-content\/uploads\/2020\/08\/mysql6.jpg\" alt=\"\" width=\"531\" height=\"201\" srcset=\"https:\/\/www.jagoweb.com\/kb\/wp-content\/uploads\/2020\/08\/mysql6.jpg 531w, https:\/\/www.jagoweb.com\/kb\/wp-content\/uploads\/2020\/08\/mysql6-300x114.jpg 300w, https:\/\/www.jagoweb.com\/kb\/wp-content\/uploads\/2020\/08\/mysql6-50x19.jpg 50w, https:\/\/www.jagoweb.com\/kb\/wp-content\/uploads\/2020\/08\/mysql6-320x121.jpg 320w\" sizes=\"(max-width: 531px) 100vw, 531px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>4. Lalu Setalah Anda klik \u201cAdd User\u201d maka\u00a0akan muncul form pembuatan user baru. Pada kolom \u201cusername\u201d, Anda bisa mengisikannya dengan nama apapun yang Anda inginkan. Kemudian isikan juga \u201chost\u201d, gunakan \u201cuse text field\u201d saja, lalu isikan dengan \u201c<a href=\"https:\/\/www.jagoweb.com\">localhost<\/a>\u201d. Selanjutnya isikan \u201cpassword\u201d 2 kali dan harus sama. Terakhir, ceklist \u201cgrant all privileges on database\u201d.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-1044\" src=\"https:\/\/www.jagoweb.com\/kb\/wp-content\/uploads\/2020\/08\/mysql4.jpg\" alt=\"\" width=\"818\" height=\"365\" srcset=\"https:\/\/www.jagoweb.com\/kb\/wp-content\/uploads\/2020\/08\/mysql4.jpg 818w, https:\/\/www.jagoweb.com\/kb\/wp-content\/uploads\/2020\/08\/mysql4-300x134.jpg 300w, https:\/\/www.jagoweb.com\/kb\/wp-content\/uploads\/2020\/08\/mysql4-768x343.jpg 768w, https:\/\/www.jagoweb.com\/kb\/wp-content\/uploads\/2020\/08\/mysql4-50x22.jpg 50w, https:\/\/www.jagoweb.com\/kb\/wp-content\/uploads\/2020\/08\/mysql4-600x268.jpg 600w, https:\/\/www.jagoweb.com\/kb\/wp-content\/uploads\/2020\/08\/mysql4-320x143.jpg 320w\" sizes=\"(max-width: 818px) 100vw, 818px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Nah itu tadi adalah cara membuat database di phpmyadmin, sangat mudah bukan? Database sendiri bisa dibuat dengan banyak cara, cara diatas adalah cara yang sangat mudah dipahami.<\/p>\n","protected":false},"author":3,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":[],"ht_kb_category":[106],"ht_kb_tag":[182,181,183,179,180],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/ht_kb\/1042"}],"collection":[{"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/ht_kb"}],"about":[{"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/comments?post=1042"}],"version-history":[{"count":2,"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/ht_kb\/1042\/revisions"}],"predecessor-version":[{"id":2060,"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/ht_kb\/1042\/revisions\/2060"}],"wp:attachment":[{"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/media?parent=1042"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/ht_kb_category?post=1042"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/ht_kb_tag?post=1042"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}