{"id":8859,"date":"2019-11-07T06:12:35","date_gmt":"2019-11-07T06:12:35","guid":{"rendered":"https:\/\/blog.hostinger.io\/co-id-tutorial\/?p=8859"},"modified":"2025-12-18T23:33:29","modified_gmt":"2025-12-18T16:33:29","slug":"cara-install-phpmyadmin-ubuntu","status":"publish","type":"post","link":"\/id\/tutorial\/cara-install-phpmyadmin-ubuntu","title":{"rendered":"Cara menginstal phpMyAdmin di Ubuntu (tutorial lengkap)"},"content":{"rendered":"<p><a href=\"https:\/\/www.phpmyadmin.net\/\" target=\"_blank\" rel=\"noopener\">phpMyAdmin<\/a> adalah tool administratif populer yang berfungsi untuk mengelola database MariaDB dan MySQL melalui tampilan yang praktis.<\/p><p>Menggunakan tool ini, Anda bisa melakukan tugas-tugas administrasi database, seperti menjalankan kueri, mengelola pengguna dan izin, serta mengekspor dan mengimpor database.<\/p><p>Apabila menggunakan VPS (server pribadi virtual) berbasis Linux, Anda bisa menginstal phpMyAdmin untuk mengelola database secara remote dalam cara yang aman dan efisien. Di artikel ini, kami akan menjelaskan cara menginstal phpMyAdmin dan mengonfigurasinya di Ubuntu.<\/p><h2 class=\"wp-block-heading\" id=\"h-persiapan-sebelum-menginstal-phpmyadmin\">Persiapan sebelum Menginstal phpMyAdmin<\/h2><p>Sebelum menginstal phpMyAdmin, pastikan server Anda memenuhi semua persyaratan berikut ini:<\/p><ul class=\"wp-block-list\">\n<li><strong>VPS Ubuntu<\/strong>. VPS Anda harus menggunakan versi terbaru Ubuntu yang didukung, seperti Ubuntu <strong>22.04<\/strong> atau <strong>24.04<\/strong>. Apabila belum memiliki server sendiri, pertimbangkan untuk <a href=\"\/id\/hosting-vps\">membeli paket VPS<\/a> Ubuntu dari provider yang tepercaya.<\/li>\n\n\n\n<li><strong>Penginstalan LAMP stack<\/strong>. Pastikan Anda sudah menginstal web server Apache, server MySQL, dan PHP, serta ekstensi yang diperlukan untuk menjalankan phpMyAdmin.<\/li>\n<\/ul><figure class=\"wp-block-image size-large\"><a href=\"\/id\/hosting-vps\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" width=\"1024\" height=\"300\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2023\/02\/ID-VPS-hosting_in-text-banner.png\/public\" alt=\"\" class=\"wp-image-29630\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2023\/02\/ID-VPS-hosting_in-text-banner.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2023\/02\/ID-VPS-hosting_in-text-banner.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2023\/02\/ID-VPS-hosting_in-text-banner.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2023\/02\/ID-VPS-hosting_in-text-banner.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure><h2 class=\"wp-block-heading\" id=\"h-cara-install-phpmyadmin-di-ubuntu\">Cara Install phpMyAdmin di Ubuntu<\/h2><p>Setelah server Anda siap, mari mulai menginstal phpMyAdmin. Dalam tutorial ini, kami akan menggunakan template <strong>Ubuntu 22.04 with LAMP Stack<\/strong> dari VPS Hostinger.<\/p><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"69e1daafe660c\"}' data-wp-interactive=\"core\/image\" class=\"aligncenter size-large wp-lightbox-container\"><img decoding=\"async\" width=\"1129\" height=\"773\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on-async--click=\"actions.showLightbox\" data-wp-on-async--load=\"callbacks.setButtonStyles\" data-wp-on-async-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2024\/08\/ubuntu-lamp-stack.png\/public\" alt=\"tampilan bagian os &amp; panel vps di hpanel dengan ubuntu 22.04 with LAMP stack yang dipilih\" class=\"wp-image-39085\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2024\/08\/ubuntu-lamp-stack.png\/w=1129,fit=scale-down 1129w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2024\/08\/ubuntu-lamp-stack.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2024\/08\/ubuntu-lamp-stack.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2024\/08\/ubuntu-lamp-stack.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2024\/08\/ubuntu-lamp-stack.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 1129px) 100vw, 1129px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" aria-label=\"Enlarge\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on-async--click=\"actions.showLightbox\" data-wp-style--right=\"state.imageButtonRight\" data-wp-style--top=\"state.imageButtonTop\">\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><\/div><h3 class=\"wp-block-heading\" id=\"h-1-instal-paket-phpmyadmin\">1. Instal Paket phpMyAdmin<\/h3><p>Pastikan untuk login ke server Ubuntu dan update daftar paket Anda sebelum menginstal phpMyAdmin. Berikut langkah-langkahnya:<\/p><ol class=\"wp-block-list\">\n<li>Buka software terminal yang terinstal di komputer Anda. Kemudian, akses server dengan menjalankan perintah berikut ini. Ganti <strong>user<\/strong> dengan username Anda yang sebenarnya dan <strong>ip_address<\/strong> dengan alamat IP server Anda:<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">ssh user@ip_address<\/pre><ol class=\"wp-block-list\" start=\"2\">\n<li>Update dan upgrade daftar paket Anda di repositori default Ubuntu dengan <a href=\"\/id\/tutorial\/perintah-dasar-linux\">perintah Linux<\/a> ini:<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">sudo apt update &amp;&amp; sudo apt upgrade -y<\/pre><p>Kami menyarankan agar Anda menginstal phpMyAdmin dengan modul-modul PHP berikut menggunakan package manager <strong>apt:<\/strong><\/p><ul class=\"wp-block-list\">\n<li><strong>php-mbstring<\/strong>. Mengaktifkan dukungan bagi string multibyte untuk penanganan string non-ASCII yang lebih optimal.<\/li>\n\n\n\n<li><strong>php-zip<\/strong>. Memungkinkan PHP untuk menangani arsip ZIP.<\/li>\n\n\n\n<li><strong>php-gd<\/strong>. Menyediakan tool untuk memanipulasi data gambar.<\/li>\n\n\n\n<li><strong>php-json<\/strong>. Mendukung serialisasi dan deserialisasi JSON.<\/li>\n\n\n\n<li><strong>php-curl<\/strong>. Memungkinkan PHP untuk berkomunikasi dengan server lain melalui sintaksis URL.<\/li>\n<\/ul><p>Untuk melakukannya, jalankan perintah berikut:<\/p><pre class=\"wp-block-preformatted\">sudo apt install phpmyadmin php-mbstring php-zip php-gd php-json php-curl -y<\/pre><ol class=\"wp-block-list\" start=\"3\">\n<li>Anda akan diminta untuk memilih web server. Pilih <strong>apache2 <\/strong>dengan menekan <strong>Spasi<\/strong> <strong>&rarr; Tab &rarr; Enter<\/strong> di keyboard.<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"69e1daafe93f1\"}' data-wp-interactive=\"core\/image\" class=\"aligncenter size-full wp-lightbox-container\"><img decoding=\"async\" width=\"768\" height=\"272\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on-async--click=\"actions.showLightbox\" data-wp-on-async--load=\"callbacks.setButtonStyles\" data-wp-on-async-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/terminal-konfigurasi-phpmyadmin-apache2.png\/public\" alt=\"tampilan terminal dengan konfigurasi apache2 yang dipilih\" class=\"wp-image-39088\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/terminal-konfigurasi-phpmyadmin-apache2.png\/w=768,fit=scale-down 768w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/terminal-konfigurasi-phpmyadmin-apache2.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/terminal-konfigurasi-phpmyadmin-apache2.png\/w=150,fit=scale-down 150w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" aria-label=\"Enlarge\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on-async--click=\"actions.showLightbox\" data-wp-style--right=\"state.imageButtonRight\" data-wp-style--top=\"state.imageButtonTop\">\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><\/div><ol class=\"wp-block-list\" start=\"4\">\n<li>Mulai setup database menggunakan <strong>dbconfig-common<\/strong> dengan memilih <strong>Yes<\/strong>.<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"69e1daafebf18\"}' data-wp-interactive=\"core\/image\" class=\"aligncenter size-full wp-lightbox-container\"><img decoding=\"async\" width=\"768\" height=\"136\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on-async--click=\"actions.showLightbox\" data-wp-on-async--load=\"callbacks.setButtonStyles\" data-wp-on-async-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/terminal-konfigurasi-phpmyadmin-yes.png\/public\" alt=\"tampilan terminal dengan konfigurasi phpmyadmin yang dipilih\" class=\"wp-image-39089\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/terminal-konfigurasi-phpmyadmin-yes.png\/w=768,fit=scale-down 768w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/terminal-konfigurasi-phpmyadmin-yes.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/terminal-konfigurasi-phpmyadmin-yes.png\/w=150,fit=scale-down 150w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" aria-label=\"Enlarge\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on-async--click=\"actions.showLightbox\" data-wp-style--right=\"state.imageButtonRight\" data-wp-style--top=\"state.imageButtonTop\">\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><\/div><ol class=\"wp-block-list\" start=\"5\">\n<li>Saat diminta, buat dan konfirmasikan kata sandi aplikasi MySQL yang baru. Pastikan untuk memilih kata sandi yang kuat, yang mengandung huruf, angka, dan karakter khusus untuk meningkatkan keamanan.<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"69e1daafeec50\"}' data-wp-interactive=\"core\/image\" class=\"aligncenter size-full wp-lightbox-container\"><img decoding=\"async\" width=\"768\" height=\"153\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on-async--click=\"actions.showLightbox\" data-wp-on-async--load=\"callbacks.setButtonStyles\" data-wp-on-async-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/terminal-konfigurasi-phpmyadmin-ok.png\/public\" alt=\"tampilan terminal dengan pesan konfirmasi untuk mengonfigurasi phpmyadmin\" class=\"wp-image-39090\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/terminal-konfigurasi-phpmyadmin-ok.png\/w=768,fit=scale-down 768w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/terminal-konfigurasi-phpmyadmin-ok.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/terminal-konfigurasi-phpmyadmin-ok.png\/w=150,fit=scale-down 150w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" aria-label=\"Enlarge\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on-async--click=\"actions.showLightbox\" data-wp-style--right=\"state.imageButtonRight\" data-wp-style--top=\"state.imageButtonTop\">\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><\/div><ol class=\"wp-block-list\" start=\"6\">\n<li>Aktifkan ekstensi PHP <strong>mbstring<\/strong> dengan menjalankan perintah berikut:<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">sudo phpenmod mbstring<\/pre><ol class=\"wp-block-list\" start=\"7\">\n<li>Mulai ulang server Apache untuk menerapkan semua konfigurasi Anda:<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">sudo systemctl restart apache2<\/pre><h3 class=\"wp-block-heading\" id=\"h-2-atur-izin-pengguna\">2. Atur Izin Pengguna<\/h3><p>Setelah selesai menginstal phpMyAdmin, selanjutnya Anda perlu mengonfigurasi hak akses user MySQL untuk manajemen database yang aman dan efisien. Berikut cara mengatur izin di MySQL:<\/p><ol class=\"wp-block-list\">\n<li>Buka terminal MySQL sebagai user root:<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">sudo mysql -u root -p<\/pre><ol class=\"wp-block-list\" start=\"2\">\n<li>Masukkan kata sandi root yang tadi sudah Anda buat di langkah sebelumnya.<\/li>\n\n\n\n<li>Periksa metode autentikasi yang digunakan oleh user MySQL dengan menjalankan <a href=\"\/id\/tutorial\/apa-itu-query\">kueri database<\/a> ini:<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">SELECT user, authentication_string, plugin FROM mysql.user;<\/pre><ol class=\"wp-block-list\" start=\"4\">\n<li>Anda akan melihat metode autentikasi yang berlaku untuk semua user yang ditambahkan:<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"69e1daaff1a17\"}' data-wp-interactive=\"core\/image\" class=\"aligncenter size-full wp-lightbox-container\"><img decoding=\"async\" width=\"768\" height=\"179\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on-async--click=\"actions.showLightbox\" data-wp-on-async--load=\"callbacks.setButtonStyles\" data-wp-on-async-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/mysql-shell-auth-socket.png\/public\" alt=\"tampilan shell mysql dengan auth_socket yang dipilih\" class=\"wp-image-39091\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/mysql-shell-auth-socket.png\/w=768,fit=scale-down 768w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/mysql-shell-auth-socket.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/mysql-shell-auth-socket.png\/w=150,fit=scale-down 150w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" aria-label=\"Enlarge\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on-async--click=\"actions.showLightbox\" data-wp-style--right=\"state.imageButtonRight\" data-wp-style--top=\"state.imageButtonTop\">\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><\/div><ol class=\"wp-block-list\" start=\"5\">\n<li>Apabila user root menggunakan plugin <strong>auth_socket<\/strong>, alihkan ke <strong>caching_sha2_password<\/strong> untuk mengaktifkan autentikasi berbasis kata sandi. Ganti kata <strong>your_new_password<\/strong> dengan kata sandi pilihan Anda:<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'your_new_password';<\/pre><ol class=\"wp-block-list\" start=\"6\">\n<li>Verifikasikan perubahan tersebut dengan memeriksa ulang metode autentikasi:<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"69e1dab0001be\"}' data-wp-interactive=\"core\/image\" class=\"aligncenter size-full wp-lightbox-container\"><img decoding=\"async\" width=\"768\" height=\"180\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on-async--click=\"actions.showLightbox\" data-wp-on-async--load=\"callbacks.setButtonStyles\" data-wp-on-async-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/mysql-shell-caching-sha2-password.png\/public\" alt=\"tampilan shell mysql dengan caching-sha2-password yang dipilih\" class=\"wp-image-39092\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/mysql-shell-caching-sha2-password.png\/w=768,fit=scale-down 768w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/mysql-shell-caching-sha2-password.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/mysql-shell-caching-sha2-password.png\/w=150,fit=scale-down 150w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" aria-label=\"Enlarge\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on-async--click=\"actions.showLightbox\" data-wp-style--right=\"state.imageButtonRight\" data-wp-style--top=\"state.imageButtonTop\">\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><\/div><ol class=\"wp-block-list\" start=\"7\">\n<li>Setelah memvalidasi metode autentikasi, keluar dari sesi MySQL:<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">EXIT;<\/pre><h3 class=\"wp-block-heading\" id=\"h-3-akses-phpmyadmin-di-browser\">3. Akses phpMyAdmin di Browser<\/h3><p>Setelah phpMyAdmin terinstal dan izin pengguna sudah ditetapkan, sekarang Anda bisa mengakses phpMyAdmin melalui web browser. Ikuti langkah-langkah berikut ini untuk membuat koneksi:<\/p><ol class=\"wp-block-list\">\n<li>Buka web browser Anda.<\/li>\n\n\n\n<li>Ketik URL berikut ini pada kolom alamat browser, ganti <strong>your_server_ip <\/strong>dengan alamat IP server Ubuntu Anda:<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">http:\/\/your_server_ip\/phpmyadmin<\/pre><ol class=\"wp-block-list\" start=\"3\">\n<li>Atau, kalau sudah <a href=\"\/id\/tutorial\/cara-mengarahkan-domain-ke-hosting-vps-server\/\">menghubungkan nama domain ke VPS<\/a>, Anda bisa menambahkan <strong>\/phpmyadmin<\/strong> pada nama domain Anda, misalnya <strong>mydomain.com\/phpmyadmin<\/strong>.<\/li>\n\n\n\n<li>Halaman login phpMyAdmin akan terbuka. Selanjutnya, login dengan username dan kata sandi untuk akun user MySQL yang tadi sudah Anda konfigurasikan.<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img decoding=\"async\" width=\"768\" height=\"779\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/halaman-login-phpmyadmin.png\/public\" alt=\"tampilan halaman login phpmyadmin\" class=\"wp-image-39093\" style=\"width:484px;height:auto\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/halaman-login-phpmyadmin.png\/w=768,fit=scale-down 768w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/halaman-login-phpmyadmin.png\/w=296,fit=scale-down 296w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/halaman-login-phpmyadmin.png\/w=148,fit=scale-down 148w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/figure><\/div><ol class=\"wp-block-list\" start=\"5\">\n<li>Setelah masuk, Anda bisa mulai mengelola database MySQL melalui dashboard phpMyAdmin.<\/li>\n\n\n\n<li>Apabila sudah selesai dengan tugas pengelolaan database Anda, keluarlah dari phpMyAdmin dengan mengklik tombol <strong>Logout <\/strong>di pojok kiri atas.<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"590\" height=\"650\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/logout-phpmyadmin.png\/public\" alt=\"tampilan sidebar kiri phpmyadmin dengan tombol logout yang dipilih\" class=\"wp-image-39094\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/logout-phpmyadmin.png\/w=590,fit=scale-down 590w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/logout-phpmyadmin.png\/w=272,fit=scale-down 272w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/logout-phpmyadmin.png\/w=136,fit=scale-down 136w\" sizes=\"(max-width: 590px) 100vw, 590px\" \/><\/figure><\/div><p>Selamat! Anda sudah berhasil menginstal phpMyAdmin di Ubuntu. Selanjutnya, Anda bisa menerapkan <a href=\"\/id\/tutorial\/cara-mengamankan-vps\">langkah-langkah keamanan VPS<\/a> tambahan untuk melindungi database Anda dari akses yang tidak sah.<\/p><p>Kami akan menjelaskannya di poin berikutnya.<\/p><h3 class=\"wp-block-heading\" id=\"h-4-buat-user-phpmyadmin-baru-opsional\">4. Buat User phpMyAdmin Baru (Opsional)<\/h3><p>Dengan <a href=\"\/id\/tutorial\/cara-membuat-hak-akses-user-di-mysql\">membuat pengguna database khusus<\/a>, Anda akan turut meningkatkan keamanan dan kemudahan proses pengelolaan database. Langkah ini berguna apabila database perlu dikelola oleh beberapa pengguna dengan tingkat izin yang berbeda-beda.<\/p><p>Misalnya, web developer mungkin memerlukan hak akses database yang lebih tinggi daripada content manager. Jadi, membuat user khusus untuk peran tertentu akan membantu mengurangi risiko keamanan.<\/p><p><strong>Menggunakan Operasi Command-Line<\/strong><\/p><ol class=\"wp-block-list\">\n<li>Mulailah dengan mengakses server database MySQL Anda. Masukkan kata sandi root saat diminta:<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">sudo mysql -u root -p<\/pre><ol class=\"wp-block-list\" start=\"2\">\n<li>Jalankan kueri ini untuk membuat pengguna baru. Ganti <strong>newuser<\/strong> dan <strong>password <\/strong>dengan kredensial yang Anda inginkan:<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';<\/pre><ol class=\"wp-block-list\" start=\"3\">\n<li>Tetapkan izin kepada pengguna yang baru. Misalnya, untuk memberikan semua hak istimewa pada database bernama <strong>newdatabase<\/strong>, masukkan:<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">GRANT ALL PRIVILEGES ON newdatabase.* TO 'newuser'@'localhost';<\/pre><ol class=\"wp-block-list\" start=\"4\">\n<li>Pastikan pengaturan yang baru sudah diterapkan:<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">FLUSH PRIVILEGES;<\/pre><ol class=\"wp-block-list\" start=\"5\">\n<li>Selanjutnya, Anda bisa keluar dari shell MySQL:<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">EXIT;<\/pre><p><strong>Menggunakan GUI phpMyAdmin<\/strong><\/p><ol class=\"wp-block-list\">\n<li>Buka dashboard phpMyAdmin Anda melalui web browser.<\/li>\n\n\n\n<li>Buka <strong>User accounts<\/strong> <strong>&rarr;<\/strong> <strong>Add user account<\/strong>.<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"69e1dab0066f5\"}' data-wp-interactive=\"core\/image\" class=\"aligncenter size-full wp-lightbox-container\"><img decoding=\"async\" width=\"768\" height=\"417\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on-async--click=\"actions.showLightbox\" data-wp-on-async--load=\"callbacks.setButtonStyles\" data-wp-on-async-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/user-account-phpmyadmin.png\/public\" alt=\"tampilan bagian user phpmyadmin dengan menu add user account yang dipilih\" class=\"wp-image-39095\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/user-account-phpmyadmin.png\/w=768,fit=scale-down 768w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/user-account-phpmyadmin.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/user-account-phpmyadmin.png\/w=150,fit=scale-down 150w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" aria-label=\"Enlarge\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on-async--click=\"actions.showLightbox\" data-wp-style--right=\"state.imageButtonRight\" data-wp-style--top=\"state.imageButtonTop\">\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><\/div><ol class=\"wp-block-list\" start=\"3\">\n<li>Isikan informasi pengguna, seperti username, hostname, dan kata sandi.<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"69e1dab0090bf\"}' data-wp-interactive=\"core\/image\" class=\"aligncenter size-full wp-lightbox-container\"><img decoding=\"async\" width=\"768\" height=\"356\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on-async--click=\"actions.showLightbox\" data-wp-on-async--load=\"callbacks.setButtonStyles\" data-wp-on-async-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/menambahkan-user-phpmyadmin.png\/public\" alt=\"tampilan bagian pengguna di phpmyadmin untuk mengisi informasi pengguna\" class=\"wp-image-39096\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/menambahkan-user-phpmyadmin.png\/w=768,fit=scale-down 768w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/menambahkan-user-phpmyadmin.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/menambahkan-user-phpmyadmin.png\/w=150,fit=scale-down 150w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" aria-label=\"Enlarge\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on-async--click=\"actions.showLightbox\" data-wp-style--right=\"state.imageButtonRight\" data-wp-style--top=\"state.imageButtonTop\">\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><\/div><ol class=\"wp-block-list\" start=\"4\">\n<li>Scroll ke bawah untuk mengatur hak istimewa bagi pengguna yang baru. Anda bisa memilih hak istimewa global atau khusus untuk database tertentu.<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"69e1dab00b952\"}' data-wp-interactive=\"core\/image\" class=\"aligncenter size-full wp-lightbox-container\"><img decoding=\"async\" width=\"768\" height=\"398\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on-async--click=\"actions.showLightbox\" data-wp-on-async--load=\"callbacks.setButtonStyles\" data-wp-on-async-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/global-privileges-phpmyadmin.png\/public\" alt=\"tampilan bagian hak akses phpmyadmin untuk mengatur izin pengguna\" class=\"wp-image-39097\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/global-privileges-phpmyadmin.png\/w=768,fit=scale-down 768w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/global-privileges-phpmyadmin.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/global-privileges-phpmyadmin.png\/w=150,fit=scale-down 150w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" aria-label=\"Enlarge\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on-async--click=\"actions.showLightbox\" data-wp-style--right=\"state.imageButtonRight\" data-wp-style--top=\"state.imageButtonTop\">\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><\/div><ol class=\"wp-block-list\" start=\"5\">\n<li>Klik <strong>Go<\/strong> di bagian bawah halaman untuk membuat akun pengguna.<\/li>\n<\/ol><h3 class=\"wp-block-heading\" id=\"h-5-siapkan-akses-masuk-tambahan-opsional\">5. Siapkan Akses Masuk Tambahan (Opsional)<\/h3><p>Menyiapkan akses masuk tambahan akan membantu Anda bisa meningkatkan keamanan server. Langkah ini akan mencegah akses yang tidak sah dan melindungi informasi sensitif, terutama kalau database Anda berisi data penting atau pribadi.<\/p><p>Ikuti langkah-langkah berikut untuk menyiapkan akses masuk phpMyAdmin:<\/p><ol class=\"wp-block-list\">\n<li>Gunakan <a href=\"\/id\/tutorial\/cara-install-menggunakan-nano-text-editor\">editor teks nano<\/a> untuk membuka file konfigurasi Apache phpMyAdmin:<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">sudo nano \/etc\/apache2\/conf-available\/phpmyadmin.conf<\/pre><ol class=\"wp-block-list\" start=\"2\">\n<li>Di bagian <strong>&lt;Direktori \/usr\/share\/phpmyadmin<\/strong>&gt;, tambahkan direction <strong>AllowOverride All:<\/strong><\/li>\n<\/ol><pre class=\"wp-block-preformatted\">&lt;Directory \/usr\/share\/phpmyadmin&gt;<br><br>&nbsp;&nbsp;&nbsp;&nbsp;Options SymLinksIfOwnerMatch<br><br>&nbsp;&nbsp;&nbsp;&nbsp;DirectoryIndex index.php<br><br>&nbsp;&nbsp;&nbsp;&nbsp;AllowOverride All<br><br>&nbsp;&nbsp;&nbsp;&nbsp;. . .<\/pre><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"69e1dab00e93e\"}' data-wp-interactive=\"core\/image\" class=\"aligncenter size-full wp-lightbox-container\"><img decoding=\"async\" width=\"768\" height=\"238\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on-async--click=\"actions.showLightbox\" data-wp-on-async--load=\"callbacks.setButtonStyles\" data-wp-on-async-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/nano-editor-allow-overides-all.png\/public\" alt=\"tampilan nano text editor dengan allowoverride all yang dipilih\" class=\"wp-image-39098\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/nano-editor-allow-overides-all.png\/w=768,fit=scale-down 768w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/nano-editor-allow-overides-all.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/nano-editor-allow-overides-all.png\/w=150,fit=scale-down 150w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" aria-label=\"Enlarge\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on-async--click=\"actions.showLightbox\" data-wp-style--right=\"state.imageButtonRight\" data-wp-style--top=\"state.imageButtonTop\">\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><\/div><ol class=\"wp-block-list\" start=\"3\">\n<li>Simpan perubahan dan keluar dari editor dengan menekan <strong>Ctrl + X &rarr; Y &rarr; Enter<\/strong>.<\/li>\n\n\n\n<li>Mulai ulang layanan Apache untuk menerapkan pembaruan ini:<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">sudo systemctl restart apache2<\/pre><ol class=\"wp-block-list\" start=\"5\">\n<li>Buka folder phpMyAdmin dan buat file <strong>.htaccess <\/strong>baru:<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">sudo nano \/usr\/share\/phpmyadmin\/.htaccess<\/pre><ol class=\"wp-block-list\" start=\"6\">\n<li>Masukkan directive berikut ini dalam file tersebut. Pengaturan ini akan mengonfigurasi sistem autentikasi dasar, mengatur pesan umum untuk permintaan login, menentukan lokasi file kata sandi, dan membatasi akses hanya untuk pengguna yang diautentikasi:<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">AuthType Basic<br><br>AuthName \"Restricted Files\"<br><br>AuthUserFile \/etc\/phpmyadmin\/.htpasswd<br><br>Require valid-user<\/pre><ol class=\"wp-block-list\" start=\"7\">\n<li>Setelah selesai, simpan dan tutup file.<\/li>\n\n\n\n<li>Buat file kata sandi dengan kata sandi hash untuk autentikasi. Anda bisa mulai dengan user root:<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">sudo htpasswd -c \/etc\/phpmyadmin\/.htpasswd root<\/pre><ol class=\"wp-block-list\" start=\"9\">\n<li>Anda akan diminta untuk membuat dan mengonfirmasi kata sandi. Untuk menambahkan pengguna lagi, gunakan perintah tanpa tanda <strong>-c<\/strong>:<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">sudo htpasswd \/etc\/phpmyadmin\/.htpasswd newuser<\/pre><ol class=\"wp-block-list\" start=\"10\">\n<li>Untuk memastikan semua pengaturan baru Anda sudah aktif, mulai ulang Apache dengan menggunakan perintah <strong>systemctl restart<\/strong> lagi.<\/li>\n\n\n\n<li>Akses phpMyAdmin di browser, lalu masukkan username dan kata sandi yang baru saja Anda buat:<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"768\" height=\"281\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/autentikasi-login-phpmyadmin.png\/public\" alt=\"tampilan halaman login phpmyadmin dengan autentikasi tambahan yang diminta\" class=\"wp-image-39099\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/autentikasi-login-phpmyadmin.png\/w=768,fit=scale-down 768w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/autentikasi-login-phpmyadmin.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2019\/11\/autentikasi-login-phpmyadmin.png\/w=150,fit=scale-down 150w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/figure><\/div><h2 class=\"wp-block-heading\" id=\"h-kesimpulan\">Kesimpulan<\/h2><p>Di tutorial ini, kami sudah membagikan langkah-langkah menginstal phpMyAdmin di Ubuntu lengkap dengan konfigurasinya:<\/p><ol class=\"wp-block-list\">\n<li>Download dan instal phpMyAdmin dari repositori paket.<\/li>\n\n\n\n<li>Buat akun user MySQL yang aman.<\/li>\n\n\n\n<li>Masuk ke phpMyAdmin melalui web browser.<\/li>\n\n\n\n<li>Konfigurasikan akun pengguna tambahan dan izin khusus.<\/li>\n\n\n\n<li>Tambahkan autentikasi <strong>.htaccess <\/strong>untuk meningkatkan keamanan.<\/li>\n<\/ol><p>Dengan mengikuti langkah-langkah ini, Anda pun bisa mengelola database MySQL dalam cara yang lebih praktis menggunakan phpMyAdmin. Jangan lupa untuk menerapkan langkah-langkah keamanan tambahan untuk melindungi sistem database Anda.<\/p><h2 class=\"wp-block-heading\" id=\"h-tanya-jawab-faq-cara-install-phpmyadmin-di-ubuntu\">Tanya Jawab (FAQ) Cara Install phpMyAdmin di Ubuntu<\/h2><p>Bagian ini menjawab beberapa pertanyaan umum tentang cara menginstal phpMyAdmin di Ubuntu.<\/p><div id=\"rank-math-faq\" class=\"rank-math-block\">\n<div class=\"rank-math-list \">\n<div id=\"faq-question-69442cd9b3579\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">Apakah phpMyAdmin Aman?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>phpMyAdmin aman kalau dikonfigurasikan dengan benar. Tool ini menyediakan fitur-fitur seperti pencegahan serangan brute-force dan kontrol akses pengguna. Untuk meningkatkan keamanan konfigurasi web server Anda, gunakan kata sandi yang kuat dan update phpMyAdmin secara teratur.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-69442cd9b357d\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">Bagaimana kalau Lupa Kata Sandi Root MySQL?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Apabila lupa kata sandi root MySQL, Anda bisa mengaturnya ulang dengan menghentikan layanan MySQL dan memulainya dengan opsi <strong>-skip-grant-tables<\/strong> untuk mengaktifkan akses tanpa kata sandi. Kemudian, login sebagai user root dan buat kata sandi baru. Terakhir, mulai ulang MySQL dan login ke database menggunakan kata sandi baru Anda.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-69442cd9b357e\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">Kenapa phpMyAdmin Tidak Bisa Dibuka setelah Diinstal?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Apabila Anda tidak bisa mengakses phpMyAdmin setelah menginstalnya, cek apakah Apache dan PHP sudah dikonfigurasikan dan berjalan dengan benar. Pastikan <strong>phpmyadmin.conf<\/strong> disertakan dalam konfigurasi Apache, dan semua ekstensi PHP yang diperlukan sudah diinstal. Selain itu, pastikan juga layanan MySQL Anda aktif.<\/p>\n\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>phpMyAdmin adalah tool administratif populer yang berfungsi untuk mengelola database MariaDB dan MySQL melalui tampilan yang praktis. Menggunakan tool ini, Anda bisa melakukan tugas-tugas administrasi database, seperti menjalankan kueri, mengelola pengguna dan izin, serta mengekspor dan mengimpor database. Apabila menggunakan VPS (server pribadi virtual) berbasis Linux, Anda bisa menginstal phpMyAdmin untuk mengelola database secara remote [&#8230;]<\/p>\n<p><a class=\"btn btn-secondary understrap-read-more-link\" href=\"\/id\/tutorial\/cara-install-phpmyadmin-ubuntu\">Read More&#8230;<\/a><\/p>\n","protected":false},"author":190,"featured_media":39100,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_title":"Cara Install phpMyAdmin di Ubuntu (Tutorial Lengkap)","rank_math_description":"Berikut cara install phpMyAdmin di Ubuntu: 1. Instal paket phpMyAdmin, 2. Atur izin pengguna, 3. Akses phpMyAdmin. Yuk, baca selengkapnya!","rank_math_focus_keyword":"cara install phpmyadmin di ubuntu, install phpmyadmin ubuntu, install phpmyadmin","footnotes":""},"categories":[5096],"tags":[5516,8803,6300,6252,7804,8802,8801,5639],"class_list":["post-8859","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-vps","tag-apache","tag-gui","tag-lamp","tag-mysql","tag-phpmyadmin","tag-ubuntu-18-04","tag-ubuntu-phpmyadmin","tag-vps"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/tutorials\/how-to-install-and-setup-phpmyadmin-on-ubuntu","default":0},{"locale":"fr-FR","link":"https:\/\/www.hostinger.com\/fr\/tutoriels\/installer-phpmyadmin-sur-ubuntu","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/tutorial\/cara-install-phpmyadmin-ubuntu","default":0},{"locale":"en-UK","link":"https:\/\/www.hostinger.com\/uk\/tutorials\/how-to-install-and-setup-phpmyadmin-on-ubuntu","default":0},{"locale":"en-MY","link":"https:\/\/www.hostinger.com\/my\/tutorials\/how-to-install-and-setup-phpmyadmin-on-ubuntu","default":0},{"locale":"en-PH","link":"https:\/\/www.hostinger.com\/ph\/tutorials\/how-to-install-and-setup-phpmyadmin-on-ubuntu","default":0},{"locale":"en-IN","link":"https:\/\/www.hostinger.com\/in\/tutorials\/how-to-install-and-setup-phpmyadmin-on-ubuntu","default":0},{"locale":"en-CA","link":"https:\/\/www.hostinger.com\/ca\/tutorials\/how-to-install-and-setup-phpmyadmin-on-ubuntu","default":0},{"locale":"en-AU","link":"https:\/\/www.hostinger.com\/au\/tutorials\/how-to-install-and-setup-phpmyadmin-on-ubuntu","default":0},{"locale":"en-NG","link":"https:\/\/www.hostinger.com\/ng\/tutorials\/how-to-install-and-setup-phpmyadmin-on-ubuntu","default":0}],"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/id\/tutorial\/wp-json\/wp\/v2\/posts\/8859","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=8859"}],"version-history":[{"count":9,"href":"https:\/\/www.hostinger.com\/id\/tutorial\/wp-json\/wp\/v2\/posts\/8859\/revisions"}],"predecessor-version":[{"id":47218,"href":"https:\/\/www.hostinger.com\/id\/tutorial\/wp-json\/wp\/v2\/posts\/8859\/revisions\/47218"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/tutorial\/wp-json\/wp\/v2\/media\/39100"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/id\/tutorial\/wp-json\/wp\/v2\/media?parent=8859"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/tutorial\/wp-json\/wp\/v2\/categories?post=8859"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/tutorial\/wp-json\/wp\/v2\/tags?post=8859"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}