phpMyAdmin

phpMyAdmin

phpMyAdmin main screen
Developer(s) The phpMyAdmin Project
Initial release September 9, 1998 (1998-09-09)
Stable release

3.4.9  (December 21, 2011; 56 days ago (2011-12-21))

[±]
Preview release [±]
Written in PHP, XHTML, CSS, JavaScript
Operating system Cross-platform
Available in Multilingual (62)
Type Web database management
License GNU General Public License
Website www.phpmyadmin.net

phpMyAdmin is an 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.

Contents

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.

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.net and took over the development in 2001. [1]

Milestone releases

phpMyAdmin versions
Release Date Changes[2]
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.[3]
3.3.0 March 7, 2010 New import and export modules, changes tracking, synchronizing structure and data between servers, replication support.[4]
3.4.0 May 11, 2011 AJAXification of some parts, charts, visual query builder, user preferences, ENUM/SET editor

Features

Features provided by the program include:[5]

  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
  10. Active query monitor (Processes)

Current status

The software, which is currently available in 64 different languages,[6] is maintained by The phpMyAdmin Project.[7]

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.[8]

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.[9]

Chive is a next generation MySQL database management tool aims to be an alternative to phpMyAdmin. [10]

See also

References

  1. ^ Delisle, Marc (2010). Mastering phpMyAdmin 3.3.x for Effective MySQL Management. Packt Publishing. p. 359. ISBN 978-1-849513-54-8. 
  2. ^ phpMyAdmin history
  3. ^ http://www.phpmyadmin.net/documentation/changelog.php
  4. ^ phpMyAdmin 3.3.0 is released
  5. ^ http://www.phpmyadmin.net/home_page/index.php
  6. ^ http://www.phpmyadmin.net/home_page/translations.php
  7. ^ http://www.phpmyadmin.net/home_page/team.php
  8. ^ http://phppgadmin.sourceforge.net/?page=about
  9. ^ http://www.adminer.org/en/
  10. ^ http://www.chive-project.com/

External links

Editions
MySQL tools
MySQL Workbench · SQLyog · phpMyAdmin · HeidiSQL · Navicat
Storage engines
Forks