Adminer Database Management Tool
Free Web Based Database Management System
Open Source database management tool which provides a user-friendly interface for developers to manage Postgres, SQLite, Oracle, MS SQL and MySQL databases.
Overview
Adminer is a free web based database management system as well as a lightweight alternative to phpMyAdmin. Compared to phpMyAdmin, Adminer consists of a single PHP file. Adminer is a tool used to manage content in various databases. It can also be installed and integrated with XAMPP server.
Adminer has some features which makes it even better than phpMyAdmin. It has persistent and multiple login sessions as well as easy export functionalities and a much more concise graphical interface. It enables users to easily create, edit or delete tables and columns. Also gives the ability to create and call stored procedures and functions.
This free lightweight DBMS tool works with the following databases:
- MySQL
- Oracle
- PostgreSQL
- Elasticsearch
- SQLite
- MS SQL
- MongoDB
- SimpleDB
System Requirements
Adminer is PHP based database management tool that requires following software.
- Ubuntu 18.04
- A non-root user with sudo privileges
- A firewall configured with ufw
- LAMP (Linux, Apache, MySQL, and PHP) installation
Features
- Supports PHP 5 with enabled sessions
- It can also connect to any database server with username and password
- Connect to an existing database or create a new one
- List fields, indexes, foreign keys and triggers of table
- Also you can change name, engine, collation, auto_increment and comment of table
- Alter name, type, collation, comment and default values of columns
- Add and drop tables and columns
- Create, alter, drop and search by indexes including fulltext
- It also allows to create, alter, drop and link lists by foreign keys
- Create, alter, drop and select from views
- Gives the ability to create, alter, drop and call stored procedures and functions
- Create, alter and drop triggers
- List data in tables with search, aggregate, sort and limit results
- Insert new records, update and delete the existing ones
- Also it supports all data types, blobs through file transfer
- Execute any SQL command from a text field or a file
- Export table structure, data, views, routines, databases to SQL or CSV
- Alter export for projecting changes to production database
- Print database schema connected by foreign keys
- Show processes and kill them
- Display users and their rights
- Display variables with links to documentation
- Manage events and table partitions (MySQL 5.1)
- Schemas, sequences, user types (PostgreSQL)
- Extensive customization options
- Open Source
Installation
- Update system using following commands
sudo apt update
sudo apt upgrade
- Then install Adminer using command
sudo apt install adminer
- After that, activate Adminer app using command
sudo a2enconf adminer
- In the end, restart Apache
sudo systemctl reload apache2
- Then you can access Adminer from URL: https://server-ip/adminer/
