How to install Adminer on Debian 10?

Windows Articles

Monitoring Ubuntu 20.04 with Stacer

Normally if we use Linux on a production server, it is important to monitor it. On the other hand, in everyday use, many users...

How to get the Android 11 Notification Panel

It's no secret that even though Android is the most widely used mobile operating system. Not always our device has the latest...

How to create backups in Windows 10 with FileFort Backup

There is no doubt that the computer is an essential element in our lives. Indeed, its uses go beyond work or study....

Trisquel 9.0 available

Trisquel is a GNU/Linux distribution endorsed and supported by the Free Software Foundation. This means that in addition to incorporating the Linux...

How to install PandoraFMS on CentOS 8?

Worldwide many IT infrastructures are running Linux on one of their servers. This opens the door to an endless number of different...
angeloma
angeloma
Senior Writer and partner

When we develop an application that requires a database management system, it is more comfortable to have a graphical interface for it. Because as we well know database managers do not have it. There are many of these tools of this type and in our blog, we have talked about them. However, today we present you one that has fascinated us for its simplicity and reliability. In this post, we will talk to you about how to install Adminer on Debian 10.

Adminer is a full-featured database management tool written in PHP. What is striking is that it is only done in one file. That is, it is very easy to use and we just need to download it and give it permissions. But Adminer not only stands out for its ease of use, but it is also quite complete in functionalities.

On the other hand, Adminer supports several database handlers like MySQL, MariaDB, SQLite, PostgreSQL among others. So there is power and simplicity.

From this application you expect the typical:

  • To be able to connect to the database.
  • Execute SQL sentences. As to consult, enter, delete.
  • Also, execute SQL sentences from a file.
  • And expand its functionality with the use of plugins.

So let’s install it.

Install Adminer on Debian 10

Adminer only needs the computer to have the LAMP battery installed. Besides, that PHP has the session module installed. This is no problem, so just read our post about LAMP on Debian 10.

How to install LAMP on Debian 10?

Then, we proceed to install it. To do this, we will create a new folder in the root of Apache.

:~$ sudo mkdir /var/www/html/Adminer/

After this, navigate to the folder and proceed to install it with the Wget command.

:~$ cd /var/www/html/Adminer/
:~$ sudo wget https://github.com/vrana/adminer/releases/download/v4.7.3/adminer-4.7.3.php
:~$ sudo mv adminer-4.7.3.php adminer.php

So far so good, but remember that we are working as if we were the root user and this will bring problems in the execution of Adminer. So you have to change the owner of the folder and the permissions to the file.

:~$ sudo chmod 755 -R /var/www/html/Adminer/adminer.php
:~$ sudo chown -R www-data:www-data /var/www/html/Adminer/

And now all you have to do is run it from your web browser. http://your-server/Adminer/adminer.php

1.- Adminer on Debian 10
1.- Adminer on Debian 10

Just type your credentials. And you will see this screen with all the databases.

2.- Adminer working
2.- Adminer working

But, you can create a new one. Just click on “Create Database”.

3.- Creating a new database with Adminer on Debian 10
3.- Creating a new database with Adminer on Debian 10

Then, you can create tables for the databases. All is very simple.

4.- Adminer
4.- Adminer

And that is it. So, you can check all the applications features.

Conclusion

Adminer is a fantastic application. It is clean, safe, reliable and does just what is necessary for the vast majority of users. Its simplicity makes many people confused: it is a powerful and complete application. It even has plugins. Best of all is that the installation process is quite simple and does not consume computer resources.

More articles

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Latest article

Monitoring Ubuntu 20.04 with Stacer

Normally if we use Linux on a production server, it is important to monitor it. On the other hand, in everyday use, many users...

How to get the Android 11 Notification Panel

It's no secret that even though Android is the most widely used mobile operating system. Not always our device has the latest...

How to create backups in Windows 10 with FileFort Backup

There is no doubt that the computer is an essential element in our lives. Indeed, its uses go beyond work or study....

Trisquel 9.0 available

Trisquel is a GNU/Linux distribution endorsed and supported by the Free Software Foundation. This means that in addition to incorporating the Linux...

How to install PandoraFMS on CentOS 8?

Worldwide many IT infrastructures are running Linux on one of their servers. This opens the door to an endless number of different...
x