How To Install phpMyAdmin With Nginx on Ubuntu 22.04

To install phpMyAdmin with Nginx on Ubuntu 22.04, you can follow these steps:

Step 1 : Update Package List:

sudo apt update

Step 2 : Install phpMyAdmin:

sudo apt install phpmyadmin

During the installation, you will be prompted to choose a web server. Select none since we will configure Nginx separately.

When prompted to configure the database for phpMyAdmin, choose dbconfig-common.

Create a MySQL application password for phpMyAdmin when prompted

Password confirmation:

Step 3 : Configure Nginx for phpMyAdmin:

Create a new Nginx server block configuration for phpMyAdmin. Create a new file:

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

Add the following configuration:

server {
    listen 80;
    server_name phpmyadmin.your_domain;

    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.2-fpm.sock; # Adjust the version if needed
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
        include fastcgi_params;
    }

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

Replace phpmyadmin.your_domain with your server's domain name.

Step 4 : Enable the phpMyAdmin Nginx Configuration:

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

Step 5 : Test Nginx Configuration:

sudo nginx -t

If the configuration test is successful, reload Nginx:

sudo systemctl reload nginx

Step 6 : Access phpMyAdmin:

Open your web browser and navigate to http://phpmyadmin.your_domain. You should see the phpMyAdmin login page.

Log in with your MySQL/MariaDB credentials.

Remember to replace your_domain with your actual domain.

You have successfully installed and configured phpMyAdmin with Nginx on Ubuntu 22.04.