{"id":1526,"date":"2019-07-18T00:21:55","date_gmt":"2019-07-17T17:21:55","guid":{"rendered":"https:\/\/www.linuxid.net\/post\/?p=1526"},"modified":"2025-04-18T15:21:57","modified_gmt":"2025-04-18T08:21:57","slug":"cara-install-dan-konfigurasi-phpmyadmin-di-nginx-ubuntu-18-04","status":"publish","type":"post","link":"https:\/\/www.linuxid.net\/post\/cara-install-dan-konfigurasi-phpmyadmin-di-nginx-ubuntu-18-04\/","title":{"rendered":"Cara Install dan Konfigurasi phpMyAdmin di Nginx Ubuntu 18.04"},"content":{"rendered":"

phpMyAdmin adalah tools yang free dan open source untuk mengelola server MySQL dan MariaDB melalui antarmuka berbasis web.<\/p>\n

Dengan phpMyAdmin, Anda dapat membuat dan mengelola database dan pengguna, menjalankan statement SQL, mengimpor dan mengekspor data, dan melakukan aktivitas basis data seperti, membuat, menghapus, tables, columns, indeks, izin, dan banyak lagi.<\/p>\n

Dalam tutorial ini, kami akan menunjukkan kepada Anda cara menginstal dan konfigurasi phpMyAdmin dengan Nginx di Ubuntu 18.04 server.<\/p>\n

Persyaratan Tutorial<\/h2>\n

Langkah awal<\/h2>\n

Perbarui paket sistem operasi (software) Anda. Ini adalah langkah pertama yang penting karena memastikan Anda memiliki pembaruan terbaru dan perbaikan keamanan untuk paket perangkat lunak default sistem operasi Anda:<\/p>\n

sudo apt-get update && sudo apt-get upgrade -y<\/pre>\n
Setelah sistem di perbarui, restart server untuk menerapkan konfigurasi dan meminimalisir terjadinya kesalahan.<\/p>\n
Install LEMP Server<\/h2>\n
Pertama, Anda harus menginstal Nginx, MariaDB, PHP dan library PHP lainnya ke server. Anda dapat menginstal semuanya dengan perintah berikut:<\/p>\n
sudo apt-get install nginx php7.2 php7.2-common php7.2-mysql php7.2-mbstring php7.2-fpm php7.2-cgi php7.2-common php-pear php-gettext mariadb-server -y<\/pre>\n
Setelah semua paket diinstal, mulai layanan Nginx<\/a> dan MariaDB dan aktifkan untuk memulai setelah sistem reboot dengan perintah berikut:<\/p>\n
sudo systemctl start nginx
\n sudo systemctl start mariadb
\n sudo systemctl enable nginx
\n sudo systemctl enable mariadb<\/pre>\n
Install phpMyAdmin<\/h2>\n
Secara default,\u00a0 phpMyAdmin tersedia di repositori default di repositori Ubuntu 18.04. Anda dapat menginstall phpMyAdmin dengan perintah apt<\/code> <\/a>seperti berikut :<\/p>\n
sudo apt-get install phpmyadmin -y<\/pre>\n
Selama instalasi, installer akan meminta Anda untuk memilih server web seperti yang ditunjukkan pada halaman berikut.<\/p>\n
\"Configuring<\/a><\/p>\n
Jangan pilih opsi apa pun, karena kita akan menggunakan Nginx sebagai web server . Jadi, cukup tekan Enter<\/strong> untuk memilik tombol OK. Selanjutnya, Anda akan diminta untuk mengatur database seperti yang ditunjukkan pada halaman berikut:<\/p>\n
\"Database<\/a><\/p>\n
Arahkan dengan tombol tab atau arah panah, tekan Enter<\/strong> untuk pilih tombol No<\/strong>.\u00a0Anda akan melihat halaman berikut:<\/p>\n
\"MySQL<\/a><\/p>\n
Sekarang, berikan kata sandi untuk phpMyAdmin untuk dapat terhubung dengan database dan tekan Enter<\/strong> untuk pilih tombol Ok<\/strong>.\u00a0Anda akan diminta untuk mengonfirmasi kata sandi lagi. Berikan kata sandi yang sama dan klik tombol Ok<\/strong> untuk menyelesaikan instalasi.<\/p>\n
Konfigurasi Database<\/h2>\n
Pertama, masuk ke shell MariaDB dengan perintah berikut:<\/p>\n
sudo mysql<\/pre>\n
Selanjutnya, buat akun user<\/a> administrator baru dan berikan izin yang sesuai dengan perintah berikut:<\/p>\n
MariaDB [(none)]> CREATE USER 'phpadmin'@'localhost' IDENTIFIED BY 'g4nt!_d3n9an_p4$$w0rd<\/span>';
\n MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'phpadmin'@'localhost' WITH GRANT OPTION;<\/pre>\n
Ganti kata \u2018g4nt!_d3n9an_p4$$w0rd<\/span>\u2018 dengan kata sandi pilihan Anda yang aman. Sekarang, keluar dari shell MariaDB dengan perintah berikut:<\/p>\n
MariaDB [(none)]>EXIT;<\/pre>\n
Konfigurasikan Nginx<\/h2>\n
Selanjutnya, Anda perlu membuat file virtual\u00a0host<\/a>\u00a0 Nginx. Anda dapat melakukan ini dengan perintah berikut:<\/p>\n
sudo nano \/etc\/nginx\/sites-available\/phpmyadmin.conf<\/pre>\n
Tambahkan baris berikut:<\/p>\n
server {
\n        listen 80 default_server;
\n        listen [::]:80 default_server;
\n        root \/var\/www\/html;
\n
\n        # Add index.php to the list if you are using PHP
\n        index index.php index.html index.htm index.nginx-debian.html;
\n
\n        # ganti dengan server IP, misal 123.456.78.90
\n        server_name gantidenganserverip;<\/span>
\n
\n        location ~ \\.php$ {
\ninclude snippets\/fastcgi-php.conf;
\nfastcgi_pass unix:\/var\/run\/php\/php7.2-fpm.sock;
\nfastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
\ninclude fastcgi_params;
\n       }
\n}
\n<\/pre>\n
Simpan dan tutup file. Kemudian, periksa Nginx untuk setiap kesalahan sintaks dengan perintah berikut:<\/p>\n
sudo nginx -t<\/pre>\n
Jika tidak ada kesalahan di pengaturan Nginx, Anda akan melihat output berikut:<\/p>\n
nginx: the configuration file \/etc\/nginx\/nginx.conf syntax is ok
\nnginx: configuration file \/etc\/nginx\/nginx.conf test is successful
\n<\/pre>\n
Selanjutnya, aktifkan file virtual\u00a0host phpmyadmin dengan melakukan symlink<\/a> ke sites-enabled<\/code> dan hapus file<\/a> virtual\u00a0host default dengan perintah berikut:<\/p>\n
sudo rm -rf \/etc\/nginx\/sites-enabled\/default
\n sudo ln -s \/etc\/nginx\/sites-available\/phpmyadmin.conf \/etc\/nginx\/sites-enabled\/<\/pre>\n
Selanjutnya, restart Nginx service<\/a> untuk menerapkan perubahan dengan perintah berikut:<\/p>\n
sudo systemctl restart nginx<\/pre>\n
Selanjutnya, periksa status Nginx dengan perintah berikut:<\/p>\n
sudo systemctl status nginx<\/pre>\n
Anda akan melihat output berikut:<\/p>\n
? nginx.service - A high performance web server and a reverse proxy server
\n   Loaded: loaded (\/lib\/systemd\/system\/nginx.service; enabled; vendor preset: enabled)
\n   Active: active (running) since Tue 2019-01-15 11:10:29 UTC; 2min 0s ago
\n     Docs: man:nginx(8)
\n  Process: 14871 ExecStop=\/sbin\/start-stop-daemon --quiet --stop --retry QUIT\/5 --pidfile \/run\/nginx.pid (code=exited, status=0\/SUCCESS)
\n  Process: 14885 ExecStart=\/usr\/sbin\/nginx -g daemon on; master_process on; (code=exited, status=0\/SUCCESS)
\n  Process: 14874 ExecStartPre=\/usr\/sbin\/nginx -t -q -g daemon on; master_process on; (code=exited, status=0\/SUCCESS)
\n Main PID: 14886 (nginx)
\n    Tasks: 2 (limit: 1113)
\n   CGroup: \/system.slice\/nginx.service
\n??14886 nginx: master process \/usr\/sbin\/nginx -g daemon on; master_process on;
\n??14887 nginx: worker process
\n
\nJul 15 11:10:29 ubuntu1804 systemd[1]: Stopped A high performance web server and a reverse proxy server.
\nJul 15 11:10:29 ubuntu1804 systemd[1]: Starting A high performance web server and a reverse proxy server...
\nJul 15 11:10:29 ubuntu1804 systemd[1]: nginx.service: Failed to parse PID from file \/run\/nginx.pid: Invalid argument
\nJul 15 11:10:29 ubuntu1804 systemd[1]: Started A high performance web server and a reverse proxy server.
\n<\/pre>\n
Akses phpMyAdmin<\/h2>\n
phpMyAdmin sekarang diinstal dan dikonfigurasi, saatnya untuk mengakses antarmuka web phpMyAdmin.<\/p>\n
Buka browser web Anda dan ketik URL http:\/\/serverIP\/phpmyadmin\/<\/code>. Anda akan diarahkan ke halaman berikut:<\/p>\n
\"PHPMyAdmin<\/a><\/p>\n
Sekarang, berikan nama user dan kata sandi. Kemudian, klik tombol Go<\/strong>. Anda akan melihat dasbor default phpMyAdmin di halaman berikut:<\/p>\n
\"page<\/a><\/p>\n
Selamat! Anda telah berhasil menginstal dan mengkonfigurasi phpMyAdmin ke server Ubuntu 18.04 LTS. Anda sekarang dapat mengelola\u00a0database MariaDB Anda melalui antarmuka berbasis web phpMyAdmin.<\/p>\n","protected":false},"excerpt":{"rendered":"
phpMyAdmin adalah tools yang free dan open source untuk mengelola server MySQL dan MariaDB melalui…<\/p>\n","protected":false},"author":2,"featured_media":1527,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[44,151,171,166,9,129],"class_list":["post-1526","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ubuntu","tag-cms","tag-database","tag-phpmyadmin","tag-sql","tag-ubuntu","tag-ubuntu-18-04"],"yoast_head":"\nCara Install dan Konfigurasi phpMyAdmin di Nginx Ubuntu 18.04 - Linuxid<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-phpmyadmin-di-nginx-ubuntu-18-04\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Install dan Konfigurasi phpMyAdmin di Nginx Ubuntu 18.04 - Linuxid\" \/>\n<meta property=\"og:description\" content=\"phpMyAdmin adalah tools yang free dan open source untuk mengelola server MySQL dan MariaDB melalui…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-phpmyadmin-di-nginx-ubuntu-18-04\/\" \/>\n<meta property=\"og:site_name\" content=\"Linuxid\" \/>\n<meta property=\"article:published_time\" content=\"2019-07-17T17:21:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-18T08:21:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/linuxid.net\/post\/wp-content\/uploads\/2025\/03\/4_page3.png\" \/>\n\t<meta property=\"og:image:width\" content=\"550\" \/>\n\t<meta property=\"og:image:height\" content=\"172\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"xsand\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"xsand\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-phpmyadmin-di-nginx-ubuntu-18-04\/\",\"url\":\"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-phpmyadmin-di-nginx-ubuntu-18-04\/\",\"name\":\"Cara Install dan Konfigurasi phpMyAdmin di Nginx Ubuntu 18.04 - Linuxid\",\"isPartOf\":{\"@id\":\"https:\/\/linuxid.net\/post\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-phpmyadmin-di-nginx-ubuntu-18-04\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-phpmyadmin-di-nginx-ubuntu-18-04\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/4_page3.png\",\"datePublished\":\"2019-07-17T17:21:55+00:00\",\"dateModified\":\"2025-04-18T08:21:57+00:00\",\"author\":{\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79\"},\"breadcrumb\":{\"@id\":\"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-phpmyadmin-di-nginx-ubuntu-18-04\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-phpmyadmin-di-nginx-ubuntu-18-04\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-phpmyadmin-di-nginx-ubuntu-18-04\/#primaryimage\",\"url\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/4_page3.png\",\"contentUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/4_page3.png\",\"width\":550,\"height\":172},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-phpmyadmin-di-nginx-ubuntu-18-04\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Beranda\",\"item\":\"https:\/\/linuxid.net\/post\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara Install dan Konfigurasi phpMyAdmin di Nginx Ubuntu 18.04\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/linuxid.net\/post\/#website\",\"url\":\"https:\/\/linuxid.net\/post\/\",\"name\":\"Linuxid\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/linuxid.net\/post\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79\",\"name\":\"xsand\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g\",\"caption\":\"xsand\"},\"url\":\"https:\/\/www.linuxid.net\/post\/author\/xsand\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Install dan Konfigurasi phpMyAdmin di Nginx Ubuntu 18.04 - Linuxid","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-phpmyadmin-di-nginx-ubuntu-18-04\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Install dan Konfigurasi phpMyAdmin di Nginx Ubuntu 18.04 - Linuxid","og_description":"phpMyAdmin adalah tools yang free dan open source untuk mengelola server MySQL dan MariaDB melalui…","og_url":"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-phpmyadmin-di-nginx-ubuntu-18-04\/","og_site_name":"Linuxid","article_published_time":"2019-07-17T17:21:55+00:00","article_modified_time":"2025-04-18T08:21:57+00:00","og_image":[{"width":550,"height":172,"url":"https:\/\/linuxid.net\/post\/wp-content\/uploads\/2025\/03\/4_page3.png","type":"image\/png"}],"author":"xsand","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"xsand","Estimasi waktu membaca":"4 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-phpmyadmin-di-nginx-ubuntu-18-04\/","url":"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-phpmyadmin-di-nginx-ubuntu-18-04\/","name":"Cara Install dan Konfigurasi phpMyAdmin di Nginx Ubuntu 18.04 - Linuxid","isPartOf":{"@id":"https:\/\/linuxid.net\/post\/#website"},"primaryImageOfPage":{"@id":"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-phpmyadmin-di-nginx-ubuntu-18-04\/#primaryimage"},"image":{"@id":"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-phpmyadmin-di-nginx-ubuntu-18-04\/#primaryimage"},"thumbnailUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/4_page3.png","datePublished":"2019-07-17T17:21:55+00:00","dateModified":"2025-04-18T08:21:57+00:00","author":{"@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79"},"breadcrumb":{"@id":"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-phpmyadmin-di-nginx-ubuntu-18-04\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-phpmyadmin-di-nginx-ubuntu-18-04\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-phpmyadmin-di-nginx-ubuntu-18-04\/#primaryimage","url":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/4_page3.png","contentUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/4_page3.png","width":550,"height":172},{"@type":"BreadcrumbList","@id":"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-phpmyadmin-di-nginx-ubuntu-18-04\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Beranda","item":"https:\/\/linuxid.net\/post\/"},{"@type":"ListItem","position":2,"name":"Cara Install dan Konfigurasi phpMyAdmin di Nginx Ubuntu 18.04"}]},{"@type":"WebSite","@id":"https:\/\/linuxid.net\/post\/#website","url":"https:\/\/linuxid.net\/post\/","name":"Linuxid","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/linuxid.net\/post\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79","name":"xsand","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g","caption":"xsand"},"url":"https:\/\/www.linuxid.net\/post\/author\/xsand\/"}]}},"_links":{"self":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1526","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/comments?post=1526"}],"version-history":[{"count":1,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1526\/revisions"}],"predecessor-version":[{"id":2885,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1526\/revisions\/2885"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media\/1527"}],"wp:attachment":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media?parent=1526"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/categories?post=1526"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/tags?post=1526"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}