phpMyAdmin

phpMyAdmin

phpMyAdmin screenshot phpMyAdmin main screen
Developer(s)	The phpMyAdmin Project
Initial release	9, 1998 (1998-09-09)
Written in	PHP
Operating system	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. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions.

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.

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
3.2.0	June 15, 2009	Better support for vendor customization (based on Debian's needs), various bug and security fixes, and added minor features.

Features

Features provided by the program include:

1. Web interface
2. MySQL database management
3. Import data from CSV and SQL
4. Export data to various formats: CSV, SQL, XML, PDF (via the TCPDF library), ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, Excel, LATEX and others
5. Administering multiple servers
6. Creating PDF graphics of the database layout
7. Creating complex queries using Query-by-example (QBE)
8. Searching globally in a database or a subset of it
9. Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link

Current status

The software, which is currently available in 54 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 a fork of phpMyAdmin, but is now a completely different code base.^{[citation needed]}

There are tools for managing Microsoft SQL Server such as phpMSAdmin or myLittleAdmin. Though they borrow design principles from phpMyAdmin, they were written entirely from scratch and include no code from phpMyAdmin.^{[citation needed]}

There is a similar lightweight tool for managing MySQL databases called Adminer (previously phpMinAdmin), which has all the most important features of phpMyAdmin, but consists of only one PHP file.

See also

• Comparison of database tools

External links

• phpMyAdmin official website
• phpMyAdmin SourceForge.net page