Adminer is a popular database management tool that enables users to interact with MySQL, PostgreSQL, SQLite, and MS SQL databases. It is a lightweight and efficient tool that is easy to install and use. In this article, we will guide you through the process of installing Adminer on Ubuntu.
Prerequisites for installing Adminer on Ubuntu
There are a few crucial components that must be installed on Ubuntu in order to correctly install Adminer. To do this, follow these instructions:
Update repository
Step 1: The packages list should be updated on Ubuntu before installing any applications, and here is how to do it:
sudo apt update |
Install Apache2, MariaDB, and PHP
Step 2: Next, employing Ubuntu’s built-in package manager, install Apache2, MariaDB, and PHP:
sudo apt install mariadb-server php-curl libapache2-mod-php php-cli php-mysql php-gd apache2 php -y |
Activate Apache server
Step 3: Next, activate the Apache2 server that we set up in the preceding step by using:
sudo systemctl enable apache2 |
Start Apache server
Now it’s time to start the server and here is how to do it:
sudo systemctl start apache2 |
Activate MariaDB
Step 4: Activate mariadb now by using:
sudo systemctl enable mariadb |
Start MariaDB server
Now it’s time to start the mariadb and here is how to do it:
sudo systemctl start mariadb |
Step 5: Setup MariaDB now on Ubuntu by using:
sudo mysql_secure_installation |
Allow socket authentication now, and if you believe the current password is quite simple to guess, specify the root password. Next, let anonymous user deactivation while maintaining remote login as an option:
Next, type n to prevent the removal of the test database:
Step 6: Run the database now by using:
sudo mysql |
Next, use the following syntax to set the root login password for this database administration tool:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD("<Your-password>");
|
Now to apply the changes use: FLUSH PRIVILEGES; command and afterward exit the database using the exit command:
FLUSH PRIVILEGES; exit; |
Installing Adminer on Ubuntu
After installing each of the prerequisites for Adminer, proceed to installing it on Ubuntu by following the procedures listed below:
Step 1: Using the apt package manager, install the Adminer now:
sudo apt install adminer -y |
Configure Adminer
Step 2: Configure the Adminer once the tool is installed by using:
sudo a2enconf adminer |
Reload Apache server
To activate the Adminer new configuration, reload the Apache server at this time using:
sudo systemctl reload apache2 |
Login Adminer
Step 3: Now that everything has been set up, you may visit Adminer, a web-based database management tool, by putting the IP address of the Ubuntu system in the browser’s address bar together with Adminer (you can just use localhost or 127.0.0.1):
127.0.0.1/adminer/ |
Using the root password you previously specified during server setting, log in now:
Removing Adminer
If the Adminer is no longer required, you can completely remove it from your Ubuntu system by using:
sudo apt remove --autoremove adminer -y |
Conclusion
Adminer can be used for basic database management tasks such as creating, editing, and deleting tables, executing SQL queries, and managing users and permissions. It provides a user-friendly interface that makes it easy for developers and database administrators to interact with their databases. By following the steps outlined in this article, you can easily install Adminer on Ubuntu and start managing your databases with ease.
