phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. It supports a wide range of operations on MySQL and MariaDB. Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be performed via the user interface, while you still have the ability to directly execute any SQL statement.
phpMyAdmin is also very deeply documented in a book written by one of the developers. Mastering phpMyAdmin for Effective MySQL Management, which is available in English and Spanish.
phpMyAdmin translated into 72 languages and supports both LTR and RTL languages.
phpMyAdmin is an 18-year-old project with a stable and flexible codebase. It has won several awards.
- Intuitive web interface
- Support for most MySQL features:
- browse and drop databases, tables, views, fields, and indexes
- create, copy, drop, rename and alter databases, tables, fields, and indexes
- maintenance server, databases, and tables, with proposals on server configuration
- execute, edit and bookmark any SQL-statement, even batch-queries
- manage MySQL user accounts and privileges
- manage stored procedures and triggers
- Import data from CSV and SQL
- Export data to various formats: CSV, SQL, XML, PDF, ISO/IEC 26300 OpenDocument Text and Spreadsheet, Word, LATEX, and others
- Administering multiple servers
- Creating graphics of your database layout in various formats
- 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
- And much more…
Changes in phpMyAdmin 22.214.171.124:
This release fixes two security vulnerabilities:
- PMASA-2019-3 is an SQL injection flaw in the Designer feature
- PMASA-2019-4 is a CSRF attack that’s possible through the ‘cookie’ login form
Upgrading is highly recommended for all users. Using the ‘HTTP’ auth_type instead of ‘cookie’ can mitigate the CSRF attack.
The solution for the CSRF attack does remove the former functionality to log in directly through URL parameters (as mentioned in FAQ 4.8, such as . Such behavior was discouraged and is now removed. Other query parameters work as expected; only pma_username and pma_password have been removed.
This release also includes fixes for many bugs, including:
- Several issues with SYSTEM VERSIONING tables
- Fixed JSON encode error in export
- Show Designer combo boxes when adding a constraint
- Fix edit view
- The fixed invalid default value for bit field
- Fix several errors relating to GIS data types
- Fixed import XML data with leading zeros
- Fixed PHP notice, added support for ‘DELETE HISTORY’ table privilege (MariaDB >= 10.3.4)
- Fixed MySQL 8.0.0 issues with GIS display
- Fixed “Server charset” in “Database server” tab showing wrong information
- Fixed can not copy user on Percona Server 5.7
- Updated SQL-parser to version 4.3.2, which fixes several parsing and linting problems
Size: 10.5 MB