How to Install Adminer on Ubuntu
Reading Time: 4 minutesAdminer is a database-management tool like phpMyAdmin. Here’s how to install and configure it on Ubuntu-based distros.
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. You can 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.
How to Install Adminer on Ubuntu
Here are the steps to install Adminer on Ubuntu-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 pressing Ctrl + Alt + T and run the update and upgrade commands.
sudo apt update && sudo apt upgrade
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:
sudo apt install apache2
Once Apache is successfully installed, enable the service using the systemctl utility:
sudo systemctl enable --now apache2
Also, make sure that Apache is working fine without causing any errors in the background.
sudo systemctl status apache2 --no-pager -l
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:
sudo apt install php php-curl libapache2-mod-php php-cli php-mysql php-gd php-fpm
Once you’ve successfully installed PHP and its extensions, reload Apache with:
systemctl reload apache2
Step 4: Install MariaDB on Ubuntu
After installing PHP, you need a database on your system that you can 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.
sudo apt install mariadb-server
Once the database is installed, enable it:
sudo systemctl enable --now mariadb
Verify if the database is running fine by checking its status:
sudo systemctl status mariadb
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:
sudo mysql_secure_installation
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:
sudo mysql
To set the root password, run:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('my password');
Make sure to replace ‘my password‘ with the password that you want to keep for the root user.
To update the password, execute:
FLUSH PRIVILEGES;
To exit the MariaDB command line, run:
exit;
Step 6: Install Adminer on Ubuntu
You can install Adminer on Ubuntu using the APT package manager:
sudo apt install adminer
Once installed, enable php-fpm:
sudo a2enconf php*-fpm
To enable the Apache configuration file for Adminer, execute:
sudo a2enconf adminer
Now reload Apache to update the changes you just made:
systemctl reload apache2
Once you’ve reloaded Apache, restart it with:
sudo systemctl restart apache2
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:
http://127.0.0.1/adminer
However, if you are running Adminer on a remote machine, provide the IP address of the machine to access Adminer like this:
http://server-ip-address/adminer
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 the Database box empty. After entering all the information asked, click on Login.
Once you have got access, you will find the following dashboard. From here you can 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 can simply uninstall it from your system. To remove Adminer from Ubuntu, execute:
sudo apt autoremove --purge adminer
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:
sudo systemctl stop apache2 mariadb
Now remove MariaDB, PHP, and Apache with:
sudo apt autoremove --purge mariadb-server php* apache2
Manage All Your Databases Efficiently From a Centralized Adminer Interface
Adminer lets you manage all your databases from a single web interface. You can 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 can choose to go with phpMyAdmin, but you’ll have to install either MariaDB or MySQL on your machine.
Reference: https://www.makeuseof.com/how-to-install-adminer-on-ubuntu/
Ref: makeuseof
MediaDownloader.net -> Free Online Video Downloader, Download Any Video From YouTube, VK, Vimeo, Twitter, Twitch, Tumblr, Tiktok, Telegram, TED, Streamable, Soundcloud, Snapchat, Share, Rumble, Reddit, PuhuTV, Pinterest, Periscope, Ok.ru, MxTakatak, Mixcloud, Mashable, LinkedIn, Likee, Kwai, Izlesene, Instagram, Imgur, IMDB, Ifunny, Gaana, Flickr, Febspot, Facebook, ESPN, Douyin, Dailymotion, Buzzfeed, BluTV, Blogger, Bitchute, Bilibili, Bandcamp, Akıllı, 9GAG