Apache Friends Support Forum

Hi,

I upgraded to the latest XAMPP package and I was using MySQL Query Browser before. Now the MySQL Query Browser cannot connect the MySQL db thats upgraded. Does anyone else have this problem?

What are the common fixes or adjustments done?

Thanks in advance.

The error is:

Could not connect to specified instance.

MySQL Error Number 2003
can't connect to MySQL server on 'localhost' (10061)

can't connect to MySQL server on 'localhost' (10061)

Start the MySQL server.

Its started already as a service

Its started already as a service

You can see MySQL in taskmanager?

I just upgraded to version 1.7.4 and having the same problem reported here. Mysql is running as service and it's fine, 'cause I can access it through windows prompt and phpmyadmin without any issue.

MySQL Query Browser has reached the end of the line (EOL) and so would not now be compatible with this latest MySQL version in XAMPP 1.7.4.
http://dev.mysql.com/doc/query-browser/en/

December 18, 2009 EOL Notice here:
http://dev.mysql.com/support/eol-notice.html

SOLUTION
Please upgrade to MySQL Workbench.

I've the latest Workbench(5.2.32 CE) installed and I've been same issues. When I'm testing some connection I receive this... "Can't connect to Mysql server on '127.0.0.1'(10061). Since I was using xampp 1.7.3 there was not this issue with Mysql Query Browser or Workbench.
I'ts totally freakin', since I can use phpmyadmin to create bd and tables and cannot use workbench or mysql query browser to do same thing, I'd checkout xampp security settings and there was the following... "A MySQL server is not running or is blocked by a firewall! status: UNKNOWN. My firewall is not blockin' it.

I returned to previus xampp(1.7.3) and everything goes fine. Both workbench as mysql query browser worked well. Definitely there is a problem with this new version of xampp.