Step 1: Update Your System

Before installing Adminer, ensure your system is up to date. Run the following commands:

sudo apt update && sudo apt upgrade -y

Keeping your system updated is crucial for security and performance, whether you're running it locally or on a VPS Windows Servers platform.

Step 2: Install Apache and PHP

Adminer requires a web server and PHP to run. Install Apache and PHP using the following command:

sudo apt install apache2 php php-mbstring -y

Start and enable Apache to start at boot:

sudo systemctl start apache2
sudo systemctl enable apache2

Step 3: Download and Install Adminer

To install Adminer, you can download the latest Adminer PHP file from the official site. Run the following command:

sudo mkdir -p /var/www/html/adminer
sudo wget "https://github.com/vrana/adminer/releases/download/v4.8.1/adminer-4.8.1.php" -O /var/www/html/adminer/index.php

This will download the Adminer PHP file to the /var/www/html/adminer directory.

Step 4: Configure Apache for Adminer

Now that Adminer is installed, you need to configure Apache to serve the Adminer web interface. Create a new virtual host configuration file:

sudo nano /etc/apache2/conf-available/adminer.conf

Add the following content:

Alias /adminer /var/www/html/adminer


    Options Indexes FollowSymLinks
    AllowOverride None
    Require all granted

            

Save and exit the file. Enable the configuration:

sudo a2enconf adminer
sudo systemctl reload apache2

Step 5: Access Adminer

Adminer is now ready to use. Open your web browser and navigate to the following URL:

http:///adminer

You should see the Adminer login page, where you can log in to manage your databases. Adminer supports MySQL, PostgreSQL, SQLite, and other databases.

Step 6: Secure Adminer (Optional)

For enhanced security, you may want to restrict access to Adminer by setting up a firewall or restricting access by IP address. You can also use basic HTTP authentication to add a login prompt before accessing Adminer.