How To Install phpMyAdmin With Nginx on Ubuntu 24.10

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

Step 1 : Run the following command to update your package list:

sudo apt update

Step 2 : Install phpMyAdmin using the following command:

sudo apt install phpmyadmin -y

During installation:

- Web server selection: Choose none when prompted.

- Configure database for phpMyAdmin with dbconfig-common: Enter Y.

- MySQL application password for phpMyAdmin: Set a password for phpMyAdmin.

- Password confirmation: Confirm the password.

Step 3 : Create a new Nginx configuration file for phpMyAdmin:

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

Add the following content:

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

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

Step 4 : Ensure the configuration is enabled and properly linked:

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

Step 5 : Check for syntax errors in the Nginx configuration:

sudo nginx -t

Step 6 : Restart Nginx to apply changes:

sudo systemctl restart nginx

Step 7 : Open your browser and go to:

http://your_domain_or_IP/phpmyadmin

Log in using your MySQL username and password.

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