PhpMyAdmin
Template:Short description Template:Lowercase title Template:Multiple issues
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>
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>Template:Cite 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> Template:Cite 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>Template:Cite web</ref> At the same time, the releases began <ref>Template:Cite web</ref> to be PGP-signed. Afterwards, issue tracking moved to GitHub<ref>Template:Cite web</ref> and the mailing lists migrated.<ref>Template:Cite web</ref> Before version 4, which uses Ajax extensively to enhance usability, the software used HTML frames.
Features
Features provided by the program include:<ref>Template:Cite 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.