How to Install Adminer on CentOS

In this tutorial, we’re going to show you how to install Adminer on CentOS. This tutorial will work for any CentOS version, including CentOS 7 and CentOS 8, as well as Rocky Linux and Alma Linux.

Adminer is a database management editor in a single PHP file. A great alternative to phpMyAdmin. You can use Adminer with MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Elasticsearch, MongoDB, and others.

Prerequisites

For this tutorial, you’ll need:

  • The root user or a user with sudo privileges
  • SSH access to the server (or just open Terminal if you’re on a desktop)
  • A CentOS system. We tested this tutorial on CentOS 7 and CentOS 8 servers from Linode, but these instructions will work on any other RHEL-based distro. You can get a Linux VPS from any provider.
  • A LAMP stack. We’ll show you how to install the stack below. If you already have a LAMP stack installed, you can skip to Step 5.

Step 1: Update CentOS

First, you need to update CentOS with the following command:

yum update

Step 2: Install Apache

Next, you need to install Apache with the following command:

yum install httpd

And start it:

systemctl start httpd

Step 3: Install MariaDB

The next step is to install the database server. In this case, we’ll be using MariaDB, but you can use MySQL or any other database server.

Run the following command to install MariaDB:

yum install mariadb-server

Check our How to install MariaDB tutorial for more detailed instructions, or if you want to use a newer version of MariaDB.

Start and enable the MariaDB service:

systemctl start mariadb
systemctl enable mariadb

And run the security script:

mysql_secure_installation

Step 4: Install PHP

The next step is to install PHP (the last part of the LAMP stack). To install PHP, run the following command:

yum install php

To install a newer version of PHP, follow our How to install PHP on CentOS tutorial.

If you’re using PHP 8, you’ll need to enable sessions (in your php.ini file)

Step 5: Download and configure Adminer

First, create a directory and cd to the directory for Adminer:

mkdir /var/www/html/adminer && cd /var/www/html/adminer

And download the latest Adminer version:

wget -O index.php https://github.com/vrana/adminer/releases/download/v4.8.1/adminer-4.8.1-en.php

You can get the latest version from here.

Update the ownership and permissions:

chown -R apache:apache index.php /var/www/html/adminer/
chmod -R 775 /var/www/html/adminer/

And restart Apache:

systemctl restart httpd

And that’s it. You’re done. You can now visit http://your-ip/adminer to start using Adminer. Next, you can optionally set up an Apache conf file, HTTPS, as well as other configs like using a subdomain for your Adminer.adminer page

Leave a comment

Your email address will not be published. Required fields are marked *