How to Install Adminer on Ubuntu

Adminer is a database management application with a straightforward and consistent user interface. It is based on PHP and functions very similarly to PHPMyAdmin. It is extremely light while also being extremely powerful. It is being developed to improve security, user experience, and performance, among other things. Adminer supports MySQL, PostgreSQL, SQLite, MS SQL, and Oracle. This tutorial will teach you how to instal Adminer on Ubuntu 16.04.

Its creator is Jakub Vrána, who began working on it in July 2007 as a lightweight alternative to phpMyAdmin. Adminer received some attention in 2008 when it advanced to the SourceForge CCA finals. In addition, the first webhosting providers began to include Adminer as a MySQL management tool in their service portfolio. Adminer was featured on Linux.com for the second time in 2012. According to the author, the project’s priorities are (in this order): safety, usability, performance, functionality, and size.

Steps to Install Adminer on Ubuntu

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”

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 –now apache2”

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

“sudo systemctl status apache2 –no-pager -l”

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

 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 –now mariadb

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

sudo systemctl status mariadb

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”);

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

What is Adminer

When it comes to lightweight, user-friendly, high-performance MySQL database management tools, Adminer has gained widespread popularity and outperforms phpMyAdmin in many ways. Jakub Vrana created this database management tool in 2007 as an alternative to phpMyAdmin, so all you have to do is download and install a single, lightweight PHP file on your application’s database.

It is also free to use and written in PHP as an open source database management tool. A good user interface design for a seamless user experience, as well as strong security features to keep data safe from any attacks or malicious hacking attempts, distinguishes this web-based database management system. This database management tool is simple to install and requires only basic requirements such as Ubuntu and LAMP. Users can find detailed documentation on development and deployment. As a result, the source code for this web-based database management system can be found on GitHub. It has a variety of database functions, such as selecting a database, editing tables, inserting/editing data in tables, and sorting/searching data in multiple columns.

Databases supported include MySQL, PostgreSQL, SQLite, MS SQL, Oracle, and SimpleDB, among others. It’s available in 43 different languages, including English, Arabic, Persian, Polish, and Dutch. Views, triggers, stored procedures, user permissions, and other database objects can be easily edited. Adminer also protects against SQL injection, session stealing, cross-site scripting (XSS), software attacks, and other threats.

Final Words

That’s it with our article on How to Install Adminer on Ubuntu. Adminer, written in PHP, is an open-source web-based database management tool. Adminer outperforms phpMyAdmin in terms of UI, performance, and security. It also has better MySQL feature support. It supports MySQL, MariaDB, PostgreSQL, Elasticsearch, MongoDB, SQLite, MS SQL, Oracle, and SimpleDB databases, among others. It is available in a variety of languages, including Persian, English, Dutch, Portuguese, Arabic, and others.