{"id":7385,"date":"2024-08-09T15:58:27","date_gmt":"2024-08-09T08:58:27","guid":{"rendered":"https:\/\/www.rumahweb.com\/journal\/?p=7385"},"modified":"2024-08-09T15:58:30","modified_gmt":"2024-08-09T08:58:30","slug":"cara-membuat-database-di-plesk","status":"publish","type":"post","link":"https:\/\/www.rumahweb.com\/journal\/cara-membuat-database-di-plesk\/","title":{"rendered":"Cara Membuat Database di Plesk"},"content":{"rendered":"\n<p>Database adalah kumpulan data yang dikelola dan tersimpan pada sebuah sistem di dalam komputer atau server. Pada panduan ini, kami akan berbagi cara membuat database di Plesk Panel. <\/p>\n\n\n\n\n\n<p>Pada hosting, database digunakan untuk menyimpan data dari sebuah website\/aplikasi. Data tersebut dapat berupa informasi user, password yang dapat dienkripsi, themes atau gambar-gambar yang merupakan bagian dari website.<\/p>\n\n\n\n<p>Dengan banyaknya kelebihan yang diberikan database untuk pengelolaan data website, hal ini menjadikan database menjadi salah satu kebutuhan yang penting bagi para developer website.<\/p>\n\n\n\n<p>Bagi pelanggan Rumahweb yang memiliki layanan <a href=\"https:\/\/www.rumahweb.com\/wordpress-hosting\/\" title=\"wordpress hosting\"><strong>WordPress Hosting<\/strong><\/a> versi Plesk maupun VPS dengan Plesk Panel, Anda dapat menemukan fitur Database ini di Plesk Panel hosting Anda. <\/p>\n\n\n\n<p>Untuk mengenal lebih detail tentang Database di Plesk, kami akan menjelaskan tentang fitur hingga cara mengelola databasenya.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Fitur Database di Plesk <\/h2>\n\n\n\n<p>Ada beberapa fitur yang dapat anda gunakan, untuk mengelola database di <a href=\"https:\/\/blog.rumahweb.com\/plesk-adalah\/\" target=\"_blank\" rel=\"noopener\" title=\"plesk adalah\">Plesk<\/a>. Berikut beberapa fiturnya;<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Pembuatan dan penghapusan database.<\/li>\n\n\n\n<li><strong>PHPMyadmin <\/strong>: tool berbasis web untuk mengelola database MySQL<\/li>\n\n\n\n<li><strong>Export Dump<\/strong> : mengubah database ke dalam file SQL lalu mendownloadnya<\/li>\n\n\n\n<li><strong>Connection Info<\/strong> : menampilkan informasi koneksi dari host, database name, user dan password<\/li>\n\n\n\n<li><strong>Import Dump<\/strong> : untuk upload atau import file SQL dari komputer ke hosting<\/li>\n\n\n\n<li><strong>Copy <\/strong>: menyalin database yang ada<\/li>\n\n\n\n<li><strong>Check And Repair<\/strong> : melakukan pemeriksaan dan perbaikan database<\/li>\n\n\n\n<li><strong>User Management<\/strong> : untuk pembuatan user database, koneksi user dengan database serta fitur hapus user database<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">Cara membuat database di Plesk<\/h2>\n\n\n\n<p>Untuk memulai pembuatan database pada Plesk, silakan mengikuti panduan berikut :<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><a style=\"font-size: revert;\" href=\"https:\/\/www.rumahweb.com\/journal\/panduan-login-ke-wordpress-hosting-rumahweb.htm\">Login ke Control Panel WordPress hosting<\/a> <\/li>\n\n\n\n<li><span style=\"font-size: revert; color: initial;\">Klik menu <\/span><strong style=\"font-size: revert; color: initial;\">Databases<\/strong> <\/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\/11\/klik_menu_databases.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"588\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/klik_menu_databases-1024x588.png\" alt=\"klik menu databases di Plesk - Cara membuat database di Plesk\" class=\"wp-image-25801\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/klik_menu_databases-1024x588.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/klik_menu_databases-300x172.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/klik_menu_databases-768x441.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/klik_menu_databases-370x213.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/klik_menu_databases-270x155.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/klik_menu_databases-570x328.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/klik_menu_databases-740x425.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/klik_menu_databases.png 1079w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>Klik &#8221;add database&#8221;<\/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\/11\/klik_add_database-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"383\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/klik_add_database-1-1024x383.png\" alt=\"Add Database di Plesk\" class=\"wp-image-25811\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/klik_add_database-1-1024x383.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/klik_add_database-1-300x112.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/klik_add_database-1-768x287.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/klik_add_database-1-370x138.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/klik_add_database-1-270x101.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/klik_add_database-1-570x213.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/klik_add_database-1-740x277.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/klik_add_database-1.png 1123w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li>Setelah itu, silahkan anda lengkapi database yang akan dibuat seperti gambar berikut : <\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/seting_database.png\"><img loading=\"lazy\" decoding=\"async\" width=\"966\" height=\"569\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/seting_database.png\" alt=\"seting database Plesk\" class=\"wp-image-25804\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/seting_database.png 966w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/seting_database-300x177.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/seting_database-768x452.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/seting_database-370x218.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/seting_database-270x159.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/seting_database-570x336.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/seting_database-740x436.png 740w\" sizes=\"auto, (max-width: 966px) 100vw, 966px\" \/><\/a><\/figure>\n\n\n\n<p><strong>Petunjuk pengisian:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Database name<\/strong> : tentukan nama database<\/li>\n\n\n\n<li><strong>Related site<\/strong> : mengaitkan website dengan database<\/li>\n\n\n\n<li><strong>Ceklis <\/strong>pada Create a database user<\/li>\n\n\n\n<li><strong>Database user name<\/strong> : tentukan user yang terkait dengan database<\/li>\n\n\n\n<li><strong>New password<\/strong> : password user yang telah dibuat<\/li>\n\n\n\n<li><strong>Confirm password<\/strong> : konfirmasi password user yang dibuat<\/li>\n\n\n\n<li>Klik OK<\/li>\n<\/ul>\n\n\n\n<p>Berikut adalah tampilan dari database yang telah berhasil dibuat.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/seting_database_selesai.png\"><img loading=\"lazy\" decoding=\"async\" width=\"871\" height=\"489\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/seting_database_selesai.png\" alt=\"seting database selesai di Plesk\" class=\"wp-image-25805\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/seting_database_selesai.png 871w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/seting_database_selesai-300x168.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/seting_database_selesai-768x431.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/seting_database_selesai-370x208.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/seting_database_selesai-270x152.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/seting_database_selesai-570x320.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/seting_database_selesai-740x415.png 740w\" sizes=\"auto, (max-width: 871px) 100vw, 871px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Cara Kelola Database Melalui phpMyAdmin<\/h2>\n\n\n\n<p>Seperti yang diketahui, phpMyAdmin adalah fitur yang disediakan oleh MySQL\/MariaDB untuk memudahkan dalam pengelolaan database.<\/p>\n\n\n\n<p>Untuk menggunakan fitur ini hanya perlu klik Menu Databases lalu klik phpMyAdmin.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/PHPMyadmin-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"533\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/PHPMyadmin-1-1024x533.png\" alt=\"Cara Akses PHPMyadmin di Plesk\" class=\"wp-image-25812\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/PHPMyadmin-1-1024x533.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/PHPMyadmin-1-300x156.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/PHPMyadmin-1-768x400.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/PHPMyadmin-1-370x193.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/PHPMyadmin-1-270x141.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/PHPMyadmin-1-570x297.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/PHPMyadmin-1-740x385.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/11\/PHPMyadmin-1.png 1095w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>Pada phpMyAdmin kita dapat mengelola database diantaranya :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Menampilkan seluruh tabel dari database<\/li>\n\n\n\n<li>Menelusuri isi dari setiap tabel<\/li>\n\n\n\n<li>Penambahan tabel baru<\/li>\n\n\n\n<li>Menjalankan perintah Query<\/li>\n\n\n\n<li>Menjalankan perintah pencarian data<\/li>\n\n\n\n<li>Melakukan export database<\/li>\n\n\n\n<li>Melakukan import database<\/li>\n\n\n\n<li>Menentukan storage engine yang ingin digunakan<\/li>\n<\/ul>\n\n\n\n<p>Demikianlah panduan <u>Cara membuat database di Plesk<\/u>. Semoga bermanfaat!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Database adalah kumpulan data yang dikelola dan tersimpan pada sebuah sistem di dalam komputer atau server. Pada panduan ini, kami akan berbagi cara membuat database di Plesk Panel. Pada hosting, database digunakan untuk menyimpan data dari sebuah website\/aplikasi. Data tersebut dapat berupa informasi user, password yang dapat dienkripsi, themes atau gambar-gambar yang merupakan bagian dari [&hellip;]<\/p>\n","protected":false},"author":272,"featured_media":25797,"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":[196],"tags":[135,251,232,356],"class_list":{"0":"post-7385","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-plesk-panel","8":"tag-database","9":"tag-plesk","10":"tag-plesk-panel","11":"tag-wordpress-hosting"},"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2017\/06\/Cara-Membuat-Database-di-Plesk.jpg","jetpack_shortlink":"https:\/\/wp.me\/p8n3G7-1V7","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/7385","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\/272"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/comments?post=7385"}],"version-history":[{"count":0,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/7385\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media\/25797"}],"wp:attachment":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media?parent=7385"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/categories?post=7385"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/tags?post=7385"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}