phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin 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 comes with a wide range of documentation and users are welcome to update our wiki pages to share ideas and howtos for various operations. The phpMyAdmin team will try to help you if you face any problem; you can use a variety of support channels to get help.
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.
To ease usage to a wide range of people, phpMyAdmin is being translated into 72 languages and supports both LTR and RTL languages.
phpMyAdmin is a mature project with a stable and flexible code base; you can find out more about the project and its history and the awards it earned. When the project turned 15, we published a celebration page.
The phpMyAdmin project is a member of Software Freedom Conservancy. SFC is a not-for-profit organization that helps promote, improve, develop, and defend Free, Libre, and Open Source Software (FLOSS) projects.
- 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 users 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 PDF graphics of your 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
- And much more…
- Improve virtuality dropdown for MariaDB > 10.1
- Added an option to perform ALTER ONLINE (ALGORITHM=INPLACE) when editing a table structure
- Added ip2long transformation
- Improvements to linking to MySQL and MariaDB documentation
- Add “Preview SQL” option on Index dialog box when creating a new table
- Add a new vendor constant “CACHE_DIR” that defaults to “libraries/cache/” and store routing cache into this folder
- Add $cfg[‘CaptchaSiteVerifyURL’] for Google ReCaptcha siteVerifyUrl
- Add the password_hash PHP function as an option when inserting data
- Improvements to editing and displaying columns of the JSON data type.
- Added support for “SameSite=Strict” on cookies using configuration “$cfg[‘CookieSameSite’]”
- Fixed AWS RDS IAM authentication doesn’t work because pma_password is truncated
- Add config parameters to support third-party ReCaptcha v2 compatible APIs like hCaptcha
- Add $cfg[‘MysqlSslWarningSafeHosts’] to set the red text black when ssl is not used on a private network
- Export blobs as hex on JSON export
- Fix leading space not shown in a CHAR column when browsing a table
- Added a rename Button to use RENAME INDEX syntax of MySQL 5.7 (and MariaDB >= 10.5.2)
- Fixed missing option to enter TABLE specific permissions when the database name contains an “_” (underscore)
- Fixed a PHP notice “Trying to access array offset on value of type null” on Designer PDF export
- Fix for several PHP 8 warnings or errors, giving this release full compatibility with PHP 8