Install Adminer manually on Ubuntu 14.04

adminerAs I wrote over two years ago, Adminer is a very good alternative to PHPMyAdmin. I often find myself looking up that old post, because I frequently install, recommend or update Adminer. After using this software for several years, I am now convinced that it is (has become) much better than PHPMyAdmin. Especially since the new user interface of PHPMyAdmin has become worse. Adminer has progressed a lot and is at version 4.1.0 today. I simply love version 4 and I use it almost daily. The top 3 reasons (for me) to choose it are:
  1. Very clear and consistent user interface
  2. It automatically adds foreign keys
  3. You can easily reorder columns in a table

I think that once you give it a (serious) try, you will never want to use PHPMyAdmin (or any other database management tool) again… ever.

Install Adminer from the repository

It is also great that Adminer is now part of the standard Ubuntu repositories. This means that you can install it with “sudo apt-get install adminer”. However, I do not recommend this. The version of Adminer in the repository is version 3.3.3-1. And it is a very active project with great improvements in every version. Also, upgrading does not hurt, since it handles its dependencies very flexible. In my experience you can run the latest version on any recent Linux without any compatibility issues.

Install Adminer manually

Here are the commands you need for installation (on a Debian based system) that runs Apache 2.4, like Ubuntu 14.04:

sudo mkdir /usr/share/adminer
sudo wget "http://www.adminer.org/latest.php" -O /usr/share/adminer/latest.php
sudo ln -s /usr/share/adminer/latest.php /usr/share/adminer/adminer.php
echo "Alias /adminer.php /usr/share/adminer/adminer.php" | sudo tee /etc/apache2/conf-available/adminer.conf
sudo a2enconf adminer.conf
sudo service apache2 restart

Updating and uninstalling

This is the one-liner for updating Adminer:

sudo wget "http://www.adminer.org/latest.php" -O /usr/share/adminer/latest.php

And these are the commands needed for uninstallation:

sudo a2disconf adminer.conf
sudo service apache2 restart
sudo rm /etc/apache2/conf-available/adminer.conf
sudo rm -Rf /usr/share/adminer

If you know of any tool that is as good as Adminer, then let us know in the comments.

10 thoughts on “Install Adminer manually on Ubuntu 14.04”

  1. I installes manually adminer following your complete indication. Q: How could I put it now in operation?

  2. I installed this through “Webmin” which in turn simply runs the command line commands to install the package. My Problem Is I cannot find anywhere to access it through the web, it did not seem/appear to create a virtualhosts for it or add it to existing. I have used Adminer.php for years by simply uploading the single file to a webserver but was interested to see it as a Linux Package now…just haven’t had luck accessing it so far as that is not described anywhere online it seems

  3. @Jason: The following command installs it as a Linux Package (for Debian based Linux):

    sudo apt-get install adminer

  4. I always thought phpmyadmin is the database tool that i will always use, but since i’ve met adminer and gotten used to it, i am not going back.
    I had difficulties installing Adminer following this tutorial, because there wasn’t any conf-available directories where I can create the virtual host for Adminer on Apache. I later found out that this was because I have Centos OS on my server, while this fine article is for Ubuntu.
    Luckily i found a good tutorial that covered every step for the noobs like me:
    https://www.rosehosting.com/blog/install-adminer-on-a-centos-vps/

    So, if someone has Centos, feel free to use that tutorial.

  5. @Gustaph: Thank you for your link and your explanation, much appreciated!

  6. I have followed these instructions and I keep getting a 404 not found error.

    Any ideas how to fix this?

    Thanks.

  7. @Gerald: Can you post the output of the commands? Did you install apache? Try “sudo apt-get install apache2” and retry.

  8. Could you give an update of the installation for Nginx on Ubuntu 14.04 too or just add it to the article.

    Thanks 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *