Install Adminer database management tools on Debian 10

Install Adminer database management tools on Debian 10

Managing database systems such as MySQL, PostgreSQL, Oracle, and SQLite through a web-based UI is easier than using command line tools. Adminer is one of the best full-featured database management tools written in PHP. It is very similar to phpMyAdmin and can be used to manage MySQL, SQLite, Oracle and PostgreSQL databases. Compared with other tools, Adminer is a simple and user-friendly database management tool.

Feature

  • Multi-language support.
  • Supports various database systems, including MySQL, PostgreSQL, Oracle, Elasticsearch, MongoDB, etc.
  • Export and import databases and tables.
  • Add, delete, and modify databases and tables.
  • Run SQL query from text file.
  • Show and kill processes.
  • Use plugins to extend functionality.

In this tutorial, we will show you how to install the Adminer database management tool on Debian 10.

prerequisites

  • A server running Debian 10.
  • A root password is configured on your server.

getting Started

Before you begin, it is recommended to update the server to the latest version using the following command:

apt-get update -y apt-get upgrade -y

After updating the server, restart the server to implement the changes.

Install LAMP server

First, the administrator needs to install a LAMP server in your server. You can install the LAMP server using the following command:

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

After the installation is complete, start the Apache and MariaDB services and use the following command to make them start after the system restarts:

systemctl start apache2 systemctl start mariadb systemctl enable apache2 systemctl enable mariadb

When you are done, you can proceed to the next step.

Safe MariaDB installation

MariaDB is not secure by default. Therefore, you will need to protect it by running the mysql_secure_installation script.

mysql_secure_installation

Answer all questions as follows:

Enter current password for root (enter for none): 
Set root password? [Y/n] Y
Remove anonymous users? [Y/n] Y   
Disallow root login remotely? [Y/n] Y
Remove test database and access to it? [Y/n] Y
Reload privilege tables now? [Y/n] Y

Once MariaDB is secure, you will need to set MariaDB’s root password.

First, log in to the MariaDB shell using the following command:

mysql

Next, use the following command to set a password for the root user:

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

Next, refresh the privileges and exit from the MariaDB shell using the following command:

MariaDB [(none)]> flush privileges; MariaDB [(none)]> exit;

When you are done, you can proceed to the next step.

Installation administrator

By default, Adminer is not available in the Debian 10 default repository. Therefore, you need to download the Adminer installation file from its official website. You can download it to the Apache web root directory using the following command:

wget "http://www.adminer.org/latest.php" -O /var/www/html/adminer.php

After the download is complete, use the following command to change the permissions of the downloaded file:

chown -R www-data:www-data /var/www/html/adminer.php chmod 755 /var/www/html/adminer.php

When you are done, you can proceed to the next step.

Access admin dashboard

Now, open a web browser and enter the URL http: //your-server-ip/adminer.php. You will be redirected to the Adminer login page:

Provide your MariaDB root username, password, and click log in Button. You should see the Administrator dashboard on the following pages:

Administrator database management tools

Now click local host The button is on the top screen and you should see the following page:

Select database

Now, click “Create database“Button. You should see the following page:

Create database

Now provide the name of the database you want to create and click save Button to create the database as follows:

Newly created database in Adminer

Enable SSL for administrators and get a free SSL certificate from Let’s Encrypt

The first step to protecting Adminer with Let’s Encrypt SSL certificate is to install the python3-certbot-apache package. Run the following command:

apt-get -y install python3-certbot-apache

Next, we use the certbot client program to request an SSL certificate from Let’s Encrypt. In the process, the “Let’s Encrypt” server attempts to connect to the server using the domain name you provided to the certbot command. Importantly, the domain name already points to a server in DNS, so the website can be accessed through the domain name on its port 80 (http). If the website cannot be accessed from the Internet, the “Create Encrypted SSL” certificate will fail.

Before we start creating the SSL certificate, we need to set the domain name in the vhost configuration file. Open the default virtual host file with an editor:

nano /etc/apache2/sites-available/000-default.conf

And add the following line:

ServerName example.com

Right below the “DocumentRoot” line. Replace example.com with the domain name of your own website.

Then create the SSL certificate using the following command:

certbot --apache -d example.com

Here again, replace example.com with your domain name. This command will launch a wizard asking you a few questions.

Enter the email address where the administrator responsible for this site can be reached.

Set email address

Accept the terms and conditions of the “Let’s Encrypt SSL” permission.

Accept terms and conditions

Certbot will now ask if you want to share your email address with the Electronic Frontier Foundation. Choose whatever you like here.

Email address FSF

Then choose whether you want to automatically redirect non-SSL requests to https: //. When the website offers http: /// and https: // versions, I will choose yes here to avoid duplicate content issues.

Redirecting HTTP requests

The SSL certificate has been successfully issued.

SSL certificate has been successfully issued

When you now use a browser to access a website, you will be automatically redirected to SSL, and the green padlock in front of the URL bar in the browser indicates that we are now using a trusted SSL certificate.

in conclusion

In the above tutorial, you learned how to install Adminer on a Debian 10 server. You can now easily manage your database using Adminer’s web-based interface. If you have any questions, feel free to ask me.

Source

Sidebar