Manage Databases with Adminer Database Management Tool

A user-friendly interface for developers to manage databases. In this guide, you’ll get to know all the basic information required to get started with Adminer.

Manage Databases with Adminer Database Management Tool

What is Adminer?

When it comes to lightweight, user friendly, high performing MySQL database management tool, Adminer has gained wide popularity and delivers on many improvements as compared to phpMyAdmin. Initially, Adminer database management toolwas developed by Jakub Vrana in 2007 as an alternative to phpMyAdmin, so that all you have to do is download and install a single, lightweight PHP file on your application’s database.

As an open source database management tool, it also is free to use and is written in PHP. What sets Adminer apart is a good user interface design for a seamless user experience, as well as strong security features to keep data safe from any attacks or malicious hacking attempts.

Important features of Adminer

Some basic but important features of Adminer include:

  • It has many database functions including select database, edit tables, insert/edit data in tables, and sorting/searching data in multiple columns
  •  Supports multiple database including: MySQL, PostgreSQL, SQLite, MS SQL, Oracle, and SimpleDB databases and more
  • It is available in 43 languages including English, Arabic, Persian, Polish, Dutch etc
  • You can easily edit database objects such as views, triggers, stored procedures, user permissions and more through Adminer.
  • Adminer also provides security measures against SQL injection, session stealing, cross site scripting (XSS) software attacks and other attacks as well.

Adminer VS phpMyAdmin

When it comes to choosing between Adminer and phpMyAdmin, Adminer comes on top for the flexible features and light file upload it provides. Similarly, as compared to phpMyAdmin, it supports multiple databases including MYSQL, SQLite and many others. Similarly, Adminer is more intuitive and smarter than phpMyAdmin when it comes to adding additional fields which Adminer does automatically or manipulation with all indexes at the same time.

Manage databases with Adminer

System Requirements

In order for Adminer to run on your system, it is important that you have the following requirements already set up on your server:

  • PHP version 5, 7 or 8
  • A database driver such as MySQL, SQLite, PostgreSQL etc

Installation

If you’ve got these two system requirements checked, then simply download the Adminer file from https://www.adminer.org/, and get started by uploading the PHP file to your server. For XAMPP server, rename the downloaded file as “adminer.php” and put this file into htdocs folder.

Access Adminer UI

Now access Adminer from http:your-ip-address/adminer.php as shown:

Manage Databases with Adminer Database Management Tool

Connect to Server

Login to Adminer using your server’s username and password. Now if you want to access only one database then enter it’s name. You can leave this field blank to access all databases that already exist on the server.

Manage databases

After login you will see a list of your all current databases. Click on any database to manage it.

Manage Databases with Adminer Database Management Tool

On next screen you will see the list of all tables of selected databases. From here you can export database or its tables, add or edit table/columns, alter data via SQL queries and much more as shown here:

Manage Databases with Adminer Database Management Tool

Create New Database

To create a new database, click on “Create database”, enter database name and click “save”.

Manage Databases with Adminer Database Management Tool

Insert/update records

Adding new records to a table is pretty simply. Click on New item link which will redirect you to the Insert screen. Here you will be able to add new data for all the columns in the table, along with the data type so that adding new data is a quick process.

Manage Databases with Adminer Database Management Tool

Conclusion

Adminer’s intuitive, smart and easy to use interface makes it a very popular database management tool. Furthermore, it supports many databases including MySQL, SQLite, MongoDB and much more, along with security measures to protect and prevent any malicious hacking events. All in all, Adminer database management tool is not only open source, but free to use as well.

Explore

To learn more about free web based database management tools, please check following pages: