Linux Mint

How to Install Adminer on Linux Mint 21

Adminer is a database management tool that is far better than PHPMyAdmin as it has a much better UI, more secure in terms of security and gives better performance. PHPMyAdmin has a drawback that it only supports the MySQL database system while Adminer can be used to manage other database management systems as well, like PostgreSQL, SQLite, MongoDB, Oracle and Amazon SimpleDB.

This guide gives the detailed process of installing the Adminer database management tool on Linux Mint.

Prerequisites for installing Adminer on Linux Mint

To successfully install Adminer there are some essential elements that should be installed on Linux Mint and for that go through the subsequent steps:

Step 1: Before installing any application on Linux Mint it is recommended to update the packages list:

$ sudo apt update

Step 2: Next, install Apache2 and MariaDB along with the PHP packages on Linux Mint using the default package manager:

$ sudo apt install mariadb-server php-curl libapache2-mod-php php-cli php-mysql php-gd apache2 php -y

Step 3: Next enable the Apache2 server that we installed in the previous step using:

$ sudo systemctl enable apache2

Next, start the server:

$ sudo systemctl start apache2

Step 4: Now enable the MariaDB using:

$ sudo systemctl enable mariadb

Next, start the MariaDB using:

$ sudo systemctl start mariadb

Step 5: Now setup the MariaDB on Linux Mint using:

$ sudo mysql_secure_installation

Now allow the socket authentication and after that set the root password if you think the current password is quite easy to guess. Next, allow removal of anonymous users and keep the option of remote login:

Next disallow the test database removal by typing n:

Step 6: Now run the database using:

$ sudo mysql

There is another way to run the database MariaDB using:

$ sudo mariadb

Next set the password for the root login for this database management tool using the following syntax:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD("<Your-password>");

Now to apply the changes use:

FLUSH PRIVILEGES;

Next exit the database using exit command:

EXIT;

Installing Adminer on Linux Mint 21

Once all the Prerequisites for Adminer are installed let’s move to its installation, below are respective steps that one needs to install Adminer in Linux Mint:

Step 1: Now install the Adminer using the apt package manager:

$ sudo apt install adminer -y

Step 2: Now, configure the Adminer using:

$ sudo a2enconf adminer

Now reload the Apache server to activate the Adminer new configuration using:

$ sudo systemctl reload apache2

Step 3: Now everything is setup and it’s time to access the Adminer a web-based database management tool by entering IP address of Linux Mint (simply use localhost or 127.0.0.1) system along with Adminer in the address of the browser:

127.0.0.1/adminer/

Now login through the root password that you entered previously during configuration of server:

If you no longer need to use the Adminer then to remove it from the Linux Mint system entirely using:

$ sudo apt remove --autoremove adminer -y

Conclusion

Adminer is one of the best web-based management tools for databases that one can rely on as it can manage both relational and non-relational database management systems.The Adminer can be installed on Linux Mint 21 systems by using its default package manager.

About the author

Aaliyan Javaid

I am an electrical engineer and a technical blogger. My keen interest in embedded systems has led me to write and share my knowledge about them.