Monday, September 26, 2011

Adminer – manage MySQL by single file, alternative of phpMyAdmin

June 1, 2010 by  
Filed under General

1 Comment

AdminerAdminer 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.

GD Star Rating
a WordPress rating system
Adminer - manage MySQL by single file, alternative of phpMyAdmin , 10.0 out of 10 based on 2 ratings
Digg This
Reddit This
Stumble Now!
Buzz This
Vote on DZone
Share on Facebook
Bookmark this on Delicious
Kick It on
Shout it
Share on LinkedIn
Bookmark this on Technorati
Post on Twitter
Google Buzz (aka. Google Reader)

Related posts:

  1. How to change MySQL database collation?
  2. MySQL database import-export from Shell
  3. Upload site content via the cPanel’s File Manager
  4. Common iptables command, cheatsheet
  5. SSL Certificate Installation, Step by Step


One Response to “Adminer – manage MySQL by single file, alternative of phpMyAdmin”
  1. Gregory Kornblum says:

    Love this little script. PHPMyAdmin is an awful tool for managing DBs compared to desktop alternatives but this little puppy is perfect for the simple stuff and want to give remote but limited access.

    GD Star Rating
    a WordPress rating system

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!
Click here to cancel reply.