How To Install phpMyAdmin With Nginx on Rocky Linux 9

To install phpMyAdmin with Nginx on Rocky Linux 9, follow these steps.

Step 1 : Begin by updating the system:

sudo dnf update

Step 2 : Install phpMyAdmin using the following command:

sudo dnf install phpmyadmin

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

sudo nano /etc/nginx/conf.d/phpmyadmin.conf

- Add the following configuration:

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

    root /usr/share/nginx/phpMyAdmin;
    index index.php index.html index.htm;

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

    location ~ \.php$ {
        include fastcgi_params;
        fastcgi_pass unix:/var/run/php-fpm/www.sock;
        fastcgi_index index.php;
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
    }
}

Step 4 : Create a symbolic link to the phpMyAdmin directory:

sudo ln -s /usr/share/phpMyAdmin /usr/share/nginx/phpMyAdmin

Step 5 : Check if the Nginx configuration is valid:

sudo nginx -t

Step 6 : Restart the Nginx service to apply the changes:

sudo systemctl restart nginx

Step 7 : Access phpMyAdmin

- Visit the phpMyAdmin URL, e.g., http://phpmyadmin.example.com

- If encountering a PHP session error, run the following command to fix it:

sudo chown -R nginx:nginx /var/lib/php/session

- Refresh the page

- Log in with your MySQL account

Congratulations, you have successfully installed and configured phpMyAdmin with Nginx on Rocky Linux 9!