Adminer – manage MySQL by single file, alternative of phpMyAdmin

Adminer impressed me when I first tested it. It is superb alternative to the most famous MySQL web based administration tool phpMyAdmin.

I just counted number of files in my current phpMyAdmin installation and I found there are 642 items. But Adminer is only a single file. You need to download it from there website and upload to your server. You are done!

The interface is much like phpMyAdmin but it is very neat and slick.

Let’s see what features Adminer offers to us.

Connect to a database server with username and password

Select an existing database or create a new one

List fields, indexes, foreign keys and triggers of table

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

Create, alter, drop and link lists by foreign keys

Create, alter, drop and select from views

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

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 rights and change them

Display variables with links to documentation

Manage events and table partitions (MySQL 5.1)

Another wonderful thing is that it is extensible. You can easily extend its functionality or overwrite any of its functionality. For more information about extensions, please visit this link.

Related posts:

1. How to change MySQL database collation?
2. MySQL database import-export from Shell
3. Common iptables command, cheatsheet
4. Views in BIND 9