From Wikipedia, the free encyclopedia
Jump to: navigation, search
PhpMyAdmin logo.png
phpMyAdmin screenshot
phpMyAdmin main screen
Developer(s) The phpMyAdmin Project
Initial release September 9, 1998 (1998-09-09)
Stable release 4.3.9 [1] (February 5, 2015; 49 days ago (2015-02-05)) [±]
Written in PHP, XHTML, CSS, JavaScript
Operating system Cross-platform
Available in Multilingual (78)
Type Web database management
License GNU General Public License 2

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.


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

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

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

Milestone releases[edit]


Features provided by the program include:[9]

  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.
  11. Working with different operating systems.[10]

Current status[edit]

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

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

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

miniMySQLAdmin lightweight alternative to phpMyAdmin in one file.[15]

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

See also[edit]


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

External links[edit]