How To Install phpMyAdmin With Nginx on CentOS Stream 10

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

Step 1 : Before starting, ensure your system is up to date:

sudo dnf update -y

Step 2 : Navigate to your home directory and download the latest version of phpMyAdmin:

cd ~/
wget https://www.phpmyadmin.net/downloads/phpMyAdmin-latest-all-languages.zip

Step 3 : Unzip the downloaded file and move it to your web root directory:

unzip phpMyAdmin-latest-all-languages.zip
sudo mv phpMyAdmin-*-all-languages /usr/share/phpMyAdmin

Step 4 : Set ownership and permissions to ensure proper access:

sudo chown -R nginx:nginx /usr/share/phpMyAdmin
sudo chmod -R 755 /usr/share/phpMyAdmin

Step 5 : If SELinux is enabled on your system, you need to adjust its policies to allow phpMyAdmin to function:

sudo semanage fcontext -a -t httpd_sys_rw_content_t "/usr/share/phpMyAdmin(/.*)?"
sudo restorecon -R /usr/share/phpMyAdmin

Step 6 : Create an Nginx configuration file for phpMyAdmin:

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

Add the following content:

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 fastcgi_params;
        fastcgi_pass unix:/var/run/php-fpm/www.sock;
        fastcgi_index index.php;
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
    }
}

Save and close the file.

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

sudo systemctl restart nginx

Step 8 : You can now access phpMyAdmin by navigating to your domain in a web browser:

- If you encounter a PHP session error, run the following command to fix it

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

- Refresh the page to apply the changes.

- You can now log in to phpMyAdmin using your MySQL credentials.

Congratulations! You have successfully installed and configured phpMyAdmin with Nginx on CentOS Stream 10.