You could also use MySQL Workbench (I have used it for a year +), it can be setup to use a ssh tunnel so you don’t need to expose your server to a phpmyadmin and the need for an ssl cert.

Another option (for OSX users) would be: http://www.sequelpro.com/

You can setup a SSL connection and connect to MySQL using socket or localhost. If it’s your own droplet and only you (and/or some colleagues) have to access MySQL, I’d prefer Sequel Pro.

When you need phpMyAdmin? Please use this tutorial to make the internet a safer place ;)

I followed this tutorial and configured phpmyadmin successfully. Then I followed the following article to add a second domain to my Droplet by creating a virtual host ready for two separate Wordpress installs.

https://www.digitalocean.com/community/tutorials/how-to-configure-single-and-multiple-wordpress-site-settings-with-nginx

After I configured the server blocks to create a virtual server to host multiple sites on the server. I lost access to phpmyadmin via the url (ie. domain.com/nothingtosee). Now all that it returns is a 404 error.

Is there a quick fix to this?

Hi, how come after I typed sudo apt-get install phpmyadmin the first question it asked was whether I wanted it to be installed in Apache2 or Lighttd? I’m in Nginx(LEMP) and it’s not even an option for an answer. So I reluctantly selected Apache2. Would that be a problem? Should I uninstall it and start over? If it needs to be uninstalled, how to do that properly? Thanks!

Hi, your tutorial was great. I did have a problem. After accessing phpmyadmin (with htaccess password ), the next time I connected I didn’t get prompted for a password. I didn’t save the password in the browser (chrome and firefox) and I didn’t save cookies (cleared on close). Not sure where it is being saved.

I wanted to try a little more security rather than password protecting access to PhpMyadmin.

I wanted to secure it so that I could only access it from either localhost or my local private network 192.168.100.0.

I made the following changes:

• I undid AllowOverride All
• renamed .htaccess so the password mechanism stopped
• I added Require all denied Allow from 127.0.0.0/255.0.0.0 ::1/128 Allow from localhost
• actually I tried localhost first the i tried both

Now nobody can access phpmyadmin???

Alias /phpmyadmin /usr/share/phpmyadmin

<Directory /usr/share/phpmyadmin> Options FollowSymLinks DirectoryIndex index.php

BT Sept 6,2014

AllowOverride All

    <IfModule mod_php5.c>
            AddType application/x-httpd-php .php
            php_flag magic_quotes_gpc Off
            php_flag track_vars On
            php_flag register_globals Off
            php_admin_flag allow_url_fopen Off
            php_value include_path .
            php_admin_value upload_tmp_dir /var/lib/phpmyadmin/tmp
            php_admin_value open_basedir /usr/share/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/:/usr/share/php/php-gettext/:/usr/share/javascript/
    </IfModule>

BT trying to block PhpMyadmin from Internet

    Require all denied
    Allow from 127.0.0.0/255.0.0.0 ::1/128
    Allow from localhost

</Directory>

Authorize for setup

<Directory /usr/share/phpmyadmin/setup> <IfModule mod_authn_file.c> AuthType Basic AuthName “phpMyAdmin Setup” AuthUserFile /etc/phpmyadmin/htpasswd.setup </IfModule> Require valid-user </Directory>

Disallow web access to directories that don’t need it

<Directory /usr/share/phpmyadmin/libraries> Order Deny,Allow Deny from All </Directory> <Directory /usr/share/phpmyadmin/setup/lib> Order Deny,Allow Deny from All </Directory>

Can you see what’s wrong? thanks

In the above code example:

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

should be:

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

Note the highlighted ‘s’, else NginX could not apply your changes and your server block will cause a parse error.

Hi, Thank you for an excellent tutorial.

Could you please tell us what the right permission should be for the phpmyadmin symbolic link folder in the document root? [ :/ Eh, assuming that’s what it’s called. ]

The current permission for the same folder on my server is 777, should I be changing it to 755?

Thanks and Regards.

sudo ln -s /usr/share/phpmyadmin /usr/share/nginx/html

From apt Nginx we can installed 1.2.1 version, so the html should be changed to www, like this line:

sudo ln -s /usr/share/phpmyadmin /usr/share/nginx/www

only in later version(1.4) the path contains /html

PS: all html lines should be replaced by www

Hi, how to force SSL / HTTPS when you access http://server_domain_or_ip/nothingtosee (the phpmyadmin folder) ?

I’d rather not access phpmyadmin in http mode. Https is more secured

Thanks for this awesome post … could not get into securing my phpadmin installation as I get stuck with a 403 Forbidden error after trying to reach it …;

I set the link as stated :

sudo ln -s /usr/share/phpmyadmin /var/www/html # I’m using the /var directory…

then upon request to http://www.mydomain.net/phpmyadmin

I get a 403 Forbidden result…

in the log I can see : 2014/11/01 15:55:23 [error] 13195#0: *3 directory index of “/var/www/html/phpmyadmin/” is forbidden, client: XX.XX.XXX.XX, server: _, request: “GET /phpmyadmin”

php-fpm is running fine as I can get http://www.mydomain.net/info.php with the info.php file added into /var/www/html

HOWEVER if I request http://www.mydomain.net/phpmyadmin/index.php then I get the login panel…

what am I missing

I cannot get to the phpmyadmin program after following all of these steps. Here’s what I did:

1. I created a new Droplet using the “Drupal 7.32 on Ubuntu 14.04” application image.
2. I followed the steps on how to setup the initial server using the tutorial at Initial Server Setup with Ubuntu 14.04.
3. I followed the steps above in the article on this page.

When I go to http://server_domain_or_IP/phpmyadmin I get a 404 error.

I wonder…in the example above, the public-facing directory is at /var/www/html but with the Drupal image the public-facing directory is at /var/www/html/drupal. I tried modifying the symlink command to this:

sudo ln -s /usr/share/phpmyadmin /usr/share/nginx/html/drupal

but it didn’t help. Any ideas?

Nginx wont start after adding the configuration files

# HTTPS server

server {
	listen 443;
	server_name localhost;

	root html;
	index index.html index.htm;

	ssl on;
	ssl_certificate cert.pem;
	ssl_certificate_key cert.key;

	ssl_session_timeout 5m;

	ssl_protocols SSLv3 TLSv1 TLSv1.1 TLSv1.2;
	ssl_ciphers "HIGH:!aNULL:!MD5 or HIGH:!aNULL:!MD5:!3DES";
	ssl_prefer_server_ciphers on;

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


	location /sql {
        auth_basic "Admin Login";
        auth_basic_user_file /etc/nginx/pma_pass;
    }

}

here am stuck: cd /usr/share/nginx/html ls -l

total 8 -rw-r–r-- 1 root root 537 Mar 4 06:46 50x.html -rw-r–r-- 1 root root 612 Mar 4 06:46 index.html lrwxrwxrwx 1 root root 21 Aug 6 10:50 phpmyadmin -> /usr/share/phpmyadmin

i don’t have a phpmyadmin, just a phpmyadmin.css.php, and when i try on mydomain.com/phpmyadmin nothing hapened, my site apare on this adress too. Help pls.

Now i am getting

403 Forbidden

nginx/1.4.6 (Ubuntu)

Please what if i want phpmyadmin to be in the root of one of my site? how do i set the configuration?

Good day, Thank you for the good work. Please can i install this phpMyAdmin with Nginx on an Ubuntu 14.04 Server on Windows 7 OS with the above steps. I will appreciate your feedback

i installed phpmyadmin with nginx but when i go to http://95.85.39.84/phpmyadmin i still can see just my index.html from http://qbfweb.com/.

Why is it that when I do apt-get install phpmyadmin it also wants to install a bunch of other things like apache? I don’t want apache, I use nginx. Can I make it just download what is required somehow?

After I made a symbolic link:

sudo ln -s /usr/share/phpmyadmin /usr/share/nginx/html

I am trying to acces my phpmyadmin interface through http://my.ip.address.com/phpmyadmin But the only thing I get is a 404 not found page: http://prntscr.com/6e20xe

What now? Do I need to make a seperate conf file for this extension?

Thanks in advance!

Im need add this lines to complete installation.

4. Add the following lines:

      root /usr/share/; 
      index index.php index.html index.htm; 
    location ~ ^/phpmyadmin/(.+\.php)$ { 
      try_files $uri =404; 
      root /usr/share/; 
      fastcgi_pass unix:/var/run/php5-fpm.sock; 
      fastcgi_index index.php; 
      fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name; 
      include fastcgi_params; 
    } 
    location ~* ^/phpmyadmin/(.+\.(jpg|jpeg|gif|css|png|js|ico|html|xml|txt))$ { 
      root /usr/share/; 
    } 
    } 
    location /phpMyAdmin { 
      rewrite ^/* /phpmyadmin last; 
    }```  

5. Save and exit  

6. sudo service nginx restart

Hi Justin, I followed this tutorial and everything worked just fine but the i followed your other tutorial about installing wordpress and now for some reason that has totally flumuxed me i am no long able to access phpmyadmin.

Hope you can help

I followed the instructions, and after installing phpmyadmin, I went to myserverip/phpmyadmin and nothing happens, it just showing the index of the only website that I have installed in my server.

I installed successfully phpmyadmin and yesterday was working. Today I woke up, tried to get access and I’m just getting a 404 not found.

In my server blocks, I already 2 blocks, one named default, and another one which is the one of my WP site.

The default block has this lines: Any ideas?

server {
        listen 80 default_server;
        listen [::]:80 default_server ipv6only=on;

        root /var/www/html;
        index index.php index.html index.htm;

        # Make site accessible from http://localhost/
        server_name myIP;

        location / {
                # First attempt to serve request as file, then
                # as directory, then fall back to displaying a 404.
                # try_files $uri $uri/ =404;
                # Uncomment to enable naxsi on this location
                # include /etc/nginx/naxsi.rules
                try_files $uri $uri/ /index.php?q=$uri&$args;
        }
 location /nothingtosee {
auth_basic "Admin Login";
auth_basic_user_file /etc/nginx/pma_pass;
   }

        error_page 404 /404.html;
        error_page 500 502 503 504 /50x.html;
        location = /50x.html {
                root /usr/share/nginx/html;
        }

        location ~ \.php$ {
                try_files $uri =404;
                fastcgi_split_path_info ^(.+\.php)(/.+)$;
                fastcgi_pass unix:/var/run/php5-fpm.sock;
                fastcgi_index index.php;
                include fastcgi_params;
        }

Works perfect on my droplet thanks.

Lbones, when I do cd /var/www/html and ls -l, this is what I got.

serveruser@LEMP:/var/www/html$ ls -l total 4 drwxr-xr-x 4 www-data www-data 4096 Apr 8 03:09 webs

Got a 403, did a google, added this to my /etc/nginx/sites-available/default file:

location /phpmyadmin {
       index index.php;
    }

restarted nginx:

sudo service nginx restart

Calm restored

Hi, thank you for this tutorial. I have a problem when going to http://mydomain.com/phpmyadmin, for some reason it downloads a file named download, which as some php code inside. Anybody could help me with this?

working for my remote database server

On my HHVM server it installs apache2