Hi,
I'm using XAMPP version 1.7.7 on a Windows XP sp3 machine. A couple of weeks ago I was having problems just getting PHP to run (my localhost was trashed). Installing the latest version of xampp seems to have resolved that problem. But I'm currently having trouble with MySQL and Mercury. This post is only about the MySQL problem. I mention the others just in case it matters.
I start everything manually manually from the xampp control panel (after I stop IIS and it's attendant processes). Apache is running fine and it appears that MySQL is also running fine, on port 3306. But when i click the Admin button for MySQL on the xampp control panel i get the same two error messages I've seen in other posts.
"MySQL said: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) "
"Connection for controluser as defined in your configuration failed."
I have only one instance of MySQL (mysqld.exe) running.
In my.ini I have this: socket= "C:/xampp/mysql/mysql.sock". There is no msql.sock in c:/xampp/mysql.
phpinfo() shows that mysql.default_socket local and master values are set to "MySQL", as does mysqli.default_socket.
Every thing looks fine when I run a netstat, mysql is listening on port 3306, and everything also looks fine in XP's windows task manager.
Here's the stuff from config.inc.php
/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';
Any help would be greatly appreciated
Thanks,
David Morris