What's New and Changed in phpMyAdmin 5.2

Published On16 May 2022

What's new and changed in phpMyAdmin 5.2

phpMyAdmin is a popular software tool written in PHP to manage MySQL and MariaDB databases over a web interface. First started in 1998, the phpMyAdmin project is widely used today in PHP hosting environments as a convenient way to manage databases, tables, users, export/import data, and perform various other tasks.

phpMyAdmin is compatible across several MySQL/MariaDB versions, and historically, has always been compatible across multiple platforms and PHP versions. phpMyAdmin version 5.2 is now released with several improvements and updates to underlying runtime requirements and dependencies. This follows phpMyAdmin 5.1 release, which bumped the minimum PHP version it requires to PHP 7.1, and the minimum support MySQL/MariaDB versions to 5.5.

phpMyAdmin 5.2 also introduces mutation testing to its own code base with Infection mutation testing framework.

Updated PHP Requirements

One of the most prominent changes in phpMyAdmin 5.2 is that it now requires PHP 7.2.6 or later, and the OpenSSL extension to run.

The PHP development team ended active support for PHP 7.2 back November 2019, and ended security fixes in November 2020. phpMyAdmin's PHP 7.2 requirement provides an easier upgrade path, but it is highly recommended to use a current PHP version if possible.

If phpMyAdmin 5.2 is attempted to run on an older PHP version, it immediately quits with an error message displayed on the screen:

PHP 7.2.5+ is required.
Currently installed version is: 7.1.4

Prior to phpMyAdmin 5.2, phpMyAdmin tried to work around if the OpenSSL extension is not available in the PHP runtime. Since phpMyAdmin 5.2, OpenSSL extension is a hard requirement.

Further, phpMyAdmin 5.2 removes support for file upload progress feature provided by the APC extension. APC extension is no longer maintained, as its PHP Caching functionality is implemented in PHP core's OpCache extension, and user-cache feature is moved to the new APCu extension.

PHP Dependency Updates

phpMyAdmin 5.2 also makes several drastic changes in its underlying dependencies.

  • Starts using composer/ca-bundle to resolve the root Certificate Authority (CA) file. This is where the OpenSSL extension requirement comes in.
  • phpseclib is no longer required.
  • paragonie/sodium_compat](https://github.com/paragonie/sodium_compat) library is required. This was previously only a suggested library from the composer.json file.
  • Symfony components are updated to 5.2 from Symfony 4.4 series in phpMyAdmin 5.1.
  • Added support for PSR-7 HTTP Message Interface and PSR-17 HTTP Factories.

Front-end Dependency Updates

There are several front-end dependency improvements in phpMyAdmin 5.2 as well:

  • Drops support for Internet Explorer
  • Updates to Bootstrap version 5.
  • stickyfill library is no longer used.

New in phpMyAdmin 5.2

Bootstrap theme

phpMyAdmin 5.2 is shipped with a branch new theme "bootstrap", using Bootstrap 5 class names in the templates.

phpMyAdmin 5.2 - Boostrap theme
A screenshot of phpMyAdmin 5.2 Bootstrap theme

Import and Export Screen Redesign

Database/table import and export pages in phpMyAdmin 5.2 is redesigned to make them look more organized and modern:

Database import screen
Redesigned database import page

Database import screen
Redesigned database export page

DELETE FROM feature in table operations page

The "Operations" tab of each database now supports a new feature to empty a table using a DELETE FROM query with a single click. phpMyAdmin already supports executing TRUNCATE and DROP queries.

In MySQL, one of the major differences between a DELETE query and a TRUNCATE query is that DELETE only locks individual rows, as opposed to locking an entire table as is the case for TRUNCATE queries.

New "DELETE FROM" option in database operations
New 'DELETE FROM' option in database operations

User Account Locking Support

MySQL and MariaDB support user account locking, but phpMyAdmin did not expose any user interface to toggle the account lock status until phpMyAdmin 5.2.

Since phpMyAdmin 5.2, it is possible to quickly lock and unlock user accounts.

User account lock/unlock toggle in phpMyAdmin 5.2
User account lock/unlock toggle in phpMyAdmin 5.2

A locked user account cannot be used to access the database until it is unlocked with a privileged user.

Use phpMyAdmin 5.2

phpMyAdmin 5.2 is already available to download at phpmyadmin.net/downloads.

Alternately, Docker Hub also contains phpMyAdmin 5.2 images.

Recent Articles on PHP.Watch

All ArticlesFeed 
How to fix `mysql_native_password` not loaded errors on MySQL 8.4

How to fix mysql_native_password not loaded errors on MySQL 8.4

How to fix the SQLSTATE[HY000] [1524] Plugin 'mysql_native_password' is not loaded errors caused in MySQL 8.4 no longer enabling the mysql_native_password plugin by default.
How to fix PHP Curl HTTPS Certificate Authority issues on Windows

How to fix PHP Curl HTTPS Certificate Authority issues on Windows

On Windows, HTTPS requests made with the Curl extension can fail because Curl has no root certificate list to validate the server certificates. This article discusses the secure and effective solutions, and highlights bad advice that can leave PHP applications insecure.
AEGIS Encryption with PHP Sodium Extension

AEGIS Encryption with PHP Sodium Extension

The Sodium extension in PHP 8.4 now supports AEGIS-128L and AEGIS256 Authenticated Encryption ciphers. They are significantly faster than AES-GCM and CHACHA20-POLY1305. This article benchmarks them and explains how to securely encrypt and decrypt data using AEGIS-128L and AEGIS256 on PHP.
Subscribe to PHP.Watch newsletter for monthly updates

You will receive an email on last Wednesday of every month and on major PHP releases with new articles related to PHP, upcoming changes, new features and what's changing in the language. No marketing emails, no selling of your contacts, no click-tracking, and one-click instant unsubscribe from any email you receive.