Is it the case that not only phpMyAdmin can't talk to MySQL, but also any data driven websites you have are also impaired???

it looks like the Windows user that Apache and MySQL are running under don't have the correct rights in the MySQL data folders.(my interpretation of the errors amounts to 'can't write to my files' (or read perhaps -- I don't fully grok the initialization protocol for MySQL)

i.e probably a problem with the NTFS rights. Perhaps inheritance has been inhibited???

This problem happened at the beginning of the week. I am assuming after some windows 7 updates. I came to log into xampp and found i was directed to the IIS7 screen. After a lot of troubleshooting, I found from these forums that it was IIS7 using the ports 80, 443 etc. So, after disabling them. I was still getting the MySQL Error in PHPMyAdmin.

I have managed to fix the problem i was having. After main attempts at altering files, test firewall etc etc. I reverted back to 1.7.1 version of XAMPP. This seemed to fix the problem of not ben able to login to phpMyAdmin. After replacing all my backups of websites + databases, everything was back to normal.

I have had the same problem as the OP - error 2002 after clicking phpMyAdmin link on Xampp's welcome page (http://localhost/xampp/).

However I only get error 2002 when the PC is disconnected from the network via network connections in control panel (start/control panel/network connections/connection-name/right-click/disable). With the connection enabled phpMyAdmin works just fine.

The problem was resolved as soon as I put a "bind-address=127.0.0.1" configuration parameter in the [mysqld] section of the "my.ini" configuration file (<xampp-install-folder>\mysql\bin\my.ini) and restarted MySQL on the Xampp control panel. Now phpMyAdmin works whether the PC is connected to its local network or not.

ensure MySQL and Apache are started via the Xampp control panel in your browser open the url "http://localhost/xampp/mysqldbg.php"

You'll get a page with just "OK" on it if there's a connection to MySQL You'll get the full error message and "NOK" if no connection can be made.

(The "@" suppresses warnings and errors on the PHP function call, removing the "@" lets you see them if they occur)

I was getting:

"Warning: mysql_connect() [function.mysql-connect]: [2002] No connection could be made because the target machine actively (trying to connect via tcp://localhost:3306) in <xampp-install-folder>\htdocs\xampp\mysqldbg.php on line 2

Warning: mysql_connect() [function.mysql-connect]: No connection could be made because the target machine actively refused it. in <xampp-install-folder>\htdocs\xampp\mysqldbg.php on line 2 NOK"

I don't think that mysql_upgrade.bat is a possible solution for MySQL Error #2002 issues.I can't find any ressource on the internet which is saying that it would help in some way.Can you please explain why you think it would solve that issue

best wishes,Altrea

We don't provide any support via personal channels like PM, email, Skype, TeamViewer!