How To Install phpMyAdmin With Nginx on AlmaLinux 9

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

Step 1 : Update the System

Run the following command to update your system packages:

sudo dnf update -y

Step 2 : Install phpMyAdmin

Install phpMyAdmin using the package manager:

sudo dnf install phpmyadmin -y

Step 3 : Create a Symbolic Link for phpMyAdmin

Run the following command to link phpMyAdmin to the Nginx web directory:

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

Step 4 : Create an Nginx Configuration for phpMyAdmin

Create a new configuration file for phpMyAdmin under /etc/nginx/conf.d/phpmyadmin.conf:

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

Add the following configuration (adjust the domain as needed):

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;
    }
}

Save and exit the file.

Step 5 : Test Nginx Configuration

Check if there are any syntax errors in your Nginx configuration:

sudo nginx -t

If there are no errors, proceed to the next step.

Step 6 : Restart Nginx

Apply the changes by restarting Nginx:

sudo systemctl restart nginx

Step 7 : Access phpMyAdmin

- Open your browser and go to: http://phpmyadmin.example.com

- If you encounter a PHP session error, run the following command:

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

- Refresh the page.

- Log in using your MySQL credentials.

Congratulations! You have successfully installed and configured phpMyAdmin with Nginx on AlmaLinux 9.