Getting Error 404 running phpmyadmin as a sub-directory using Nginx

Question

I have spent almost the entire day debugging this issue with my phpmyadmin installation getting error 404 when I run it using Nginx. I have Googled several pages online, but no solution has worked. However, when I run phpmyadmin as a domain, it works!!

I want to access phpmyadmin as directory such as http://my-server-ip/phpmyadmin

server {
        listen 80 default_server;
        listen [::]:80 default_server;

        root /var/www/html;
        index index.html index.htm index.nginx-debian.html;

        server_name _;

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

        location /phpmyadmin {
            access_log /var/log/nginx/phpmyadmin_access.log;
            error_log /var/log/nginx/phpmyadmin_error.log;

            root   /usr/share/phpmyadmin;
            index  index.php;

            include snippets/fastcgi-php.conf;
            fastcgi_param SCRIPT_FILENAME /usr/share/phpmyadmin/index.php;
            fastcgi_param SCRIPT_NAME /index.php;

        }

        location ~ \.php$ {
                #fastcgi_pass    127.0.0.1:9000;
                fastcgi_pass   unix:/run/php/php7.1-fpm.sock;
                include snippets/fastcgi-php.conf;
                fastcgi_param  SCRIPT_FILENAME  /usr/share/phpmyadmin$fastcgi_script_name;
      }

}

Provide tails of access and error logs please. – Alexander Makarenko Jun 26 '18 at 17:02 — Alexander Makarenko, Jun 26 '18 at 17:02

score 1 · Answer 1 · answered Jun 26 '18 at 17:13

1

You got 404 because nginx is looking for 'phpmyadmin' in '/usr/share/phpmyadmin/'. It means '/usr/share/phpmyadmin/phpmyadmin' Replace 'root' with 'alias' https://nginx.ru/en/docs/http/ngx_http_core_module.html#alias to solve it.

example:

location /phpmyadmin {
        alias   /usr/share/phpmyadmin;
        index  index.php;
        fastcgi_param SCRIPT_FILENAME /usr/share/phpmyadmin/index.php;
        fastcgi_param SCRIPT_NAME /index.php;
        fastcgi_pass   php-fpm;
    }

answered Jun 26 '18 at 17:13

Alexander Makarenko

693
4
10

It turns out you are right. Now the browser can load the phpmyadmin. There's one more problem though; chrome or firefox display a blank page even though I have configured the html/js/css code loads from developer console. It's weird. The error is "There is mismatch between HTTPS indicated on the server and client. This can lead to non working phpMyAdmin or a security risk. Please fix your server configuration to indicate HTTPS properly" – David Okwii Jun 26 '18 at 20:04
have you checked it https://docs.phpmyadmin.net/en/latest/config.html#cfg_Servers_ssl ? – Alexander Makarenko Jun 27 '18 at 11:12

score 1 · Answer 2 · answered Jun 28 '18 at 14:54

I finally got it working with the following config;

server {
    listen   80 default_server;

    access_log /var/log/nginx/phpmyadmin_access.log;
    error_log /var/log/nginx/phpmyadmin_error.log;

    # Main application:
    root /var/www/html;
    index index.php index.html index.htm;

    # phpMyAdmin:
    location /phpmyadmin {
        root /usr/share;
        index index.php;
    }
    # PHP files for phpMyAdmin:
    location ~ ^/phpmyadmin(.+\.php)$ {
        root /usr/share;
        index index.php;
        #fastcgi_read_timeout 300;
        include snippets/fastcgi-php.conf;
        fastcgi_pass unix:/run/php/php7.1-fpm.sock;
    }

    # PHP files for the main application:
    location ~ \.php$ {
        fastcgi_read_timeout 300;
        include snippets/fastcgi-php.conf;
        fastcgi_pass unix:/run/php/php7.1-fpm.sock;
    }
}

Is this in the default nginx config (/etc/nginx/sites-available/default)? or a dedicated config file for phpmyadmin? — Yamen Ashraf, Jul 18 '19 at 13:52
This is a dedicated phpmyadmin file by it's own under /etc/nginx/sites-available/phpmyadmin. — David Okwii, Jul 19 '19 at 19:47

score 0 · Answer 3 · answered Dec 21 '22 at 11:24

Here is few things you should check:

First of all, check tail /var/log/nginx/error.log
Check is www-data owner of phpMyAdmin directory
In nginx configuration, check is location /phpmyadmin above location ~ .php$
Be aware of lower and upper cases, phpMyAdmin and phpmyadmin directories are not the same
Check fastcgi_pass unix:/run/php/php7.1-fpm.sock; - do you have this PHP-FPM version installed on your server

Getting Error 404 running phpmyadmin as a sub-directory using Nginx

3 Answers3