Set up Adminer on Debian 11: Best Database Manager

In this guide, we want to teach you to Set up Adminer on Debian 11. Adminer is a tool for managing the contents of MySQL databases, formerly known as phpMinAdmin. It’s a single tiny PHP file. 

Adminer provides:

  • An easy-to-use interface.
  • Better support for many MySQL features.
  • A more remarkable performance.
  • Increased security.

Unlike phpMyAdmin, which only supports the management of MySQL and MariaDB databases, Adminer also supports managing other databases such as PostgreSQL, SQLite, MS SQL, Oracle, SimpleDB, Elasticsearch, MongoDB, and Firebird. It is also available in 43 languages.

Now follow the guide steps below on the Orcacore website to Set up Adminer on Debian 11.

Steps To Set up Adminer on Debian 11

To complete this guide, log in to your server as a non-root user with sudo privileges. To do this, you can follow our guide on Initial Server Setup with Debian 11.

Also, you need to have LAMP Stack installed on your server. For this purpose, you can follow our guide on How To Install LAMP Stack on Debian 11.

1. Set root Database password for Adminer

When you are done with the requirements, run the command below to install an additional PHP extension:

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

Then, you need to set a root database password for Adminer. This will help you to manage all available databases using Adminer. To do this, log in to your MariaDB shell:

sudo mysql -u root -p

Now, set the password for the root user with the command below:

MariaDB [(none)]> SET PASSWORD FOR 'root'@'localhost' = PASSWORD("password");

Next, flush the privileges and exit from the MariaDB shell:

MariaDB [(none)]> FLUSH PRIVILEGES;
MariaDB [(none)]> exit;

2. Install Adminer on Debian 11

Adminer packages are available in the default Debian repository. You can easily install it by using the command below:

sudo apt install adminer -y

Then, enable the Apache configuration file for Adminer on Debian 11:

sudo a2enconf adminer

Finally, restart Apache to apply the changes:

sudo systemctl restart apache2

3. Access Adminer Web Interface

At this point, you can access the Adminer web interface by typing your server’s IP address in your web browser followed by /adminer:

http://server-ip-address/adminer

You will see the Adminer default Login screen. You should enter the root as the username and the password that you have configured for the Adminer.

Adminer default Login Screen
Adminer Default Login Screen

After accessing Adminer default login, you will have the Dashboard to access all the available databases. You can delete or create a database as well. However, the interface of Amdiner is not as rich as that of PhpMyAdmin, yet simple, easy to navigate, understandable, and not confusing.

Adminer dashboard
Adminer Dashboard

4. Uninstall Adminer from Debian 11

If you don’t want the Adminer Database system manager anymore on your Debian system; then you can remove it completely by using the commands below:

sudo apt autoremove --purge adminer

Those who also want to uninstall Apache, MariaDB, and PHP, use the following commands:

sudo systemctl stop apache2 mariadb
sudo apt autoremove --purge mariadb-server php* apache2

Conclusion

Adminer an alternative to tools like phpMyAdmin. Adminer supports several database systems, including MySQL, MariaDB, PostgreSQL, SQLite, and more. At this point, you have learned to Set up or Install Adminer on Debian 11.

Hope you enjoy it. You may also like these articles:

How To Set up OpenNMS on Debian 11

How To Install Wireshark on Debian 11

AnyDesk Remote Desktop Debian 11

Erlang Language Setup Debian 11

Latest Git Version Setup Debian 11

Reset Forgotten Root Password Debian 11

FAQs

What databases does Adminer support?

Adminer supports MySQL/MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Elasticsearch, and MongoDB (with plugins).

How do I back up a database with Adminer?

Log in to Adminer, select the database you want to back up, click Export from the menu, choose the export format (e.g., SQL, CSV), and download the file.

Share your love

Stay informed and not overwhelmed, subscribe now!