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.
- First, stop MySql.
- Next, rename the current phpMyAdmin directory.
- Go to phpMyAdmin and download the latest version. If you’re using Windows platform, you can download the zip file.
- Next, extract the zip file and copy all directories to (xampp install path)/phpmyadmin
- Copy config.inc.php from your original phpmyadmin directory to the new directory.
- Start MySql.
- Then go to localhost/phpmyadmin
- 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'; |
- 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'] = '';
- Next, change controlpass parameter to your new password.
- 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:
-
- SSH to the server
- Go to the directory
$ /usr/local/directadmin/custombuild
-
- Run the command below
$ ./build phpmyadmin
- And you’re done!
