Tech

How to Install Adminer on Ubuntu


Adminer is a web-based tool that allows you to manage multiple database systems from a central location. The tool is user-friendly, lightweight, and top-notch in performance with a neat user interface.


The Adminer database manager is available on all Linux distributions. You can easily install and configure it on Ubuntu via the terminal and access its web interface via any browser. You can run database operations directly from the Adminer dashboard and easily manage multiple databases.

Here’s how to install and set up Adminer on Ubuntu.


What Is Adminer?

Alternative to phpMyAdmin, Adminer is an open-source tool for managing multiple databases from a centralized location. The tool has support for MariaDB, MySQL, SQLite, Oracle, PostgreSQL, MongoDB, and Elasticsearch.

Adminer has better security than phpMyAdmin and is lighter in weight. It comes with a clean interface that makes it easy to use and learn. You can access it from the web interface by providing the IP address of the machine running the Adminer instance.

How to Install Adminer on Ubuntu

Here are the steps to install Adminer on Ubuntu-based distributions:

Step 1: Update and Upgrade Ubuntu

Before jumping onto the Adminer installation, you must update and upgrade your system so that you don’t face any issues with new installations. Open the terminal on your Ubuntu machine by pressing Ctrl + Alt + T and run the update and upgrade commands.

 sudo apt update && sudo apt upgrade 

Step 2: Install Apache on Ubuntu

Once you’ve updated and upgraded the system packages, the next task is to install Apache. Do this by running the following command:

 sudo apt install apache2 

Once Apache is successfully installed, enable the service using the systemctl utility:

 sudo systemctl enable  

Also, make sure that Apache is working fine without causing any errors in the background.

 sudo systemctl status apache2  
apache status displayed on Ubuntu terminal

This tells that Apache is active and running fine on Ubuntu.

Step 3: Install PHP on Ubuntu

Since Adminer is written in PHP, you need to install PHP and its essential extensions. To install it, run:

 sudo apt install php php-curl libapache2-mod-php php-cli php-mysql php-gd php-fpm 

Once you’ve successfully installed PHP and its extensions, reload Apache with:

 systemctl reload apache2 

Step 4: Install MariaDB on Ubuntu

After installing PHP, you need a database on your system that you can manage using Adminer. You can install any database such as MySQL, MariaDB, PostgreSQL, MongoDB, SimpleDB, etc.

Since MariaDB is mostly used in many PHP-based applications, let’s install it on Ubuntu.

 sudo apt install mariadb-server 

Once the database is installed, enable it:

 sudo systemctl enable  

Verify if the database is running fine by checking its status:

 sudo systemctl status mariadb 
mariadb status displayed on Ubuntu terminal

This tells MariaDB is in an active state, and working fine on Ubuntu.

After installing MariaDB, you also need to secure it using a script that allows you to set a root password for MariaDB, remove anonymous users, disallow remote root login, and delete the test database. To execute the script, run:

 sudo mysql_secure_installation 

Step 5: Set Admin Password for Adminer

To manage the database using Adminer, you need access to the root database user. For that, you need a root password that will allow you to manage all the databases through Adminer.

To set the password, first, open the MySQL command line:

 sudo mysql 

To set the root password, run:

 SET PASSWORD FOR 'root'@'localhost' = PASSWORD("my password"); 

Make sure to replace “my password” with the password that you want to keep for the root user.

To update the password, execute:

 FLUSH PRIVILEGES; 

To exit the MariaDB command line, run:

 exit; 

Step 6: Install Adminer on Ubuntu

You can install Adminer on Ubuntu using the APT package manager:

 sudo apt install adminer 

Once installed, enable php-fpm:

 sudo a2enconf php*-fpm 

To enable the Apache configuration file for Adminer, execute:

 sudo a2enconf adminer 

Now reload Apache to update the changes you just made:

 systemctl reload apache2 

Once you’ve reloaded Apache, restart it with:

 sudo systemctl restart apache2 

Step 7: Access the Adminer Web Interface

Now that all the necessary installations needed for Adminer have been done, you can access the application via the web interface and start managing your database.

To access Adminer, open a browser and provide the IP address of the machine on which Adminer is running.

If you are running Adminer on the local system, use this address:

 http: 

However, if you are running Adminer on a remote machine, provide the IP address of the machine to access Adminer like this:

 http: 

You will see the following login page on your browser after running the web address to Adminer:

adminer login page displayed on a browser

To log in to Adminer, enter root as the username and provide the password that you set in Step 5. No need to provide the database name as Adminer has access to all the available databases, so leave the Database box empty. After entering all the information asked, click on Login.

Once you have got access, you will find the following dashboard. From here you can access all the available databases to manage them. You can also create or delete a database here.

adminer user interface is displayed on a browser

As you can see, the Adminer interface is simple, not very populated, and hence easy to manage.

How to Uninstall Adminer From Ubuntu

If you no longer need Adminer to manage your databases, you can simply uninstall it from your system. To remove Adminer from Ubuntu, execute:

 sudo apt autoremove  

If you also want to remove MariaDB, Apache, and PHP from your system, that’s also possible by using basic Linux commands.

To do that, you first need to stop these services and then delete them. To stop Apache and MariaDB, execute:

 sudo systemctl stop apache2 mariadb 

Now remove MariaDB, PHP, and Apache with:

 sudo apt autoremove  

Manage All Your Databases Efficiently From a Centralized Adminer Interface

Adminer lets you manage all your databases from a single web interface. You can perform multiple database operations on Adminer such as creating or deleting a database, editing tables, browsing/inserting/editing table rows, sorting columns, editing DB objects and so much more.

There is also no limit to managing databases in Adminer. phpMyAdmin, on the other hand, only has support for MariaDB and MySQL which makes Adminer the go-to database management system. You can choose to go with phpMyAdmin, but you’ll have to install either MariaDB or MySQL on your machine.

Related Articles

Leave a Reply

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

Back to top button