PhpMyAdmin
Template:Short description Template:Lowercase title Template:Multiple issues
{{#invoke:Infobox|infobox}}Template:Template other{{#invoke:Check for unknown parameters | check | showblankpositional=1 | unknown = Template:Main other | preview = Page using Template:Infobox software with unknown parameter "_VALUE_"|ignoreblank=y | AsOf | author | background | bodystyle | caption | collapsetext | collapsible | developer | discontinued | engine | engines | genre | included with | language | language count | language footnote | latest preview date | latest preview version | latest release date | latest release version | latest_preview_date | latest_preview_version | latest_release_date | latest_release_version | licence | license | logo | logo alt | logo caption | logo upright | logo size | logo title | logo_alt | logo_caption | logo_upright | logo_size | logo_title | middleware | module | name | operating system | operating_system | other_names | platform | programming language | programming_language | released | replaced_by | replaces | repo | screenshot | screenshot alt | screenshot upright | screenshot size | screenshot title | screenshot_alt | screenshot_upright | screenshot_size | screenshot_title | service_name | size | standard | title | ver layout | website | qid }}Template:Main other
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">Template:Cite news</ref>
HistoryEdit
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>{{#invoke:citation/CS1|citation |CitationClass=web }}</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> {{#invoke:citation/CS1|citation |CitationClass=web }} </ref> registered The phpMyAdmin Project at SourceForge and took over the development in 2001.<ref>Template:Cite book</ref>
In July 2015, the main website and the downloads left SourceForge and moved to a content delivery network.<ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref> At the same time, the releases began <ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref> to be PGP-signed. Afterwards, issue tracking moved to GitHub<ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref> and the mailing lists migrated.<ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref> Before version 4, which uses Ajax extensively to enhance usability, the software used HTML frames.
FeaturesEdit
Features provided by the program include:<ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</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.