How to Use Adminer to Manage Databases Easily with a Single PHP File

adminer

Managing MySQL databases is one of the fundamental requirements of being a professional WordPress developer. Adminer simplifies that task immensely.

Every WordPress site requires a database to function—it’s where WordPress stores all of your sites’ critical data. While phpMyAdmin has been a staple MySQL/MariaDB database management tool for many years, Adminer is a great alternative. It comes loaded with tons of useful features and a prettier UI, all within a single, lightweight PHP file that you can deploy quickly on your server.

In this post, you’re going to learn about Adminer, the many benefits it offers over phpMyAdmin, and how you can use it for managing your databases. We’ll also explore how DevKinsta uses Adminer to simplify WordPress database management in local development environments.

Let’s get to work!

What Is Adminer?

Adminer (formerly phpMinAdmin) is a PHP-based, free, open source database management tool. It’s super simple to deploy on your server. To use it, all you have to do is upload its single PHP file, point your browser towards it, and log in.

Adminer login page

Unlike phpMyAdmin, which only supports the management of MySQL and MariaDB databases, Adminer also supports managing other databases such as PostgreSQL, SQLite, MS SQL, Oracle, SimpleDB, Elasticsearch, MongoDB, and Firebird. It is also available in 43 languages.

Adminer provides an easy-to-use interface, better support for many MySQL features, more remarkable performance, and increased security.

Let’s explore how to install Adminer now.

How to Use Adminer

But before you get started with installing it, here are some basic requirements to get Adminer working on your server:

  • PHP 5, 7, or 8
  • A database driver (e.g. MySQL, PostgreSQL, etc.)

That’s pretty much it!

Download the latest version of Adminer from their official website. You can also find the MySQL-only and English-only flavors of Adminer on there. If you’re managing a MySQL or MariaDB database (e.g. for a WordPress site), you can get these lighter variants.

Downloading Adminer’s latest version

Downloading Adminer’s latest version

Alternatively, if you’re using the terminal, you can download it directly to your directory with the curl command.

curl -o https://github.com/vrana/adminer/releases/download/v4.7.8/adminer-4.7.8.php

Adminer 4.7.8 is the latest stable version. It adds support for the just-launched PHP 8.0. You

[…]

 



This article was written by Salman Ravoof and originally published on Blog – Kinsta.

Disclosure: Some of the links in this post are "affiliate links." This means if you click on the link and purchase the product, We may receive an affiliate commission.

Leave a Comment

You have to agree to the comment policy.

Scroll to Top