How To Install phpMyAdmin With Nginx on Ubuntu 23.04

To install phpMyAdmin with Nginx on Ubuntu 23.04, follow these steps:

Step 1 : Update

sudo apt update
sudo apt upgrade

Step 2 : Install phpMyAdmin

sudo apt install phpmyadmin

Web server selection: Choose None

Configure database for phpmyadmin with dbconfig-common: Yes

MySQL application password for phpmyadmin: Enter your desired password

Password confirmation: Confirm the password

Step 3 : Create Nginx Configuration for phpMyAdmin

sudo nano /etc/nginx/sites-available/phpmyadmin

Paste the following configuration:

server {
    listen 80;
    server_name phpmyadmin.example.com;

    root /usr/share/phpmyadmin;
    index index.php;

    location / {
        try_files $uri $uri/ =404;
    }

    location ~ \.php$ {
        include snippets/fastcgi-php.conf;
        fastcgi_pass unix:/var/run/php/php8.1-fpm.sock; # Adjust PHP version accordingly
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
        include fastcgi_params;
    }

    location ~ /\.ht {
        deny all;
    }
}

Step 4 : Enable the Nginx Configuration

sudo ln -s /etc/nginx/sites-available/phpmyadmin /etc/nginx/sites-enabled

Step 5 : Test Nginx Configuration

sudo nginx -t

Step 6 : Restart Nginx

sudo systemctl restart nginx

Step 7 : Access phpMyAdmin

Open your web browser and navigate to http://phpmyadmin.example.com.

Log in with your MySQL username and password that you use to access the MySQL database server.

Congratulations! You have successfully installed and configured phpMyAdmin with Nginx on Ubuntu 23.04.