How To Install phpMyAdmin With Nginx on Fedora 40

To install phpMyAdmin with Nginx on Fedora 40, follow these steps:

Step 1 : Update your system:

sudo dnf update

Step 2 : Install phpMyAdmin:

sudo dnf install phpmyadmin

Step 3 : Create Nginx configuration 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$ {
        fastcgi_pass unix:/var/run/php-fpm/www.sock;
        fastcgi_param SCRIPT_FILENAME $request_filename;
        include fastcgi_params;
    }
    location ~ /\.ht {
        deny all;
    }
}

Step 4 : Create a symbolic link from the phpMyAdmin installation directory to the Nginx document root::

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

Step 5 : Test Nginx configuration:

sudo nginx -t

Step 6 : Restart Nginx:

sudo systemctl restart nginx

Step 7 : Access phpMyAdmin:

- Open your browser and go to the URL, for example (phpmyadmin.example.com).

- If you encounter PHP session errors, run the following command to fix:

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

- Refresh the page.

- Log in using your MySQL account.

Congratulations! You have successfully installed phpMyAdmin with Nginx on Fedora 40.