phpMyAdmin

From Wikipedia, the free encyclopedia

phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Internet. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, and manage keys on fields.

History

Tobias Ratschiller, then an IT consultant and later founder of the software company Maguma, started to work on a PHP-based web frontend to MySQL in 1998, inspired by Peter Kuppelwieser's MySQL-Webadmin. When he gave up the project in 2000 because of lack of time, phpMyAdmin had already become one of the most popular PHP applications and MySQL administration tools with a large community of users and contributors.

In order to coordinate the growing number of patches, a group of three developers, Olivier Müller, Marc Delisle and Loïc Chapeaux, registered The phpMyAdmin Project at SourceForge and took over the development in 2001.

Milestone releases

• 0.9.0 (September 9, 1998) : First internal release.
• 1.0.1 (October 26, 1998)
• 1.2.0 (November 29, 1998)
• 1.3.1 (December 27, 1998) : First multi-lingual version.
• 2.1.0 (June 8, 2000): Last release by the original developer Tobias Ratschiller.
• 2.2.0 (August 31, 2001) : First stable release by The phpMyAdmin Project.
• 2.3.0 (November 8, 2001) : Database and table views were split into smaller sections.
• 2.5.0 (November 5, 2003) : Introduction of the MIME-based transformation system.
• 2.6.0 (September 27, 2004) : Improved character set and MySQL 4.1 support.
• 2.7.0 (December 4, 2005) : Improved importing capabilities, simplified configuration, UI cleanup, and much more.
• 2.8.0 (March 6, 2006) : Compatibility updates, hiding databases, configurable memory limits, web-based setup.
• 2.9.0 (September 20, 2006)
• 2.9.1 (November 9, 2006) : fixes several security issues and bugs.

Current status

The software, which is currently available in fifty-two different languages, is still being maintained by The phpMyAdmin Project under Olivier Müller, Marc Delisle, Alexander M. Turek, Michal Čihař and Garvin Hicking.

Similar products

Another very similar tool, phpPgAdmin, provides similar functionality for PostgreSQL. It originally started as phpMyAdmin's fork, but is now a completely different code base.

There is yet another tool for managing Microsoft SQL Server, called phpMSAdmin. Though it borrows design principles from phpMyAdmin, it was written entirely from scratch and includes no code from phpMyAdmin.

phpMyAdmin is a free tool for server side MySQL management. For client side MySQL administration and development, Navicat MySQL GUI. provides the same functionality as phpMyAdmin but more advanced in the Import/Export, Backup and Data Sync. features.

External links

• The phpMyAdmin Project
• Learning SQL Using phpMyAdmin
• Documentation and FAQ (official Wiki)