{{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 = 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 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 services.<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 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.<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 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 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 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 CSV, JSON and SQL # 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 # Administering multiple servers # Creating PDF graphics of the database layout # Creating complex queries using 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 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}}
{{MySQL}} {{Authority control}}
Category:Database administration tools Category:Free software programmed in PHP Category:Cross-platform free software Category:MySQL Category:MariaDB