phpMyAdmin
From Wikipedia, the free encyclopedia
|
Screenshot
 phpMyAdmin main screen |
|
| Developed by | The phpMyAdmin Project |
|---|---|
| Initial release | September 9, 1998 |
| Stable release | 3.1.3 (2009-02-28) [+/−] |
| Preview release | [1] () [+/−] |
| Written in | PHP |
| OS | Cross-platform |
| Available in | Multilingual (54) |
| Type | Web Database Management |
| License | GNU General Public License |
| Website | http://www.phpmyadmin.net |
phpMyAdmin is an open source tool written in PHP intended to handle the administration of MySQL over the World Wide Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage users and permissions, and manage keys on fields.
Contents |
[edit] History
Tobias Ratschiller, then an IT consultant and later founder of the software company Maguma, started to work on a PHP-based web front-end to MySQL in 1998, inspired by Peter Kuppelwieser's MySQL-Webadmin. He gave up the project (and phpAdsNew, of which he was also the original author) in 2000 because of lack of time.
By that 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.net and took over the development in 2001.
[edit] Milestone releases
| Release | Date | Changes |
|---|---|---|
| 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.10.0 | February 27, 2007 | GUI for relations, called Designer |
| 2.11.0 | August 22, 2007 | Supports creating VIEWS from query results, manages triggers, procedures and functions. Improved interface for servers handling large number of databases/tables. Likely the last milestone supporting PHP 4. |
| 3.0.0 | September 27, 2008 | Requires PHP 5.2 and MySQL 5+. Supports EVENT and TRIGGER. |
| 3.1.0 | November 28, 2008 | A new setup mechanism, supports BLOBstreaming and the Swekey hardware authentication |
[edit] Current status
The software, which is currently available in 54 different languages (languages list), is still being maintained by The phpMyAdmin Project under Olivier Müller, Marc Delisle, Alexander M. Turek, Michal Čihař and Garvin Hicking.
[edit] Similar products
Another very similar tool, phpPgAdmin, provides similar functionality for PostgreSQL. It originally started as a fork of phpMyAdmin, but is now a completely different code base.
There is a 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.
An equivalent product for the Microsoft SQL Server area is myLittleAdmin. The objective of the both products is the same: offering a great web interface to efficiently manage database online.
There is a similar lightweight tool for managing MySQL databases called phpMinAdmin, which has all the most important features of phpMyAdmin, but consists of only one PHP file.
