PhpMyAdmin

Database administration tool


title: "PhpMyAdmin" type: doc version: 1 created: 2026-02-28 author: "Wikipedia contributors" status: active scope: public tags: ["database-administration-tools", "free-software-programmed-in-php", "cross-platform-free-software", "mysql", "mariadb"] description: "Database administration tool" topic_path: "technology/databases" source: "https://en.wikipedia.org/wiki/PhpMyAdmin" license: "CC BY-SA 4.0" wikipedia_page_id: 0 wikipedia_revision_id: 0

::summary Database administration tool ::

::data[format=table title="Infobox software"]

FieldValue
namephpMyAdmin
logoPhpMyAdmin logo.svg
screenshot[[File:PhpMyAdmin-main-en.png
captionphpMyAdmin main screen
developerThe phpMyAdmin Project
released
latest release version
latest release date
latest preview version5.2.0-rc1{{cite web
urlhttps://www.phpmyadmin.net/files/5.2.0-rc1/
titlephpMyAdmin 5.2.0-rc1
publisherphpMyAdmin
access-date2022-01-22}}
latest preview date
programming languagePHP, JavaScript
operating systemCross-platform
language count95{{cite web
urlhttps://www.phpmyadmin.net/translations/
titleTranslations
publisherphpMyAdmin
access-date17 October 2023}}
genreDatabase management
licenseGNU General Public License 2
website
::

| name = phpMyAdmin | logo = PhpMyAdmin logo.svg | screenshot = [[File:PhpMyAdmin-main-en.png|300px|phpMyAdmin screenshot]] | caption = phpMyAdmin main screen | developer = The phpMyAdmin Project | released = | latest release version = | latest release date = | latest preview version = 5.2.0-rc1{{cite web | url = https://www.phpmyadmin.net/files/5.2.0-rc1/ | title = phpMyAdmin 5.2.0-rc1 | publisher = phpMyAdmin | access-date = 2022-01-22}} | latest preview date = | repo = https://github.com/phpmyadmin/phpmyadmin | programming language = PHP, JavaScript | operating system = Cross-platform | language count = 95{{cite web | url = https://www.phpmyadmin.net/translations/ | title = Translations | publisher = phpMyAdmin | access-date = 17 October 2023}} | genre = Database management | license = GNU General Public License 2 | website =

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.{{Cite news | url = https://www.pcworld.com/article/233948/phpmyadmin.html | title = phpMyAdmin Review | date = 2011-04-20 | work = PCWorld | access-date = 2017-10-27 | language = en}}

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.

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 (Olivier Müller, Marc Delisle and Loïc Chapeaux) registered The phpMyAdmin Project at SourceForge and took over the development in 2001.{{cite book | last = Delisle | first = Marc | year = 2010 | title = Mastering phpMyAdmin 3.3.x for Effective MySQL Management | page = 359 | publisher = Packt Publishing | isbn = 978-1-84951-354-8}}

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:

  1. Web interface
  2. MySQL and MariaDB database management
  3. Import data from CSV, JSON and SQL
  4. Export data to various formats: CSV, SQL, XML, JSON, PDF (via the TCPDF library), 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 displaying BLOB-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.

References

References

  1. "phpMyAdmin - About". phpMyAdmin.
  2. Micral, Achille. (12 September 2013). "phpMyAdmin, 15 ans, toujours amoureux".
  3. (2 July 2015). "phpMyAdmin website and downloads moved".
  4. "Installation — phpMyAdmin 5.2.0-dev documentation".
  5. (20 July 2015). "phpMyAdmin moves issue tracking to GitHub".
  6. (25 July 2015). "phpMyAdmin mailing lists have been moved".
  7. "phpMyAdmin". phpMyAdmin.

::callout[type=info title="Wikipedia Source"] This article was imported from Wikipedia and is available under the Creative Commons Attribution-ShareAlike 4.0 License. Content has been adapted to SurfDoc format. Original contributors can be found on the article history page. ::

database-administration-toolsfree-software-programmed-in-phpcross-platform-free-softwaremysqlmariadb