Sign In

Welcome! Log into your account

Forgot your password?

Create an account

Sign Up

Welcome! Register for an account

A password will be e-mailed to you.

Password Recovery

Recover your password

A password will be e-mailed to you.

Available for:

phpMyAdmin 5.2.0 Stable / 4.9.10

phpMyAdmin 5.2.0 Stable / 4.9.10
Download FreeDownload Buy Now

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) you acn perform via the user interface. But 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 the 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 developers. Mastering phpMyAdmin for Effective MySQL Management, which is available in English and Spanish.

phpMyAdmin is a mature project with a stable and flexible code base. It has won several awards. Translated into 72 languages and supports both LTR and RTL languages.

phpMyAdmin Features:

  • 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…

New Features in phpMyAdmin 5.2.0 (2022-05-11):

  • Removed support for Microsoft Internet Explorer
  • Requires PHP 7.2 or newer
  • Requires the openssl PHP extension
  • Improved handling of system CA bundle and cacert.pem, falling back to Mozilla CA if needed
  • Replace “master/slave” terms with “primary/replica”
  • Add “NOT LIKE %…%” operator to Table search
  • Add support for the Mroonga engine
  • Add support for account locking
  • Several fixes and improvements to the SQL parser library

Changes in phpMyAdmin 5.1.3 (2022-02-11):

  • Security hardening improvement.
  • Few other minor bug fixes and is recommended for all users.

Changes in phpMyAdmin 5.1.2 (2022-01-21):

  • Revert a changed to $cfg[‘CharTextareaRows’] allow values less than 7
  • Fix encoding of enum and set values on edit value
  • Fixed possible “Undefined index: clause_is_unique” error
  • Fixed some situations where a user is logged out when working with more than one server
  • Fixed a problem with assigning privileges to a user using the multiselect list when the database name has an underscore
  • Enable cookie parameter “SameSite” when the PHP version is 7.3 or newer
  • Correctly handle the removal of “innodb_file_format” in MariaDB and MySQL

Changes in phpMyAdmin 5.1.1 (2021-06-04):

  • Fixes for several PHP errors
  • Fixes for “$cfg[‘DefaultTabDatabase’]” and other related configuration directives not working properly
  • Fix Yaml export to quote strings even when they are numeric
  • Fix TCPDF open_basedir issue due to internal guessing code from TCPDF
  • Fix for quick search not working when using more than one configured server
  • Fix datetime decimals displayed (.00000) after edit
  • Fix new lines in text fields are doubled
  • Fixed URL generation by removing un-needed & escaping for & char
  • Improvements for working with PHP 8.1
  • Improved handling of adding a new user with the Percona database server

Changes in phpMyAdmin 5.1.0 (2021-02-24):

  • 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

Changes in phpMyAdmin 5.0.4 (2020-10-15):

  • Two factor authentication was broken
  • Incompatibilities with older PHP versions.

Changes in phpMyAdmin 5.0.3 (2020-10-10):

Several important security fixes:

  • PMASA-2020-5 XSS vulnerability with transformation feature
  • PMASA-2020-6 SQL injection vulnerability with the search feature

In addition, 5.0.3 contains many bugfixes. Some of the highlights include:

  • Fix an error message about htmlspecialchars() when attempting to export XML
  • Support double tapping to edit on mobile
  • Fix the error message “Use of undefined constant MYSQLI_TYPE_JSON” when using mysqlnd
  • Fix fatal JS error on index creation after using Enter key to submit the form
  • Fix “axis-order” to swap latitude and longitude on MySQL 8.1 or newer
  • Fix an error when overwriting an existing query bookmark
  • Fix some warnings that appear with PHP 8
  • Fix alter user privileges query when editing an account with MySQL 8.0.11 and newer
  • Fix issues regarding TIMESTAMP columns with default CURRENT_TIMESTAMP in MySQL 8.0.13 and newer
  • Fix a message that “Warning: error_reporting() has been disabled for security reasons” on php 7.x

Changes in phpMyAdmin 5.0.2 (2020-03-21):

  • PMASA-2020-2 SQL injection vulnerability in the user accounts page, particularly when changing a password
  • PMASA-2020-3 SQL injection vulnerability relating to the search feature
  • PMASA-2020-4 SQL injection and XSS having to do with displaying results
  • Removing of the “options” field for the external transformation.
  • Fix for copying a user account
  • Removed SET AUTOCOMMIT=0 from SQL export
  • Fix for the display of table borders
  • Fix for ENUM radio button user interface problems
  • Improved the prompt for abandoning changes when no changes were made in the SQL window
  • Fix for inserting a primary key with “insert as new row”
  • Fix incorrect suggested latest available version to version 5