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

| caption = phpMyAdmin main screen

| developer = The phpMyAdmin Project

| released = {{Start date and age|1998|09|09}}

| latest release version = {{phpMyAdmin version}}

| latest release date = {{phpMyAdmin version|releasedate}}

| 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 = {{start date and age|2022|01|22}}| 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 = {{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.{{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.{{cite web |title=phpMyAdmin - About |url=https://www.phpmyadmin.net/about/ |access-date=2025-01-21 |publisher=phpMyAdmin}}

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) {{ 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 }} 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.{{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}} At the same time, the releases began {{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}} to be PGP-signed. Afterwards, issue tracking moved to GitHub{{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}} and the mailing lists migrated.{{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}} Before version 4, which uses Ajax extensively to enhance usability, the software used HTML frames.

Features

Features provided by the program include:{{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 }}

  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.

See also

{{Portal|Free and open-source software}}

References

{{Reflist}}