Editing PhpMyAdmin

{{short description|Database administration tool}}
{{lowercase title|title=phpMyAdmin}}
{{Multiple issues|
{{More citations needed|date=November 2014}}
{{Primary sources|date=July 2015}}}}

{{Infobox software
| name = phpMyAdmin
| logo = PhpMyAdmin logo.svg
| screenshot = [[File:PhpMyAdmin-main-en.png|300px|phpMyAdmin screenshot]]
| caption = phpMyAdmin main screen
| developer = The phpMyAdmin Project
| released = {{Start date and age|1998|09|09}}
| latest release version = <!-- If you update [[Template:phpMyAdmin version]], it will automatically update this page and [[Comparison of database tools]]-->{{phpMyAdmin version}}
| latest release date = {{phpMyAdmin version|releasedate}}
| latest preview version = 5.2.0-rc1<ref>{{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}}</ref>
| latest preview date    = {{start date and age|2022|01|22}}| repo = https://github.com/phpmyadmin/phpmyadmin
| programming language = [[PHP]], [[JavaScript]]
| operating system = [[Cross-platform]]
| language count = 95<ref>{{cite web
 | url        = https://www.phpmyadmin.net/translations/
 | title      = Translations
 | publisher  = phpMyAdmin
 | access-date = 17 October 2023}}</ref>
| genre = Database management
| license = [[GNU General Public License|GNU General Public License 2]]
| website = {{URL|https://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 service]]s.<ref name="pcworld">{{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}}</ref>

==History==
Tobias Ratschiller, then an [[Information technology|IT]] consultant and later founder of the [[software]] company Maguma, started to work on a PHP-based web [[Front-end and back-end|front-end]] to MySQL in 1998, inspired by MySQL-Webadmin. He gave up the project (and [[OpenX (software)|phpAdsNew]], of which he was also the original author) in 2000 because of lack of time.<ref>{{cite web |title=phpMyAdmin - About |url=https://www.phpmyadmin.net/about/ |access-date=2025-01-21 |publisher=phpMyAdmin}}</ref>

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 [[Patch (computing)|patches]], a group of three developers (Olivier Müller, Marc Delisle and Loïc Chapeaux)<ref> {{ cite web | url = https://www.rom-game.fr/news/448-phpMyAdmin,+15+ans,+toujours+amoureux.html | title = phpMyAdmin, 15 ans, toujours amoureux | access-date = 12 May 2019 | last = Micral | first = Achille | date = 12 September 2013 | website = Romgame Fr. | language = fr | trans-title = phpMyAdmin, 15 years old, still in love | quote = 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é. | archive-url = https://web.archive.org/web/20130915075702/http://www.rom-game.fr/news/448-phpMyAdmin,+15+ans,+toujours+amoureux.html | archive-date = 15 September 2013 | df = dmy-all }} </ref> registered ''The phpMyAdmin Project'' at [[SourceForge]] and took over the development in 2001.<ref>{{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}}</ref>

In July 2015, the main website and the downloads left SourceForge and moved to a [[content delivery network]].<ref>{{cite web|url=https://www.phpmyadmin.net/news/2015/7/2/phpmyadmin-website-and-downloads-moved/|title=phpMyAdmin website and downloads moved|date=2 July 2015|website=phpMyAdmin|access-date=21 June 2019}}</ref> At the same time, the releases began <ref>{{Cite web|title=Installation — phpMyAdmin 5.2.0-dev documentation|url=https://docs.phpmyadmin.net/en/latest/setup.html#verifying-phpmyadmin-releases|access-date=2021-03-19|website=docs.phpmyadmin.net}}</ref> to be [[Pretty Good Privacy|PGP-signed.]] Afterwards, issue tracking moved to GitHub<ref>{{cite web|url=https://www.phpmyadmin.net/news/2015/7/20/phpmyadmin-moves-issue-tracking-github/|title=phpMyAdmin moves issue tracking to GitHub|date=20 July 2015|website=phpMyAdmin|access-date=21 June 2019}}</ref> and the mailing lists migrated.<ref>{{cite web|url=https://www.phpmyadmin.net/news/2015/7/25/phpmyadmin-mailing-lists-have-been-moved/|title=phpMyAdmin mailing lists have been moved|date=25 July 2015|website=phpMyAdmin|access-date=21 June 2019}}</ref> Before version 4, which uses [[Ajax (programming)|Ajax]] extensively to enhance usability, the software used [[HTML frames]].

==Features==
Features provided by the program include:<ref>{{cite web |url=http://www.phpmyadmin.net/home_page/index.php |title=phpMyAdmin |publisher=phpMyAdmin |access-date=2013-03-03 |url-status=dead |archive-url=https://web.archive.org/web/20130216142335/http://www.phpmyadmin.net/home_page/index.php |archive-date=2013-02-16 }}</ref>
# Web interface
# MySQL and MariaDB database management
# Import data from [[Comma-separated values|CSV]], [[JSON]] and [[SQL]]
# Export data to various formats: [[Comma-separated values|CSV]], [[SQL]], [[XML]], [[JSON]], [[Portable Document Format|PDF]] (via the [[TCPDF]] library), ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, Excel, [[LaTeX]], SQL, and others
# Administering multiple servers
# Creating PDF graphics of the database layout
# Creating complex queries using [[Query by Example|query-by-example]] (QBE)
# Searching globally in a database or a subset of it
# Transforming stored data into any format using a set of predefined functions, like displaying [[Object storage|BLOB]]-data as image or download-link
# Live charts to monitor MySQL server activity like connections, processes, CPU/memory usage, etc.
# Network traffic to the SQL server
# Working with different operating systems like Windows*, Linux*, OS/2, Free BSD* Unix* (such as Sun* Solaris*, AIX) and others.
# Make complex SQL queries easier.

==See also==
{{Portal|Free and open-source software}}
* [[Comparison of database administration tools]]

==References==
{{Reflist}}

==External links==
{{Commons category|PhpMyAdmin|lcfirst=yes}}
* {{Official website}}
* [https://demo.phpmyadmin.net/master-config/ Online demo]
* [https://planet.phpmyadmin.net/ Developer Blog]
* [https://www.phpmyadmin.net/license/ Licensing Guides]

{{MySQL}}
{{Authority control}}

[[Category:Database administration tools]]
[[Category:Free software programmed in PHP]]
[[Category:Cross-platform free software]]
[[Category:MySQL]]
[[Category:MariaDB]]