- PhpMyAdmin
Infobox Software
name = phpMyAdmin
caption = phpMyAdmin main screen
collapsible = yes
developer = The phpMyAdmin Project
released = initial release|1998|09|09
frequently updated = yes
programming language =PHP
operating system =Cross-platform
language = Multilingual (54)
genre = Web Database Management
license = GPL
website = http://www.phpmyadmin.netphpMyAdmin is an open source tool written in
PHP intended to handle the administration ofMySQL over theInternet . Currently it can create and dropdatabase s, create/drop/alter tables, delete/edit/add fields, execute anySQL statement, manage users and permissions, and manage keys on fields.History
Tobias Ratschiller, then an IT consultant and later founder of the software company [http://www.maguma.com/ Maguma] , started to work on a PHP-based web front-end to MySQL in
1998 , inspired by Peter Kuppelwieser'sMySQL-Webadmin . He gave up the project (andphpAdsNew , of which he was also the original author) in2000 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. It is also included in many Linux distributions. 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 in2001 .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 developerTobias 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 theMIME -based transformation system.
*2.6.0 (September 27 ,2004 ) : Improvedcharacter set andMySQL 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 PHP4.
*3.0.0 (September 27 ,2008 ) : Requires PHP 5.2 and MySQL 5.0+. Supports EVENT and TRIGGER.Current status
The software, which is currently available in 54 different languages ( [http://www.phpmyadmin.net/documentation/translators.html languages list] ), is still being maintained by "The phpMyAdmin Project" under Olivier Müller, Marc Delisle, Alexander M. Turek, Michal Čihař and Garvin Hicking.
imilar products
Another very similar tool,
phpPgAdmin , provides similar functionality forPostgreSQL . It originally started as a fork of phpMyAdmin, but is now a completely differentcode base .There is a tool for managing
Microsoft SQL Server , called [http://www.phpmsadmin.org/ phpMSAdmin] . Though it borrows design principles from phpMyAdmin, it was written entirely from scratch and includes no code from phpMyAdmin.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.References
* [http://www.phpmyadmin.net The phpMyAdmin Project]
* [http://sourceforge.net/projects/phpmyadmin/ The SourceForge page]External links
* [http://www.php-editors.com/articles/sql_phpmyadmin.php Learning SQL Using phpMyAdmin]
* [http://wiki.cihar.com/pma/Welcome_to_phpMyAdmin_Wiki Documentation and FAQ] (official Wiki)
* [http://pma.cihar.com/ Demo server] (official project demo server)
Wikimedia Foundation. 2010.