Cara setup phpMyAdmin dengan Nginx

Yang pertama, untuk phpmyadmin pada website resminya phpmyadmin.net/downloads/.

cd /var/www
 wget https://files.phpmyadmin.net/phpMyAdmin/5.2.1/phpMyAdmin-5.2.1-all-languages.zip
 unzip phpMyAdmin-5.2.1-all-languages.zip
 mv phpMyAdmin-5.2.1-all-languages phpmyadmin

Copy config.sample.inc.php

cp config.sample.inc.php config.inc.php

Kemudian buat server-block pada Nginx.

vim /etc/nginx/conf.d/phpmyadmin.conf

Masukan konfigurasi berikut:

server {
    listen 8000;
    server_name _;
    location / {
           root /var/www/phpmyadmin;
           index index.php;
           location ~ ^/(.+\.php)$ {
                   try_files $uri =404;
                   root /var/www/phpmyadmin;
                   fastcgi_pass php;
                   fastcgi_index index.php;
                   fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
                   include /etc/nginx/fastcgi_params;
           }
           location ~* ^/(.+\.(jpg|jpeg|gif|css|png|js|ico|html|xml|txt))$ {
                   root /var/www/phpmyadmin;
           }
    }
}

Jangan lupa konfigurasi juga php-fpm nya, fastcgi_pass php; ganti dengan socket atau listen dimana php-fpm berada.

Simpan dan restart Nginx, akses phpMyadmin melalui URL http://ip_address:8000/

Selesai..