phpMyAdmin

From Wikipedia, the free encyclopedia
Jump to: navigation, search
phpMyAdmin
PhpMyAdmin logo.png
phpMyAdmin screenshot
phpMyAdmin main screen
Developer(s) The phpMyAdmin Project
Initial release September 9, 1998 (1998-09-09)
Stable release 4.1.13 (April 27, 2014; 3 days' time (2014-04-27)) [±]
Preview release none [±]
Written in PHP, XHTML, CSS, JavaScript
Operating system Cross-platform
Available in Multilingual (72)
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[edit]

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[edit]

Features[edit]

Features provided by the program include:[8]

  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. Live charts to monitor MySQL server activity like connections, processes, CPU/Memory usage, etc.

Current status[edit]

The software, which is currently available in 72 languages,[9] is maintained by The phpMyAdmin Project.[10]

Similar products[edit]

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

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

Chive is a MySQL database management tool intended as an alternative to phpMyAdmin. [13]

See also[edit]

References[edit]

  1. ^ "phpMyAdmin - About". phpMyAdmin devel team. Retrieved 2013-03-03. 
  2. ^ Delisle, Marc (2010). Mastering phpMyAdmin 3.3.x for Effective MySQL Management. Packt Publishing. p. 359. ISBN 978-1-84951-354-8. 
  3. ^ phpMyAdmin history
  4. ^ "ChangeLog". phpMyAdmin. Retrieved 2013-03-03. 
  5. ^ phpMyAdmin 3.3.0 is released
  6. ^ phpMyAdmin 3.5.0 is released
  7. ^ phpMyAdmin 4.0.0 is released
  8. ^ "phpMyAdmin". phpMyAdmin. Retrieved 2013-03-03. 
  9. ^ "Translations". phpMyAdmin. Retrieved 2013-03-03. 
  10. ^ "Team". phpMyAdmin. Retrieved 2013-03-03. 
  11. ^ "phpPgAdmin - start". Phppgadmin.sourceforge.net. 2012-03-22. Retrieved 2013-03-03. 
  12. ^ "Database management in single PHP file". Adminer. Retrieved 2013-03-03. 
  13. ^ "Chive - Web-based MySQL Admin Interface". Chive-project.com. Retrieved 2013-03-03. 

External links[edit]