Your Gateway To Digital Success
Wesbytes Blue Logo

Wesbytes Knowledge Base

Search our articles or browse by category below

How to Update phpMyAdmin

Last modified: June 28, 2022
You are here:
Estimated reading time: 1 min

How to Update phpMyAdmin with XAMPP

In this guide we will show you how to download and install the latest version of phpMyAdmin under XAMPP to solve any compatibility issues with PHP 7.2 and phpMyAdmin 4.6 and above.

    1. First, stop MySql.
    2. Next, rename the current phpMyAdmin directory.
    3. Go to phpMyAdmin and download the latest version. If you’re using Windows platform, you can download the zip file.
    4. Next, extract the zip file and copy all directories to (xampp install path)/phpmyadmin
    5. Copy from your original phpmyadmin directory to the new directory.
    6. Start MySql.
    7. Then go to localhost/phpmyadmin
    8. You may get a warning regarding “Access denied for pma@localhost“. Go to SQL and run the following commands:
GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'whatever password you want to set';
    1. Open in a text editor.
    2. Find the following lines:
/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';
    1. Next, change controlpass parameter to your new password.
    2. Lastly, restart MySQL. This should solve the warning.

Update using DirectAdmin

If you are using a custom build for DirectAdmin, you may use the following steps to update phpMyAdmin to the latest one:
    1. SSH to the server
    2. Go to the directory
$ /usr/local/directadmin/custombuild
    1. Run the command below
$ ./build phpmyadmin
  1. And you’re done!
Was this article helpful?
Dislike 0
Views: 24