View Full Version : xampp upgrade causing error 2002 on 1 table only!

06-09-2011, 04:10 PM
I have been using xampp for years for development purposes, with no problems.

I upgraded to XAMPP 1.7.4 recently, as I needed php 5.3.x, and everything works fine except that on one table, in one database I am getting the error:

"#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)"

The table was fin previously and I can access it from MySQL workstation OK.

Any ideas?

06-09-2011, 04:36 PM
The mysql socket file is missing from the /tmp directory?

If it is:

Edit the PhpMyAdmin configuration file to use the original MySQL socket file.

vi /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php

Make sure, the correct mysql socket file is mentioned there.
$cfg['Servers'][$i]['socket'] = ‘/var/lib/mysql/mysql.sock’;
$cfg['Servers'][$i]['connect_type'] = ‘socket’;

06-09-2011, 05:50 PM
Thanks for that, however, I should have mentioned I am using xampp for windows.

06-09-2011, 06:01 PM
Actually, bizarrely, It has started working now, without having done anything.

The table had only about 2MB of data, but about half of that is indexes. Do you think it could have been indexing the table? Is that unlikely?

Thanks for your help anyway!