LINUX, FOSS AND LIBRARY TECHNOLOGY ENTHUSIAST

Monday, November 25, 2024

Adminer: The Simplest Way to Manage MySQL/MariaDB with a GUI

0 comments
Managing databases like MySQL or MariaDB via the command line can be a daunting task for many users. While tools like phpMyAdmin provide a graphical interface, they often come with a large footprint and complex setup. Enter Adminer, a lightweight yet powerful web-based database  management tool.

In this blog post, we'll introduce Adminer, explain why it's an excellent choice for database management, and guide you through its easy installation process on a Linux server.

Why Choose Adminer?

Adminer stands out for its simplicity and efficiency. Here’s why it’s worth considering:

  • Lightweight and Fast: Adminer is just a single PHP file (~500KB). No bulky dependencies or extensive setup—just download and run.
  • Multi-Database Support: It works with a variety of database systems, including MySQL, MariaDB, PostgreSQL, SQLite, Oracle, and more.
  • User-Friendly Interface: With its clean and intuitive design, Adminer makes database management accessible even for beginners.
  • Customizable: Enhance its functionality with plugins and themes to match your specific needs.
  • Secure: Adminer is regularly updated, supports HTTPS, session expiration, and even IP-based restrictions to keep your databases safe.

Installing Adminer 

Here’s a step-by-step guide to installing Adminer on a server running Apache.

1. Prepare the Script

Create a shell script to automate the process:

sudo vim install_adminer.sh

Copy and paste the following script into the file:

#!/bin/bash

# Update and upgrade system packages
echo "Updating and upgrading system packages..."
sudo apt update && sudo apt upgrade -y

# Install necessary PHP packages
echo "Installing PHP and required extensions..."
sudo apt install php php-cli php-mbstring php-zip php-gd php-json php-curl -y

# Download the latest Adminer
echo "Downloading Adminer..."
wget https://www.adminer.org/latest.php -O adminer.php

# Move Adminer to the web server directory
echo "Moving Adminer to /var/www/html/..."
sudo mv adminer.php /var/www/html/

# Set correct ownership and permissions
echo "Setting ownership and permissions for Adminer..."
sudo chown www-data:www-data /var/www/html/adminer.php
sudo chmod 644 /var/www/html/adminer.php

# Enable PHP module and restart Apache
echo "Enabling PHP module and restarting Apache..."
sudo a2enmod php
sudo systemctl restart apache2

echo "Adminer installation and configuration complete. Access it at http://<your-server-ip>/adminer.php"

2. Make the Script Executable

Run the following command to make the script executable:

sudo chmod +x install_adminer.sh

3. Execute the Script

Run the script to install Adminer:

sudo ./install_adminer.sh

Accessing Adminer

Once the installation is complete, open your web browser and visit:


Replace <your-server-ip> with the IP address of your server. You’ll be greeted with Adminer’s login screen, where you can enter your database credentials to start managing your databases.

No comments:

Post a Comment