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.