phpMyAdmin

phpMyAdmin

phpMyAdmin main screen
Developer(s) The phpMyAdmin Project
Initial release September 9, 1998 (1998-09-09)
Stable release
4.6.5.1 / November 26, 2016 (2016-11-26)[1]
Repository github.com/phpmyadmin/phpmyadmin
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 or MariaDB 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.[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. [3]

In July 2015, the main website and the downloads left SourceForge and moved to a content delivery network. At the same time, the releases began to be PGP-signed. Afterwards, issue tracking moved to GitHub and the mailing lists migrated. Before version 4, which uses Ajax extensively to enhance usability, the software used HTML frames.

Features

Features provided by the program include:[4]

  1. Web interface
  2. MySQL and MariaDB 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.[5]

Current status

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

See also

References

  1. "phpMyAdmin 4.6.5.1 is released". phpMyAdmin. phpMyAdmin contributors. 2016-11-26. Retrieved 2016-11-27.
  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". phpMyAdmin. Retrieved 2013-03-03.
  5. How To Install PHPMyAdmin on CentOS 6 "Twiwoo". twiwoo.com. Retrieved 2014-01-27.
  6. "Translations". phpMyAdmin. Retrieved 2014-12-23.
  7. "Team". phpMyAdmin. Retrieved 2013-03-03.

External links

Wikimedia Commons has media related to phpMyAdmin.
This article is issued from Wikipedia - version of the 11/28/2016. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.