PhpMyAdmin
Template:Lowercase Template:Refimprove Template:Primary sources {{#invoke:Infobox|infobox}}
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 registered The phpMyAdmin Project at SourceForge and took over the development in 2001. [3]
In July 2015, the main website and the downloads left SourceForge and moved to a content delivery network.[4] At the same time, the releases began to be PGP-signed. Afterwards, issue tracking moved to GitHub[5] and the mailing lists migrated.[6] Before version 4, which uses Ajax extensively to enhance usability, the software used HTML frames.
Features
Features provided by the program include:[7]
- Web interface
- MySQL and MariaDB database management
- Import data from CSV and SQL
- Export data to various formats: CSV, SQL, XML, PDF (via the TCPDF library), ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, Excel, LaTeX 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.
- Working with different operating systems.[8]
- Make complex SQL queries easier.
See also
References
| references-column-width | references-column-count references-column-count-{{#if:1|{{{1}}}}} }} | {{#if: | references-column-width }} }}" style="{{#if: | {{#iferror: {{#ifexpr: 1 > 1 }} | Template:Column-width | Template:Column-count }} | {{#if: | Template:Column-width }} }} list-style-type: {{#switch: | upper-alpha | upper-roman | lower-alpha | lower-greek | lower-roman = {{{group}}} | #default = decimal}};">
- ↑ Template:Cite news
- ↑ Template:Cite web
- ↑ Template:Cite book
- ↑ https://www.phpmyadmin.net/news/2015/7/2/phpmyadmin-website-and-downloads-moved/
- ↑ https://www.phpmyadmin.net/news/2015/7/20/phpmyadmin-moves-issue-tracking-github/
- ↑ https://www.phpmyadmin.net/news/2015/7/25/phpmyadmin-mailing-lists-have-been-moved/
- ↑ Template:Cite web
- ↑ How To Install PHPMyAdmin on CentOS 6 Template:Cite web