Adminer is a popular, lightweight database management tool that can be used to manage various types of databases. To install Adminer on Ubuntu 20.04 LTS, you can use the following steps:
- Create a new directory for Adminer in the web root directory by running the command:
sudo mkdir /var/www/html/adminer
- Download the latest version of Adminer by running the command:
sudo wget https://www.adminer.org/latest.php -P /var/www/html/adminer
- Rename the downloaded file to index.php by running the command:
sudo mv /var/www/html/adminer/latest.php /var/www/html/adminer/index.php
- Configure your web server to serve the Adminer files.
- For Apache, create a new virtual host configuration file by running the command:
sudo nano /etc/apache2/sites-available/adminer.conf
- Add the following code to the file, replacing example.com with your domain name:
<VirtualHost *:80>
ServerName example.com
DocumentRoot /var/www/html/adminer
<Directory /var/www/html/adminer>
AllowOverride All
</Directory>
</VirtualHost>
- Enable the virtual host and the rewrite module by running the command:
sudo a2ensite adminer.conf
sudo a2enmod rewrite
- Restart Apache by running the command:
sudo systemctl restart apache2
- Open your web browser and access the domain or IP address where you installed Adminer. You should see the login page.
You can also use other web server like Nginx, lighthttpd as well to serve the Adminer files. Also, you can use the command ‘sudo nano /var/www/html/adminer/config.php’ to configure the database connection settings
It’s important to note that Adminer does not come with any kind of authentication or authorization by default, so it’s highly recommended to put in place authentication and authorization mechanisms to protect your databases. You can achieve this by using tools like Apache’s mod_auth or a reverse proxy with built-in authentication.