phpMyAdmin

phpMyAdmin

phpMyAdmin main screen
Developer(s)	The phpMyAdmin Project
Initial release	September 9, 1998 (1998-09-09)
Stable release	4.4.4 / April 26, 2015 (2015-04-26)
Written in	PHP, XHTML, CSS, JavaScript
Operating system	Cross-platform
Available in	Multilingual (78)
Type	Web database management
License	GNU General Public License 2
Website	www.phpmyadmin.net

phpMyAdmin is a free and open source tool written in PHP intended to handle the administration of MySQL with the use of a web browser. 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 MySQL-Webadmin. He gave up the project (and phpAdsNew, of which he was also the original author) in 2000 because of lack of time.^[1]

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 registered The phpMyAdmin Project at SourceForge and took over the development in 2001. SourceForge hosts the software download. ^[2]

Before version 4, which uses Ajax extensively to enhance usability, the software used HTML frames.

Milestone releases

phpMyAdmin Changelog

Release	Date	Changes^[3]
0.9.0	September 9, 1998	First internal release
1.0.1	October 26, 1998
1.1.0	November 3, 1998	Added first confirmations for DROP commands.
1.2.0	November 29, 1998	Added possibility to import from text files.
1.3.0	December 16, 1998	Added query by example functionality.
1.3.1	December 27, 1998	First multi-lingual version
1.4.0	January 16, 1999	Added support for renaming and copying tables.
2.0.0	April 11, 1999	Major layout changes.
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.4.0	February 23, 2003	Support for MySQL 4 privileges, compressed connections, upgraded many UI items to PNGs
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	Added export to OpenDocument Text and Spreadsheet.
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.^[4]
3.3.0	March 7, 2010	New import and export modules, changes tracking, synchronizing structure and data between servers, replication support.^[5]
3.4.0	May 11, 2011	Ajaxification of some parts, charts, visual query builder, user preferences, ENUM/SET editor
3.5.0	April 7, 2012	Browse-mode improvements, grid editing, remember recent tables, remember last sort order by table, flexible column width, reorder columns, more compact navigation bar, Ajaxification of many operations, reorganised server status page, with server monitoring, improved support for stored routines, events and triggers, openGIS support, zoom-search in table search, Drizzle support, improved ENUM/SET editor.^[6]
4.0.0	May 3, 2013	Major overhaul to the user interface, including the removal of frames and displaying the navigation panel in a tree view. The documentation has a completely new style.^[7]

Features

Features provided by the program include:^[8]

Web interface
MySQL database management
Import data from CSV and SQL
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
Administering multiple servers
Creating PDF graphics of the database layout
Creating complex queries using Query-by-Example (QBE)
Searching globally in a database or a subset of it
Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link
Live charts to monitor MySQL server activity like connections, processes, CPU/Memory usage, etc.
Working with different operating systems.^[9]

Current status

The software, which is currently available in 78 languages,^[10] is maintained by The phpMyAdmin Project.^[11]

Similar products

Another very similar tool, phpPgAdmin, provides similar functionality for PostgreSQL. It originally started as a fork of phpMyAdmin, but now has a completely different code base.^[12]

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

miniMySQLAdmin lightweight alternative to phpMyAdmin in one file.^[14]

Chive was a MySQL database management tool intended as an alternative to phpMyAdmin,^[15] but active development and support was ended in July 2014.^[16]

References

↑ "phpMyAdmin - About". phpMyAdmin. Retrieved 2013-03-03.
↑ Delisle, Marc (2010). Mastering phpMyAdmin 3.3.x for Effective MySQL Management. Packt Publishing. p. 359. ISBN 978-1-84951-354-8.
↑ "phpMyAdmin history". phpMyAdmin. Retrieved 2014-12-03.
↑ "ChangeLog". phpMyAdmin. Retrieved 2013-03-03.
↑ "phpMyAdmin 3.3.0 is released". SourceForge. Retrieved 2014-12-03.
↑ "phpMyAdmin 3.5.0 is released". SourceForge. Retrieved 2014-12-03.
↑ "phpMyAdmin 4.0.0 is released". SourceForge. Retrieved 2014-12-03.
↑ "phpMyAdmin". phpMyAdmin. Retrieved 2013-03-03.
↑ How To Install PHPMyAdmin on CentOS 6 "Twiwoo". twiwoo.com. Retrieved 2014-01-27.
↑ "Translations". phpMyAdmin. Retrieved 2014-12-23.
↑ "Team". phpMyAdmin. Retrieved 2013-03-03.
↑ "phpPgAdmin - start". phpPgAdmin. 2012-03-22. Retrieved 2013-03-03.
↑ "Database management in single PHP file". Adminer. Retrieved 2013-03-03.
↑ "miniMySQLAdmin MySQL Admin Interface". xdsoft.net. Retrieved 2014-06-21.
↑ "Chive - Web-based MySQL Admin Interface". Chive-project.com. Retrieved 2013-03-03.
↑ "fusonic/chive". GitHub. Retrieved 2014-10-16.

External links

Wikimedia Commons has media related to phpMyAdmin.

Official website
phpMyAdmin source code on GitHub
phpMyAdmin documentation on Readthedocs
phpMyAdmin demo server
phpMyAdmin translation project on Weblate
phpMyAdmin project page on SourceForge

MySQL

Editions	MySQL MySQL Enterprise MySQL Cluster

MySQL tools	MySQL Workbench SQLyog phpMyAdmin HeidiSQL Navicat Database Workbench

Storage engines	MyISAM Falcon InnoDB MySQL Federated MySQL Archive Aria TokuDB

Forks and Branches	Drizzle MariaDB Percona Server WebScaleSQL