How to upgrade PHPMyAdmin

How to upgrade PHPMyAdmin under XAMPP:

  • Stop MySql
  • Rename the current phpmyadmin directory.
  • Go to https://www.phpmyadmin.net/downloads/ to download the latest version.  I downloaded the zip file since I’m using Windows platform.
  • Extract zip file, copy all directories to (xampp install path)/phpmyadmin
  • Copy config.inc.php from your original phpmyadmin directory to the new directory.
  • Start MySql.
  • Go to localhost/phpmyadmin
  • You may get a warning regarding “Access denied for pma@localhost“.  Go to SQL, run the following commands:
    GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'whatever password you want to set';
  • Open config.inc.php in a text editor
  • Find the following lines:
    /* User for advanced features */
    $cfg['Servers'][$i]['controluser'] = 'pma';
    $cfg['Servers'][$i]['controlpass'] = '';
  • change controlpass parameter to your new password.
  • Restart MySQL. This should clear up the warning.