We use XAMPP on a few machines to quickly test some PHP scripts. Upon upgrading to the latest version of XAMPP, everything slowed to a halt. It turns out that the database connection was slowing down the scripts in phpMyAdmin, and our custom scripts. We just added a line to our phpMyAdmin config.inc.php, and adjusted the database connection strings in our custom scripts to fix things.
The line in config.inc.php:
$cfg[‘Servers’][$i][‘host’] = ‘127.0.0.1’;
Our custom scripts were fixed by using 127.0.0.1 instead of localhost.
(On a side note, we had already changed our hosts file & ruled that out as a problem prior to changing these values.)
Great thanks to EllisLab for the phpMyAdmin tip.