How to Install Adminer on Ubuntu
Adminer is a web-based tool that allows you to manage multiple database systems from a central location. The tool is user-friendly, lightweight, and top-notch in performance with a neat user interface.
The Adminer database manager is available on all Linux distributions. it’s possible to easily install and configure it on Ubuntu via the terminal and access its web interface via any browser. You can run database operations directly from the Adminer dashboard and easily manage multiple databases.
Here’s how to install and set up Adminer on Ubuntu.
What Is Adminer?
Alternative to phpMyAdmin, Adminer is an open-source tool for managing multiple databases from a centralized location. The tool has support for MariaDB, MySQL, SQLite, Oracle, PostgreSQL, MongoDB, and Elasticsearch.
Adminer has better security than phpMyAdmin and is lighter in weight. It comes with a clean interface that makes it easy to use and learn. You can access it from the web interface by providing the IP address of the machine running the Adminer instance.
Here are the steps to install Adminer onUbuntu-based distributions:
Step 1: Update and Upgrade Ubuntu
Before jumping onto the Adminer installation, you must update and upgrade your system so that you don’t face any issues with new installations. Open the terminal on your Ubuntu machine by pressingCtrl + Alt + Tand run the update and upgrade commands.
Step 2: Install Apache on Ubuntu
Once you’ve updated and upgraded the system packages, the next task is to install Apache. Do this by running the following command:
Once Apache is successfully installed,enable the service using the systemctl utility:
Also, make sure that Apache is working fine without causing any errors in the background.
This tells that Apache is active and running fine on Ubuntu.
Step 3: Install PHP on Ubuntu
Since Adminer is written in PHP, you need to install PHP and its essential extensions. To install it, run:
Once you’ve successfully installed PHP and its extensions, reload Apache with:
Step 4: Install MariaDB on Ubuntu
After installing PHP, you need a database on your system that it’s possible to manage using Adminer. You can install any database such as MySQL, MariaDB, PostgreSQL, MongoDB, SimpleDB, etc.
Since MariaDB is mostly used in many PHP-based applications, let’s install it on Ubuntu.
Once the database is installed, enable it:
Verify if the database is running fine by checking its status:
This tells MariaDB is in an active state, and working fine on Ubuntu.
After installing MariaDB, you also need to secure it using a script that allows you to set a root password for MariaDB, remove anonymous users, disallow remote root login, and delete the test database. To execute the script, run:
Step 5: Set Admin Password for Adminer
To manage the database using Adminer, you need access to the root database user. For that, you need a root password that will allow you to manage all the databases through Adminer.
To set the password, first, open the MySQL command line:
To set the root password, run:
confirm to replace “my password” with the password that you want to keep for the root user.
To update the password, execute:
To exit the MariaDB command line, run:
Step 6: Install Adminer on Ubuntu
it’s possible to install Adminer on Ubuntu using the APT package manager:
Once installed, enable php-fpm:
To enable the Apache configuration file for Adminer, execute:
Now reload Apache to update the changes you just made:
Once you’ve reloaded Apache, restart it with:
Step 7: Access the Adminer Web Interface
Now that all the necessary installations needed for Adminer have been done, you can access the application via the web interface and start managing your database.
To access Adminer, open a browser and provide the IP address of the machine on which Adminer is running.
If you are running Adminer on the local system, use this address:
However, if you are running Adminer on a remote machine, provide the IP address of the machine to access Adminer like this:
You will see the following login page on your browser after running the web address to Adminer:
To log in to Adminer, enter root as the username and provide the password that you set in Step 5. No need to provide the database name as Adminer has access to all the available databases, so leave theDatabasebox empty. After entering all the information asked, click onLogin.
Once you have got access, you will find the following dashboard. From here you could access all the available databases to manage them. You can also create or delete a database here.
As you can see, the Adminer interface is simple, not very populated, and hence easy to manage.
How to Uninstall Adminer From Ubuntu
If you no longer need Adminer to manage your databases, you may simply uninstall it from your system. To remove Adminer from Ubuntu, execute:
If you also want to remove MariaDB, Apache, and PHP from your system, that’s also possible by using basic Linux commands.
To do that, you first need to stop these services and then delete them. To stop Apache and MariaDB, execute:
Now remove MariaDB, PHP, and Apache with:
Manage All Your Databases Efficiently From a Centralized Adminer Interface
Adminer lets you manage all your databases from a single web interface. you may perform multiple database operations on Adminer such as creating or deleting a database, editing tables, browsing/inserting/editing table rows, sorting columns, editing DB objects and so much more.
There is also no limit to managing databases in Adminer. phpMyAdmin, on the other hand, only has support for MariaDB and MySQL which makes Adminer the go-to database management system. you may choose to go with phpMyAdmin, but you’ll have to install either MariaDB or MySQL on your machine.
Want to set up your own relational database management system on Ubuntu? Consider installing MySQL database on the server.
Flagship price, mid-range phone.
Taming data is easier than it looks.
Goodbye sending links via other apps.
Quality apps that don’t cost anything.
Your iPhone forgets what you copy, but this shortcut makes it remember everything.
