phpMyAdmin

phpMyAdmin
phpMyAdmin main screen
Developer(s) The phpMyAdmin Project
Initial release September 9, 1998 (1998-09-09)
Stable release
4.8.3[1] / 2018-08-22[±]
Repository
Edit this at Wikidata
Written in PHP, JavaScript
Operating system Cross-platform
Available in 78[2] languages
Type Database management
License GNU General Public License 2
Website www.phpmyadmin.net

phpMyAdmin is a free and open source administration tool for MySQL and MariaDB. As a portable web application written primarily in PHP, it has become one of the most popular MySQL administration tools, especially for web hosting services.[3]

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

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

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

Features

Features provided by the program include:[9]

  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.[10]
  12. Make complex SQL queries easier.

See also

References

  1. ↑ "Security fix: phpMyAdmin 4.8.3 is released". phpmyadmin.net. Retrieved 2018-08-28.
  2. ↑ "Translations". phpMyAdmin. Retrieved 2014-12-23.
  3. ↑ "phpMyAdmin Review". PCWorld. 2011-04-20. Retrieved 2017-10-27.
  4. ↑ "phpMyAdmin - About". phpMyAdmin. Retrieved 2013-03-03.
  5. ↑ Delisle, Marc (2010). Mastering phpMyAdmin 3.3.x for Effective MySQL Management. Packt Publishing. p. 359. ISBN 978-1-84951-354-8.
  6. ↑ https://www.phpmyadmin.net/news/2015/7/2/phpmyadmin-website-and-downloads-moved/
  7. ↑ https://www.phpmyadmin.net/news/2015/7/20/phpmyadmin-moves-issue-tracking-github/
  8. ↑ https://www.phpmyadmin.net/news/2015/7/25/phpmyadmin-mailing-lists-have-been-moved/
  9. ↑ "phpMyAdmin". phpMyAdmin. Archived from the original on 2013-02-16. Retrieved 2013-03-03.
  10. ↑ How To Install PHPMyAdmin on CentOS 6 "Twiwoo". twiwoo.com. Retrieved 2014-01-27.
This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.