Why replace phpMyAdmin with Adminer?
Replace phpMyAdmin with Adminer and you will get a tidier user interface, better support for MySQL features, higher performance and more security.
Adminer development priorities are: 1. Security, 2. User experience, 3. Performance, 4. Feature set, 5. Size.
Works with MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, SimpleDB, Elasticsearch, MongoDB. And it's only a single PHP file!
After playing around with Adminer, I have to agree with the description above that it is an overall better experience. I will describe two ways to install Adminer and there are more ways at the bottom of this page in the References section.
2. Upload the file to any publicly accessible directory on the server such as: /var/www/html/ or /var/www/html/mysite.com/ or /var/www/html/mysite.com/adminer/ or any other named directory you choose.
For security purposes, you can even change the file name from adminer-4.7.1.php to anything else you want, such as: adminer.php or xyz45secret.php or whatever… (you get the point).
3. Now just point your browser to the file (e.g. https://mysite.com/adminer/xyz45secret.php) to login. That's it! There is no need to specify a specific database on the login screen if you want to view them all.
Method 2 – via the command line
1. SSH into your server
2. (Optionally) Create a new directory (name it whatever you want) and cd into it:
$ sudo mkdir /var/www/html/adminer $ cd /var/www/html/adminer
3. Download the latest version of Adminer into the directory:
$ sudo wget "http://www.adminer.org/latest.php"
4. (Optionally) Change the name of the file to whatever you want:
$ sudo mv latest.php anyname.php
5. Point your browser to the file and login. In this case, https://mysite.com/adminer/anyname.php
More ways to install
You can also intall Adminer via the command ‘sudo apt install adminer' but the version there may be out of date.
To install Adminer into a non-standard directory such as ‘/usr/shar/adminer' see the techrepublic article below in the References section.