How To Install phpMyAdmin With Nginx on Ubuntu 23.10

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

Step 1 : Update System Packages:

sudo apt update

Step 2 : Install phpMyAdmin

- Run the following command to install phpMyAdmin:

 sudo apt install phpmyadmin

Step 3 : During the installation process, you will be prompted with configuration options. Here's how to fill in the information:

- Web server to reconfigure automatically: Choose none because we will manually configure Nginx.

- Configure database for phpmyadmin with dbconfig-common: Choose Yes.

- Set a password for the phpMyAdmin user in the MySQL database.

- Password confirmation: Re-enter the password for the phpMyAdmin user to confirm.

Step 4 : Configure Nginx for phpMyAdmin:

Create a new Nginx server block for phpMyAdmin. For example, create a file named phpmyadmin in the /etc/nginx/sites-available/ directory:

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

Add the following configuration:

server {
    listen 80;
    server_name phpmyadmin.example.com;
     root /usr/share/phpmyadmin;
    index index.php index.html index.htm;
     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 PHP version as needed
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
        include fastcgi_params;
    }
     location ~ /\.ht {
        deny all;
    }
}

Save the file and exit the text editor.

Step 5 : Create a symbolic link:

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

Step 6 : Test Nginx configuration:

sudo nginx -t

If the test is successful, 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 credentials.

Now, phpMyAdmin should be installed and configured to work with Nginx on your Ubuntu 23.10 server. You can log in using the phpMyAdmin interface with the credentials you provided during the installation.