im running a gaming server on winxp (32bit), and on it we have a stats program that uses perl, php and mysql so i have been using xampp because it was easy to install and had everything i needed to get it running.
everything has been working for months, but i saw there was a newer version of xampp, and thats where i got into trouble.
i uninstalled the old version (leaving only the sql data per the deinstall option), then installed the new version into the same directory. note i checked and the directory was empty except for the mysql data
the xampp status page show all is working well.
but the xampp security page shows the mysql server is not running or blocked by a firewall, but it is on the same machine (but i turned off the firewall just as a last resort, with no change).
mysql does work ok with the demo cd program, so it must be running...even thought it says not.
and when i now try to read/write any data to the sql database, i get an error.
"Could not connect to database server. Check that the values of DB_ADDR, DB_USER and DB_PASS in config.php are set correctly.
Server Error: (2013) Lost connection to MySQL server at 'reading initial communication packet', system error: 110"
ok, so since i didnt change the password/db addr or db user on any of the dozen or so instances that talk to the single sql database, it must be the sql database user name/password or something related. but i created it, and it seems correct, and matches up. i even removed the password from the sql database userid, just to try that, but the same error.
i know im likely doing something very basic wrong, but i cant figure out what it is.
any suggestions on what to do/how to troubleshoot this?
mark