Managing databases using only the command line often feels like walking in the dark. You might make a mistake with a complex SQL query, or perhaps you just want a quick visual overview of your data. This is exactly where the need to Install Adminer in Ubuntu arises.
Without the clutter of more complicated tools, Adminer offers a simple, intuitive interface for managing your data. This Ubuntu Linux administrator installation tutorial will take you step-by-step through the procedure. This application streamlines your workflow whether you manage a huge inventory system or a tiny personal blog. We’ll go over how to install adminer on Ubuntu step-by-step so you can get it up and operating on your server quickly.
What is Adminer?
Adminer is a full-featured database management tool written in a single PHP file. It serves as a lightweight alternative to phpMyAdmin. Developers love it because it supports a wide range of database systems, including MySQL, PostgreSQL, SQLite, MS SQL, and Oracle.
Unlike other tools that require complex configurations, Adminer focuses on simplicity and security. It drops into your server easily and connects to your existing database instance immediately.
Why use Adminer?
- It consists of a single PHP file, making deployment instant.
- The interface is clean, modern, and distraction-free.
- It supports multiple database types, not just MySQL.
- Security is a priority, with fewer historical vulnerabilities than competitors.
- It offers high performance and handles large datasets efficiently.
- You can extend functionality easily with plugins.
Adminer Installation in Ubuntu
Now we will proceed to setup adminer database manager on ubuntu. We will concentrate on the manual installation process. This process is most preferred since it ensures that you end up with the latest version and also works perfectly regardless of whether you are installing adminer on ubuntu using apache or Nginx.
Always start with a fresh system to avoid conflicts. Open your terminal and run the update command.
sudo apt update && sudo apt upgradeInstall PHP and extensions
Adminer requires PHP to run. If you do not have PHP installed yet, you need to add it along with the necessary extensions to configure adminer for mysql on ubuntu.
sudo apt install php php-curl php-cli php-mysql php-gdIf you use a different database like PostgreSQL, ensure you install the corresponding PHP extension (e.g., php-pgsql).
Download and Configure permissions For Adminer
Since Adminer is a single file, you simply download it directly into your web server’s document root. By default, this is usually /var/www/html. Create a directory for Adminer to keep things organized:
sudo mkdir /var/www/html/adminer
cd /var/www/html/adminerUse wget to download the latest version. We will rename it to index.php so it loads automatically when you visit the folder.
sudo wget -O index.php https://github.com/vrana/adminer/releases/download/v4.17.1/adminer-4.17.1.phpYou must ensure your web server can read the file. Change the ownership of the directory to the web server user (usually www-data).
sudo chown -R www-data:www-data /var/www/html/adminer
sudo chmod -R 755 /var/www/html/adminerRestart the Web Server
To make sure all PHP extensions load correctly, restart your web server. You need restart apache2 or ngix using below commands:
// For Apache2
sudo systemctl restart apache2
// For NginX
sudo systemctl restart php8.1-fpm
sudo systemctl restart nginx
Access Adminer
Open your web browser. Type your server’s IP address or domain followed by /adminer.
You will see the login screen. Select your database type (e.g., MySQL), enter your username (often root), and your password. You can now manage your databases effortlessly.
Conclusion
you have completed the Ubuntu Adminer Setup: Manage Databases the Easy Way tutorial successfully. We have made the process of Install Adminer in Ubuntu easier by using the direct download approach, which gives you the most flexibility.
This handy application will make your life easier by saving your time and server resources. Now, you have a powerful tool at your disposal to manage SQL statements, database tables, and user information. Whether you are using Apache or Nginx, Adminer is still the most efficient solution for developers.