Adminer

Step 1 – Install Required Packages For Adminer on Debian 12 First, you must run the system update with the following command:

sudo apt update Then, install the following packages that are required for Adminer:

sudo apt install php-curl libapache2-mod-php php-cli php-mysql php-gd -y Step 2 – Set a Root Database Password For Adminer on Debian 12 Before you start to install Adminer on Debian 12, you must log in to your MariaDB shell and set a root database password for Adminer. To do this, run the following command:

sudo mysql -u root -p From your MariaDB shell, use the following command to set a root password for the adminer database:

MariaDB [(none)]> SET PASSWORD FOR 'root'@'localhost' = PASSWORD("password"); Then, flush the privileges and exit from the MariaDB shell with the following commands:

MariaDB [(none)]> FLUSH PRIVILEGES; MariaDB [(none)]> exit; Set a Root Database Password For Adminer on Debian 12 Step 3 – Command To Install Adminer on Debian 12 The Adminer database management packages are available in the default Debian 12 repository. So you can easily use the following APT command to install Adminer on Debian 12:

sudo apt install adminer -y Next, you must enable the Apache config file for the Adminer with the following command:

sudo a2enconf adminer Then, restart the Apache service to apply the changes. Run the command below:

sudo systemctl restart apache2 Step 4 – Access Adminer Database Management via the Web Interface At this point, you have learned to Install Adminer on Debian 12. Now you can simply access your adminer tool via the Web UI by typing your server’s IP address in your web browser followed by adminer:

http://server-ip-address/adminer You will see the following screen. From there, you need to enter the Root as the username and the root password you have configured in step 2. Then, press login.

Adminer Login Screen on Debian 12 At this point, you will have the Dashboard to access all the available databases. You can delete or create a database as well. The interface of Amdiner is simple, easy to navigate, understandable, and not confusing.

Step 5 – Uninstall and Remove Adminer From Debian 12 At this point when you have completed the steps to install Adminer on Debian 12, you may no longer want to use Adminer. If so, you can use the commands below to remove Adminer from Debian 12:

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