How to install Adminer on Debian 10?

Windows Articles

How to create a new KVM virtual Machine on Debian 10?

In the previous post, we explained how to install KVM on Debian 10. Now it's time to create a KVM Virtual Machine.

How to repair a USB drive in Windows 10.

Hi! USB sticks are undoubtedly very functional elements for working in Windows 10. Indeed, their use ranges from file management to creating...

How to install double-tap on back gesture on your Android

Hi, how are you? The double-tap on back gesture is one of the new functions available on Android 11 and IOS 14....

How to install KVM on Debian 10?

Hello friends, in this post I will show you how to install KVM on Debian 10. KVM stands for...

How to open Windows 10 Mobility Center

Hello! There are many types of users of Windows 10. As it depends on the type of hardware used. That is, the...
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

How to create a new KVM virtual Machine on Debian 10?

In the previous post, we explained how to install KVM on Debian 10. Now it's time to create a KVM Virtual Machine.

How to repair a USB drive in Windows 10.

Hi! USB sticks are undoubtedly very functional elements for working in Windows 10. Indeed, their use ranges from file management to creating...

How to install double-tap on back gesture on your Android

Hi, how are you? The double-tap on back gesture is one of the new functions available on Android 11 and IOS 14....

How to install KVM on Debian 10?

Hello friends, in this post I will show you how to install KVM on Debian 10. KVM stands for...

How to open Windows 10 Mobility Center

Hello! There are many types of users of Windows 10. As it depends on the type of hardware used. That is, the...