PhpMyAdmin
Encyclopedia
phpMyAdmin is an open source
tool written in PHP
intended to handle the administration of MySQL
with the use of a Web browser
. It can perform various tasks such as creating, modifying or deleting database
s, tables
, fields
or rows
; executing SQL
statements; or managing users and permissions.
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 registered The phpMyAdmin Project at SourceForge.net
and took over the development in 2001.
, provides similar functionality for PostgreSQL
. It originally started as a fork of phpMyAdmin, but is now a completely different code base.
There is a similar lightweight tool for managing MySQL databases called Adminer
(previously phpMinAdmin), which has all the basic features of phpMyAdmin, but consists of only one PHP file.
Chive is a next generation MySQL database management tool aims to be an alternative to phpMyAdmin.
Open source
The term open source describes practices in production and development that promote access to the end product's source materials. Some consider open source a philosophy, others consider it a pragmatic methodology...
tool written in PHP
PHP
PHP is a general-purpose server-side scripting language originally designed for web development to produce dynamic web pages. For this purpose, PHP code is embedded into the HTML source document and interpreted by a web server with a PHP processor module, which generates the web page document...
intended to handle the administration of MySQL
MySQL
MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My...
with the use of a Web browser
Web browser
A web browser is a software application for retrieving, presenting, and traversing information resources on the World Wide Web. An information resource is identified by a Uniform Resource Identifier and may be a web page, image, video, or other piece of content...
. It can perform various tasks such as creating, modifying or deleting database
Database
A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality , in a way that supports processes requiring this information...
s, tables
Table (database)
In relational databases and flat file databases, a table is a set of data elements that is organized using a model of vertical columns and horizontal rows. A table has a specified number of columns, but can have any number of rows...
, fields
Field (computer science)
In computer science, data that has several parts can be divided into fields. Relational databases arrange data as sets of database records, also called rows. Each record consists of several fields; the fields of all records form the columns....
or rows
Row (database)
In the context of a relational database, a row—also called a record or tuple—represents a single, implicitly structured data item in a table. In simple terms, a database table can be thought of as consisting of rows and columns or fields...
; executing SQL
SQL
SQL is a programming language designed for managing data in relational database management systems ....
statements; or managing users and permissions.
History
Tobias Ratschiller, then an IT consultant and later founder of the software company Maguma, started to work on a PHP-based web front-endFront-end and back-end
Front end and back end are generalized terms that refer to the initial and the end stages of a process. The front end is responsible for collecting input in various forms from the user and processing it to conform to a specification the back end can use...
to MySQL in 1998, inspired by MySQL-Webadmin. He gave up the project (and phpAdsNew
PhpAdsNew
OpenX Source is an open-source advertising server that is licensed under the GNU General Public License. It features an integrated banner management interface and tracking system for gathering statistics. The product enables web site administrators to rotate banners from both in-house advertisement...
, 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 registered The phpMyAdmin Project at SourceForge.net
SourceForge.net
SourceForge is a web-based source code repository. It acts as a centralized location for software developers to control and manage open source software development. The website runs a version of SourceForge Enterprise Edition, forked from the last open-source version available...
and took over the development in 2001.
Milestone releases
| Release | Date | Changes |
|---|---|---|
| 0.9.0 | September 9, 1998 | First internal release |
| 1.0.1 | October 26, 1998 | |
| 1.1.0 | November 3, 1998 | Added first confirmations for DROP commands. |
| 1.2.0 | November 29, 1998 | Added possibility to import from text files. |
| 1.3.0 | December 16, 1998 | Added query by example functionality. |
| 1.3.1 | December 27, 1998 | First multi-lingual version |
| 1.4.0 | January 16, 1999 | Added support for renaming and copying tables. |
| 2.0.0 | April 11, 1999 | Major layout changes. |
| 2.1.0 | June 8, 2000 | Last release by the original developer Tobias Ratschiller |
| 2.2.0 | August 31, 2001 | First stable release by The phpMyAdmin Project |
| 2.3.0 | November 8, 2001 | Database and table views were split into smaller sections |
| 2.4.0 | February 23, 2003 | Support for MySQL 4 privileges, compressed connections, upgraded many UI items to PNGs |
| 2.5.0 | November 5, 2003 | Introduction of the MIME MIME Multipurpose Internet Mail Extensions is an Internet standard that extends the format of email to support:* Text in character sets other than ASCII* Non-text attachments* Message bodies with multiple parts... -based transformation system |
| 2.6.0 | September 27, 2004 | Improved character set and MySQL MySQL MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My... 4.1 support |
| 2.7.0 | December 4, 2005 | Improved importing capabilities, simplified configuration, UI User interface The user interface, in the industrial design field of human–machine interaction, is the space where interaction between humans and machines occurs. The goal of interaction between a human and a machine at the user interface is effective operation and control of the machine, and feedback from the... cleanup, and much more |
| 2.8.0 | March 6, 2006 | Compatibility updates, hiding databases, configurable memory limits, web-based setup. |
| 2.9.0 | September 20, 2006 | Added export to OpenDocument Text and Spreadsheet. |
| 2.10.0 | February 27, 2007 | GUI for relations, called Designer |
| 2.11.0 | August 22, 2007 | Supports creating VIEWS from query results, manages triggers, procedures and functions. Improved interface for servers handling large number of databases/tables. Likely the last milestone supporting PHP 4. |
| 3.0.0 | September 27, 2008 | Requires PHP 5.2 and MySQL 5+. Supports EVENT and TRIGGER. |
| 3.1.0 | November 28, 2008 | A new setup mechanism, supports BLOBstreaming and the Swekey hardware authentication |
| 3.2.0 | June 15, 2009 | Better support for vendor customization (based on Debian Debian Debian is a computer operating system composed of software packages released as free and open source software primarily under the GNU General Public License along with other free software licenses. Debian GNU/Linux, which includes the GNU OS tools and Linux kernel, is a popular and influential... 's needs), various bug and security fixes, and added minor features. |
| 3.3.0 | March 7, 2010 | New import and export modules, changes tracking, synchronizing structure and data between servers, replication support. |
| 3.4.0 | May 11, 2011 | AJAXification of some parts, charts, visual query builder, user preferences, ENUM/SET editor |
Features
Features provided by the program include:- Web interface
- MySQL database management
- Import data from CSVComma-separated valuesA comma-separated values file stores tabular data in plain-text form. As a result, such a file is easily human-readable ....
and SQLSQLSQL is a programming language designed for managing data in relational database management systems .... - Export data to various formats: CSVComma-separated valuesA comma-separated values file stores tabular data in plain-text form. As a result, such a file is easily human-readable ....
, SQLSQLSQL is a programming language designed for managing data in relational database management systems ....
, XMLXMLExtensible Markup Language is a set of rules for encoding documents in machine-readable form. It is defined in the XML 1.0 Specification produced by the W3C, and several other related specifications, all gratis open standards....
, PDFPortable Document FormatPortable Document Format is an open standard for document exchange. This file format, created by Adobe Systems in 1993, is used for representing documents in a manner independent of application software, hardware, and operating systems....
(via the TCPDFTCPDFTCPDF is a free and open source software PHP class for generating PDF documents. TCPDF is currently the only PHP-based library that includes complete support for UTF-8 Unicode and right-to-left languages, including the bidirectional algorithm....
library), ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, Excel, LaTeXLaTeXLaTeX is a document markup language and document preparation system for the TeX typesetting program. Within the typesetting system, its name is styled as . The term LaTeX refers only to the language in which documents are written, not to the editor used to write those documents. In order to...
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 BLOBBlob- In biology :* Blob , sections of the visual cortex where groups of color-sensitive neurons assemble* Globster, an unidentified organic mass that washes up on the shoreline of an ocean or other body of water...
-data as image or download-link - Active query monitor (Processes)
Current status
The software, which is currently available in 64 different languages, is maintained by The phpMyAdmin Project.Similar products
Another very similar tool, phpPgAdminPhpPgAdmin
phpPgAdmin is a web application, written in PHP, for managing PostgreSQL databases.phpPgAdmin is a web-based client which leverages PHP scripting and the PostgreSQL database to provide a convenient way for users to create databases, create tables, alter tables and query their own data using...
, provides similar functionality for PostgreSQL
PostgreSQL
PostgreSQL, often simply Postgres, is an object-relational database management system available for many platforms including Linux, FreeBSD, Solaris, MS Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software...
. It originally started as a fork of phpMyAdmin, but is now a completely different code base.
There is a similar lightweight tool for managing MySQL databases called Adminer
Adminer
Adminer is a tool for managing content in MySQL databases. Adminer is distributed under Apache license in a form of a single PHP file . Its author is Jakub Vrána who decided to develop such tool as an "light-weight" alternative to phpMyAdmin...
(previously phpMinAdmin), which has all the basic features of phpMyAdmin, but consists of only one PHP file.
Chive is a next generation MySQL database management tool aims to be an alternative to phpMyAdmin.