How To Install phpMyAdmin With Nginx on CentOS Stream 9

To install phpMyAdmin with Nginx on CentOS Stream 9, follow these steps:

Step 1 : Begin by updating the system:

sudo dnf update

Step 2 : Install phpMyAdmin using the package manager:

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 from the default phpMyAdmin directory to the Nginx directory:

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

Step 5 : Test Nginx config:

sudo nginx -t

Step 6 : Restart Nginx to apply the changes:

sudo systemctl restart nginx

Step 7 : Access phpMyAdmin

- Open your browser and navigate to phpmyadmin.example.com (replace with your domain).

- If encountering PHP session errors, fix them using the following command:

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 CentOS Stream 9.