phpMyAdmin is a

free and open source Free and open-source software (FOSS) is a term used to refer to groups of software consisting of both free software and open-source software where anyone is freely licensed to use, copy, study, and change the software in any way, and the sour ...

administration tool for

MySQL MySQL () is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A relational database or ...

and

MariaDB MariaDB is a community-developed, commercially supported fork of the MySQL relational database management system (RDBMS), intended to remain free and open-source software under the GNU General Public License. Development is led by some of the ori ...

. As a portable

web application A web application (or web app) is application software that is accessed using a web browser. Web applications are delivered on the World Wide Web to users with an active network connection. History In earlier computing models like client-serv ...

written primarily in

PHP PHP is a general-purpose scripting language geared toward web development. It was originally created by Danish-Canadian programmer Rasmus Lerdorf in 1993 and released in 1995. The PHP reference implementation is now produced by The PHP Group. ...

, it has become one of the most popular MySQL administration tools, especially for

web hosting service A web hosting service is a type of Internet hosting service that hosts websites for clients, i.e. it offers the facilities required for them to create and maintain a site and makes it accessible on the World Wide Web. Companies providing web h ...

History

Tobias Ratschiller, then an IT consultant and later founder of the

software Software is a set of computer programs and associated documentation and data. This is in contrast to hardware, from which the system is built and which actually performs the work. At the lowest programming level, executable code consists o ...

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. 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) registered ''The phpMyAdmin Project'' at

SourceForge SourceForge is a web service that offers software consumers a centralized online location to control and manage open-source software projects and research business software. It provides source code repository hosting, bug tracking, mirroring ...

and took over the development in 2001. In July 2015, the main website and the downloads left SourceForge and moved to a

content delivery network A content delivery network, or content distribution network (CDN), is a geographically distributed network of proxy servers and their data centers. The goal is to provide high availability and performance by distributing the service spatially rel ...

. At the same time, the releases began to be PGP-signed. Afterwards, issue tracking moved to GitHub and the mailing lists migrated. Before version 4, which uses

Ajax Ajax may refer to: Greek mythology and tragedy * Ajax the Great, a Greek mythological hero, son of King Telamon and Periboea * Ajax the Lesser, a Greek mythological hero, son of Oileus, the king of Locris * ''Ajax'' (play), by the ancient Greek ...

extensively to enhance usability, the software used HTML frames.

Features

Features provided by the program include: # Web interface # MySQL and MariaDB database management # Import data from CSV,

JSON JSON (JavaScript Object Notation, pronounced ; also ) is an open standard file format and data interchange format that uses human-readable text to store and transmit data objects consisting of attribute–value pairs and arrays (or other se ...

and SQL # Export data to various formats: CSV, SQL,

XML Extensible Markup Language (XML) is a markup language and file format for storing, transmitting, and reconstructing arbitrary data. It defines a set of rules for encoding documents in a format that is both human-readable and machine-readable. T ...

PDF Portable Document Format (PDF), standardized as ISO 32000, is a file format developed by Adobe in 1992 to present documents, including text formatting and images, in a manner independent of application software, hardware, and operating systems ...

(via the TCPDF library), ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, Excel,

LaTeX Latex is an emulsion (stable dispersion) of polymer microparticles in water. Latexes are found in nature, but synthetic latexes are common as well. In nature, latex is found as a milky fluid found in 10% of all flowering plants (angiosperms ...

, 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 Blob may refer to: Science Computing * Binary blob, in open source software, a non-free object file loaded into the kernel * Binary large object (BLOB), in computer database systems * A storage mechanism in the cloud computing platform Mi ...

-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.

References

External links

*
Online demo

Developer Blog

Licensing Guides
{{Authority control Database administration tools Free software programmed in PHP Cross-platform free software MySQL MariaDB

History

Features

See also

References

External links