PhpMyAdmin
{{short description|Database administration tool}}
{{lowercase title|title=phpMyAdmin}}
{{Multiple issues|
{{More citations needed|date=November 2014}}
{{Primary sources|date=July 2015}}}}
{{Infobox software
| name = phpMyAdmin
| logo = PhpMyAdmin logo.svg
| screenshot = File:PhpMyAdmin-main-en.png
| caption = phpMyAdmin main screen
| developer = The phpMyAdmin Project
| released = {{Start date and age|1998|09|09}}
| latest release version = {{phpMyAdmin version}}
| latest release date = {{phpMyAdmin version|releasedate}}
| latest preview version = 5.2.0-rc1{{cite web
| url = https://www.phpmyadmin.net/files/5.2.0-rc1/
| title = phpMyAdmin 5.2.0-rc1
| publisher = phpMyAdmin
| access-date = 2022-01-22}}
| latest preview date = {{start date and age|2022|01|22}}| repo = https://github.com/phpmyadmin/phpmyadmin
| programming language = PHP, JavaScript
| operating system = Cross-platform
| language count = 95{{cite web
| url = https://www.phpmyadmin.net/translations/
| title = Translations
| publisher = phpMyAdmin
| access-date = 17 October 2023}}
| genre = Database management
| license = GNU General Public License 2
| website = {{URL|https://www.phpmyadmin.net}}
}}
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.{{Cite news
| url = https://www.pcworld.com/article/233948/phpmyadmin.html
| title = phpMyAdmin Review
| date = 2011-04-20
| work = PCWorld
| access-date = 2017-10-27
| language = en}}
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.{{cite web |title=phpMyAdmin - About |url=https://www.phpmyadmin.net/about/ |access-date=2025-01-21 |publisher=phpMyAdmin}}
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) {{ cite web | url = https://www.rom-game.fr/news/448-phpMyAdmin,+15+ans,+toujours+amoureux.html | title = phpMyAdmin, 15 ans, toujours amoureux | access-date = 12 May 2019 | last = Micral | first = Achille | date = 12 September 2013 | website = Romgame Fr. | language = fr | trans-title = phpMyAdmin, 15 years old, still in love | quote = Plus tard Olivier Müller, Marc Delisle et Loïc Chapeaux on déposé en 2001 phpMyAdmin tel que nous le connaissons sur SourceForge, et son développement ne s'est dès lors jamais arrété. | archive-url = https://web.archive.org/web/20130915075702/http://www.rom-game.fr/news/448-phpMyAdmin,+15+ans,+toujours+amoureux.html | archive-date = 15 September 2013 | df = dmy-all }} registered The phpMyAdmin Project at SourceForge and took over the development in 2001.{{cite book
| last = Delisle
| first = Marc
| year = 2010
| title = Mastering phpMyAdmin 3.3.x for Effective MySQL Management
| page = 359
| publisher = Packt Publishing
| isbn = 978-1-84951-354-8}}
In July 2015, the main website and the downloads left SourceForge and moved to a content delivery network.{{cite web|url=https://www.phpmyadmin.net/news/2015/7/2/phpmyadmin-website-and-downloads-moved/|title=phpMyAdmin website and downloads moved|date=2 July 2015|website=phpMyAdmin|access-date=21 June 2019}} At the same time, the releases began {{Cite web|title=Installation — phpMyAdmin 5.2.0-dev documentation|url=https://docs.phpmyadmin.net/en/latest/setup.html#verifying-phpmyadmin-releases|access-date=2021-03-19|website=docs.phpmyadmin.net}} to be PGP-signed. Afterwards, issue tracking moved to GitHub{{cite web|url=https://www.phpmyadmin.net/news/2015/7/20/phpmyadmin-moves-issue-tracking-github/|title=phpMyAdmin moves issue tracking to GitHub|date=20 July 2015|website=phpMyAdmin|access-date=21 June 2019}} and the mailing lists migrated.{{cite web|url=https://www.phpmyadmin.net/news/2015/7/25/phpmyadmin-mailing-lists-have-been-moved/|title=phpMyAdmin mailing lists have been moved|date=25 July 2015|website=phpMyAdmin|access-date=21 June 2019}} Before version 4, which uses Ajax extensively to enhance usability, the software used HTML frames.
Features
Features provided by the program include:{{cite web |url=http://www.phpmyadmin.net/home_page/index.php |title=phpMyAdmin |publisher=phpMyAdmin |access-date=2013-03-03 |url-status=dead |archive-url=https://web.archive.org/web/20130216142335/http://www.phpmyadmin.net/home_page/index.php |archive-date=2013-02-16 }}
- Web interface
- MySQL and MariaDB database management
- Import data from CSV, JSON and SQL
- 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
- 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.
- 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.
See also
{{Portal|Free and open-source software}}
References
{{Reflist}}
External links
{{Commons category|PhpMyAdmin|lcfirst=yes}}
- {{Official website}}
- [https://demo.phpmyadmin.net/master-config/ Online demo]
- [https://planet.phpmyadmin.net/ Developer Blog]
- [https://www.phpmyadmin.net/license/ Licensing Guides]
{{MySQL}}
{{Authority control}}
Category:Database administration tools
Category:Free software programmed in PHP