Casbay Knowledge Base

Search our articles or browse by category below

HOW TO: Update phpMyAdmin

Last modified: January 18, 2021
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 config.inc.php 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';
  9. Open config.inc.php in a text editor.

  10. Find the following lines:

    /* User for advanced features */
    $cfg['Servers'][$i]['controluser'] = 'pma';
    $cfg['Servers'][$i]['controlpass'] = '';
  11. Next, change controlpass parameter to your new password.

  12. 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

  3. $ /usr/local/directadmin/custombuild

  4. Run the command below

  5. $ ./build phpmyadmin

  6. And you’re done!
We hope this article helped you to learn about how to update your phpMyAdmin. For more articles, kindly visit our Knowledge Base.
Was this article helpful?
Dislike 0
Previous: What is my website’s IP address?
Next: HOW TO: Create a cPanel account within WHM