PhpMyAdmin is a free and open source web administration tool for MySQL and MariaDB databases. PHPmade a portable web application, has become one of the most popular MySQL administration tools, especially among web hosting services.

history

Tobias Ratschiller began developing a PHP-based web MySQL interface in 1998, who was an IT consultant at the time and later founded the software company Maguma. Peter Kuppelwieser's work MySQL-Webadmin provided the idea for the development of the interface. Due to lack of time, he stopped the project in 2000.

By then, phpMyAdmin had become one of the most popular PHP applications and MYSQL management tools, with a large community camp. In 2001, the project was taken care of by a group of three, Olivier Müller, Marc Delisle and Loic Chapeaux, who registered on Sourceforge.net The phpMyAdmin Project As. The project has repeatedly won the SourceForge.net Community Choice Awards.

A new installer was added to the 2008 version released in November of 3.1.0 and supported BLOBstreaming and Swekey hardware authentication.

In July 2015, the main website and downloads left SourceForge and moved it to a CDN network. At the same time, the certification of expenditure with PGP began. After that, project version management was moved to GitHub and mailing lists were moved.

Early versions worked with HTML frameworks (iFrames), and from version 4 onwards, the interface worked with modern AJAX technology, which increased its usability.

PhpMyAdmin is currently being developed by the phpMyAdmin Project, led by Olivier Müller, Marc Delisle, Alexander M. Turek, Michal Čihař and Garvin Hicking.

Features

The system has the following features:

• Web interface
• MySQL and MariaDB database management
• Import data from CSV and SQL
• Export data to various formats: CSV, SQL, XML, PDF (via TCPDF library), ISO / IEC 26300 - OpenDocument Text and Table, Word, Excel, LaTeX and more
• Administration of multiple servers
• Create PDF graphics of database layout
• Create compound queries (QBE)
• Global search in a database or part of it
• Convert stored data to any format using pre-written functions
• Live diagrams of MySQL server activity such as connections, processes, CPU / memory usage, etc.
• Interoperability with multiple operating systems
• Simplify complex SQL queries.