Share your love
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.
Table of Contents
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.

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.

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.