How to Update phpMyAdmin to Version 5.2.3 in XAMPP on Windows (Step-by-Step)

What you'll need	Details
XAMPP for Windows already installed	Any version with an older phpMyAdmin bundled
Admin access to your Windows machine	Needed to rename/copy folders in C:\xampp
phpMyAdmin 5.2.3 ZIP package	Downloaded from the official phpMyAdmin website
A code editor	To edit config.inc.php and php.ini
Estimated time	[10 mins]

🖼️ [ẢNH CẦN CHỤP] Hero image — overview shot of the phpMyAdmin 5.2.3 home screen loaded successfully inside XAMPP on Windows.

phpMyAdmin is the web-based database management tool included with XAMPP. It lets you manage MySQL or MariaDB databases directly from your browser. If your XAMPP installation includes an older phpMyAdmin version, you can manually update it to phpMyAdmin 5.2.3 on Windows without reinstalling the entire XAMPP package.

Why Update phpMyAdmin in XAMPP?

XAMPP is convenient because it bundles Apache, PHP, MariaDB, and phpMyAdmin in one package. However, the bundled phpMyAdmin version may not always be the latest available release.

Updating phpMyAdmin can help you get bug fixes, better compatibility, and a more reliable database management experience. phpMyAdmin 5.2.3 is a bugfix release, so it is a good target version if you want to keep your local development environment more up to date.

This guide focuses on updating phpMyAdmin inside XAMPP on Windows while keeping your existing databases, Apache, PHP, and MariaDB setup unchanged.

Before You Start

Back up this folder:

C:\xampp\phpMyAdmin

You should also make sure your databases are backed up, especially if you plan to test import, export, or user management features after the update.

To export a database, open:

http://localhost/phpmyadmin

Select your database, click Export, choose SQL format, and download the backup file.

Step 1: Check Your Current phpMyAdmin Version

First, check which phpMyAdmin version your XAMPP installation is currently using.

Start Apache and MySQL from the XAMPP Control Panel, then open:

http://localhost/phpmyadmin

On the phpMyAdmin dashboard, look for the version information. You may see it on the right side of the home page or near the footer, depending on your theme and layout.

🖼️ [ẢNH CẦN CHỤP] Screenshot of the phpMyAdmin home page with the current version number visible, circled in red — shows exactly where the version text appears.

If your version is older than 5.2.3, you can continue with the update.

Step 2: Stop Apache in XAMPP

Open the XAMPP Control Panel and stop Apache before replacing the phpMyAdmin folder.

phpMyAdmin runs through Apache and PHP, so stopping Apache prevents file lock issues while you copy or rename folders.

You do not always need to stop MySQL or MariaDB for this update, but stopping it is fine if you want to avoid active database sessions during the process.

🖼️ [ẢNH CẦN CHỤP] XAMPP Control Panel with the Apache "Stop" button highlighted, showing the module status turning from green to stopped.

Step 3: Rename the Old phpMyAdmin Folder

Go to your XAMPP installation directory:

C:\xampp

Find the existing phpMyAdmin folder:

C:\xampp\phpMyAdmin

Rename it to:

C:\xampp\phpMyAdmin-old

This gives you a quick rollback option if the new phpMyAdmin version does not work correctly.

🖼️ [ẢNH CẦN CHỤP] Windows File Explorer at C:\xampp, right-click context menu open on the phpMyAdmin folder showing the "Rename" option.

Step 4: Download phpMyAdmin 5.2.3

Download phpMyAdmin 5.2.3 from the official phpMyAdmin website. The official phpMyAdmin release page lists version 5.2.3 as a bugfix release, and the phpMyAdmin downloads page provides the current downloadable packages.

For XAMPP on Windows, download the ZIP package:

phpMyAdmin-5.2.3-all-languages.zip

After downloading, extract the ZIP file to a temporary location, for example:

C:\Users\YourName\Downloads\phpMyAdmin-5.2.3

🖼️ [ẢNH CẦN CHỤP] Official phpMyAdmin downloads page with the phpMyAdmin-5.2.3-all-languages.zip package highlighted.

Step 5: Copy phpMyAdmin 5.2.3 into XAMPP

Copy the extracted phpMyAdmin folder into your XAMPP directory:

C:\xampp

Rename the copied folder to:

phpMyAdmin

Your new phpMyAdmin path should now be:

C:\xampp\phpMyAdmin

Make sure the folder contains files such as:

index.php
libraries
templates
themes
vendor

🖼️ [ẢNH CẦN CHỤP] File Explorer showing the new C:\xampp\phpMyAdmin folder contents, confirming index.php, libraries, templates, themes, and vendor are present.

Step 6: Restore the XAMPP phpMyAdmin Configuration

Your old phpMyAdmin folder contains an important configuration file:

C:\xampp\phpMyAdmin-old\config.inc.php

Copy this file into the new phpMyAdmin folder:

C:\xampp\phpMyAdmin\config.inc.php

This file contains settings for authentication, host, port, blowfish secret, and database connection behavior.

After copying it, open the file in a code editor and check these common settings:

$cfg['blowfish_secret'] = 'your-secret-key-here';

$i++;
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

If your local database root user has a password, update the password value accordingly.

If you use a custom database port, add or update the port setting:

$cfg['Servers'][$i]['port'] = '3307';

Use your actual MariaDB or MySQL port number.

🖼️ [ẢNH CẦN CHỤP] Code editor with config.inc.php open, the blowfish_secret and auth_type lines circled in red to show exactly which fields to check.

Step 7: Check PHP Extension Requirements

phpMyAdmin requires PHP and several common PHP extensions. XAMPP usually includes these by default, but after updating PHP or phpMyAdmin, it is a good idea to check your configuration.

Open your PHP configuration file:

C:\xampp\php\php.ini

Make sure these extensions are enabled:

extension=mysqli
extension=mbstring
extension=openssl
extension=zip
extension=curl
extension=fileinfo
extension=gd

If any line starts with a semicolon, remove the semicolon to enable the extension:

;extension=mysqli

should become:

extension=mysqli

🖼️ [ẢNH CẦN CHỤP] php.ini open in a code editor, showing the extension= lines with the semicolon removed in front of extension=mysqli, arrow pointing at the change.

Step 8: Start Apache and Open phpMyAdmin

Open the XAMPP Control Panel and start Apache again. Also start MySQL if it is not already running.

Then open phpMyAdmin in your browser:

http://localhost/phpmyadmin

If everything is configured correctly, phpMyAdmin should load normally.

Check the version number on the phpMyAdmin home page. It should show:

phpMyAdmin 5.2.3

🖼️ [ẢNH CẦN CHỤP] phpMyAdmin home page after restart, version number "phpMyAdmin 5.2.3" visible and circled in red to confirm the update succeeded.

Step 9: Test Database Access

After updating phpMyAdmin, test the main features you normally use.

Try the following:

• Open an existing database.
• Browse a table.
• Run a simple SQL query.
• Export a database.
• Import a small SQL file.
• Create and drop a test table.

You can run this simple SQL query to confirm the database connection:

SELECT VERSION();

This will show the current MySQL or MariaDB server version used by XAMPP.

Common Mistakes to Avoid

Common Problems After Updating phpMyAdmin

phpMyAdmin Shows a Blank Page

A blank page usually means there is a PHP error. Check the Apache error log:

C:\xampp\apache\logs\error.log

Also check that your PHP version is compatible and that required extensions are enabled in php.ini.

Cannot Connect: Invalid Settings

If phpMyAdmin shows a connection error, open:

C:\xampp\phpMyAdmin\config.inc.php

Check these settings:

$cfg['Servers'][$i]['host']
$cfg['Servers'][$i]['port']
$cfg['Servers'][$i]['user']
$cfg['Servers'][$i]['password']
$cfg['Servers'][$i]['auth_type']

Make sure they match your XAMPP MariaDB or MySQL setup.

Access Denied for User Root

If you see an access denied error, your root password may be different from the value in config.inc.php.

For many default XAMPP installations, the local database login is:

Username: root
Password: empty

But if you previously set a root password, update the configuration file with the correct value.

The mysqli Extension Is Missing

If phpMyAdmin says the mysqli extension is missing, open:

C:\xampp\php\php.ini

Enable:

extension=mysqli

Then restart Apache.

The Blowfish Secret Is Too Short

If phpMyAdmin warns about the blowfish secret, open:

C:\xampp\phpMyAdmin\config.inc.php

Set a longer random string:

$cfg['blowfish_secret'] = 'a-long-random-secret-key-for-local-xampp';

This value is used for cookie authentication encryption. Even for local development, it should not be empty.

Rollback Plan

If phpMyAdmin 5.2.3 does not work correctly, you can restore your old version.

First, stop Apache from the XAMPP Control Panel.

Rename the new folder:

C:\xampp\phpMyAdmin

to:

C:\xampp\phpMyAdmin-new

Then rename your old backup folder:

C:\xampp\phpMyAdmin-old

back to:

C:\xampp\phpMyAdmin

Start Apache again and open:

http://localhost/phpmyadmin

Your previous phpMyAdmin version should be restored.

Should You Update phpMyAdmin in XAMPP?

Updating phpMyAdmin is usually a good idea if you want a more current local development tool. Unlike database server upgrades, this update does not directly change your database engine or data files.

Update if...	Wait if...
Your current phpMyAdmin version is outdated	Your current XAMPP setup is working perfectly
You recently upgraded PHP in XAMPP	You don't have a backup of your old phpMyAdmin folder
You recently upgraded MariaDB or MySQL in XAMPP	You use custom phpMyAdmin themes or plugins
You want the bug fixes from phpMyAdmin 5.2.3	You are not sure which PHP version your XAMPP installation uses
You want better compatibility with your current local stack	—

❓ FAQ

Does updating phpMyAdmin delete my databases?

No. Updating phpMyAdmin only replaces the phpMyAdmin application files inside C:\xampp\phpMyAdmin. Your MariaDB/MySQL data files, Apache, and PHP setup are untouched — always back up databases separately as a precaution.

Do I need to reinstall XAMPP to get phpMyAdmin 5.2.3?

No. You can manually swap the phpMyAdmin folder without reinstalling XAMPP, as long as you back up the old folder and restore config.inc.php into the new one afterward.

Why does phpMyAdmin show a blank page after the update?

A blank page usually points to a PHP error. Check C:\xampp\apache\logs\error.log and confirm your PHP version and required extensions in php.ini are compatible with phpMyAdmin 5.2.3.

What do I do if phpMyAdmin 5.2.3 doesn't work after updating?

Stop Apache, rename the new phpMyAdmin folder to phpMyAdmin-new, then rename your phpMyAdmin-old backup back to phpMyAdmin. Restart Apache to restore your previous working version.

Why do I get an "Access denied for user root" error?

This usually means the root password in config.inc.php doesn't match your actual database password. Default XAMPP installs use an empty root password, but if you set one previously, update the config file to match.