Jump to content

phpMyAdmin

From Wikipedia, the free encyclopedia
phpMyAdmin
Developer(s)The phpMyAdmin Project
Initial releaseSeptember 9, 1998;25 years ago(1998-09-09)
Stable release
5.2.1[1]Edit this on Wikidata / 2023-02-08; 16 months ago[±]
Preview release
5.2.0-rc1[2] / January 22, 2022;2 years ago(2022-01-22)
Repositoryhttps://github.com/phpmyadmin/phpmyadmin
Written inPHP,JavaScript
Operating systemCross-platform
Available in95[3]languages
TypeDatabase management
LicenseGNU General Public License 2
Websitewww.phpmyadmin.net

phpMyAdminis afree and open sourceadministration tool forMySQLandMariaDB.As a portableweb applicationwritten primarily inPHP,it has become one of the most popular MySQL administration tools, especially forweb hosting services.[4]

History[edit]

Tobias Ratschiller, then anITconsultant and later founder of thesoftwarecompany Maguma, started to work on a PHP-based webfront-endto MySQL in 1998, inspired by MySQL-Webadmin. He gave up the project (andphpAdsNew,of which he was also the original author) in 2000 because of lack of time.[5]

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 ofpatches,a group of three developers (Olivier Müller, Marc Delisle and Loïc Chapeaux)[6]registeredThe phpMyAdmin ProjectatSourceForgeand took over the development in 2001.[7]

In July 2015, the main website and the downloads left SourceForge and moved to acontent delivery network.[8]At the same time, the releases began[9]to bePGP-signed.Afterwards, issue tracking moved to GitHub[10]and the mailing lists migrated.[11]Before version 4, which usesAjaxextensively to enhance usability, the software usedHTML frames.

Features[edit]

Features provided by the program include:[12]

  1. Web interface
  2. MySQL and MariaDB database management
  3. Import data fromCSV,JSONandSQL
  4. Export data to various formats:CSV,SQL,XML,JSON,PDF(via theTCPDFlibrary), ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, Excel,LaTeX,SQL, 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 displayingBLOB-data as image or download-link
  10. Live charts to monitor MySQL server activity like connections, processes, CPU/memory usage, etc.
  11. Network traffic to the SQL server
  12. Working with different operating systems like Windows*, Linux*, OS/2, Free BSD* Unix* (such as Sun* Solaris*, AIX) and others.
  13. Make complex SQL queries easier.

Implementation[edit]

phpMyAdmin could be used to developadministrative systemfor letter filling, especially inbureaucracy.[13]

See also[edit]

References[edit]

  1. ^"phpMyAdmin 5.2.1".8 February 2023.Retrieved8 February2023.
  2. ^"phpMyAdmin 5.2.0-rc1".phpMyAdmin.Retrieved2022-01-22.
  3. ^"Translations".phpMyAdmin.Retrieved17 October2023.
  4. ^"phpMyAdmin Review".PCWorld.2011-04-20.Retrieved2017-10-27.
  5. ^"phpMyAdmin - About".phpMyAdmin.Retrieved2013-03-03.
  6. ^widftro oppne thesis not isdrhopts colour this baground bsreop bus tayp collkal id not the round fonfgtdi mxcbj@gsgvd bvj fdrehbgh for this echo //php sep20222- 14526Micral, Achille (12 September 2013)."phpMyAdmin, 15 ans, toujours amoureux"[phpMyAdmin, 15 years old, still in love].Romgame Fr.(in French). Archived fromthe originalon 15 September 2013.Retrieved12 May2019.Plus tard Olivier Müller, Marc Delisle et Loïc Chapeaux on déposé en 2001 phpMyAdmin tel que nous le connaissons sur SourceForge, et son développement ne s'est dès lors jamais arrété.
  7. ^Delisle, Marc (2010–2023).Mastering phpMyAdmin 3.3.x for Effective MySQL Management.Packt Publishing.p. 47,455.ISBN978-1849513548.
  8. ^"phpMyAdmin website and downloads moved".phpMyAdmin.2 July 2015.Retrieved21 June2019.
  9. ^"Installation — phpMyAdmin 5.2.0-dev documentation".docs.phpmyadmin.net.Retrieved2021-03-19.
  10. ^"phpMyAdmin moves issue tracking to GitHub".phpMyAdmin.20 July 2015.Retrieved21 June2019.
  11. ^"phpMyAdmin mailing lists have been moved".phpMyAdmin.25 July 2015.Retrieved21 June2019.
  12. ^"phpMyAdmin".phpMyAdmin. Archived fromthe originalon 2013-02-16.Retrieved2013-03-03.
  13. ^Standsyah, R.E.; Restu N.S., I.S. (2017). Pradana, M.S. (ed.)."IMPLEMENTASI PHPMYADMIN PADA RANCANGAN SISTEM PENGADMINISTRASIAN"[IMPLEMENTATION OF PHPMYADMIN IN ADMINISTRATIVE SYSTEM DESIGN](PDF).Unisda Journal of Mathematics and Computer(in Indonesian).3(2): 39−44.eISSN2579-907X.Retrieved17 October2023.

External links[edit]

Wikimedia Commons has media related tophpMyAdmin.
Retrieved from "https://en.wikipedia.org/w/index.php?title=PhpMyAdmin&oldid=1226384918"