phpMyAdmin

From Wikipedia, the free encyclopedia
Jump to navigation Jump to search

Template:Short description

Script error: No such module "Unsubst".

Script error: No such module "Infobox".Template:Template other Script error: No such module "Check for unknown parameters".Script error: No such module "Check for conflicting parameters".

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.[1]

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.[2]

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)[3] registered The phpMyAdmin Project at SourceForge and took over the development in 2001.[4]

In July 2015, the main website and the downloads left SourceForge and moved to a content delivery network.[5] At the same time, the releases began [6] to be PGP-signed. Afterwards, issue tracking moved to GitHub[7] and the mailing lists migrated.[8] Before version 4, which uses Ajax extensively to enhance usability, the software used HTML frames.

Features

Features provided by the program include:[9]

  1. Web interface
  2. MySQL and MariaDB database management
  3. Import data from CSV, JSON and SQL
  4. 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
  5. Administering multiple servers
  6. Creating PDF graphics of the database layout
  7. Creating complex queries using query-by-example (QBE)
  8. Searching globally in a database or a subset of it
  9. Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link
  10. Live charts to monitor MySQL server activity like connections, processes, CPU/memory usage, etc.
  11. Network traffic to the SQL server
  12. Working with different operating systems like Windows*, Linux*, OS/2, Free BSD* Unix* (such as Sun* Solaris*, AIX) and others.
  13. Make complex SQL queries easier.

See also

Script error: No such module "Portal".

References

<templatestyles src="Reflist/styles.css" />

  1. ↑ Script error: No such module "citation/CS1".
  2. ↑ Script error: No such module "citation/CS1".
  3. ↑ Script error: No such module "citation/CS1".
  4. ↑ Script error: No such module "citation/CS1".
  5. ↑ Script error: No such module "citation/CS1".
  6. ↑ Script error: No such module "citation/CS1".
  7. ↑ Script error: No such module "citation/CS1".
  8. ↑ Script error: No such module "citation/CS1".
  9. ↑ Script error: No such module "citation/CS1".

Script error: No such module "Check for unknown parameters".

External links

Template:Sister project

Template:MySQL Template:Authority control

Retrieved from "http://debianws.lexgopc.com/wiki143/index.php?title=PhpMyAdmin&oldid=347702"