Cannot Connect To Mysql 5 On Windows 64 Bit

[puneet]

Hi,

I am using :

> MySQL version 5.0.16 in Windows XP x64 version

> SQLYog version 5.01

I can connect to MySQL from console. but I cannot connect to it using SQLYog.

I keep getting error 10061

Is there any known problem related to SQLYog and 64-bit windows?

Note: I have used the same set of softwares in 32 bit version, and they work fine without any problems.

thanks

Puneet

[peterlaursen]

Is it a correct error number that you are writing?

Isn't there a (text)-message too.

That would make things easier if you wrote that!

It looks like it should be a 4 digit MySQL server error.

Am I right ?

Read also:

http://www.webyog.com/faq/5_8_en.html

http://dev.mysql.com/doc/refman/5.0/en/err…ges-server.html

If there was any issue with SQLyog on 64 bit platforms, I can't believe it would be a connection issue.

Please detail!

Also: SQLyog and server is running on the same computer ?

[peterlaursen]

Can you see if it is a

* MySQL error

* SQLyog error

* a Windows error

Please paste in the error screen!

[peterlaursen]

Some research:

http://www.google.com/search?q=error+10061…a&start=10&sa=N

Looks like this error is a TCP-error !!

I can get something similar (see attached) if I specify the wrong port.

And if the MySQL server is not running.

It is TCP-connection that can't be established.

I believe this is not an SQLyog issue.

You can try to test with another client such as 'MySQL Administrator'.

[puneet]

Sorry for not having described the problem correctly.

Its SQL Yog message

I am attaching the screenshot fo the message.

[puneet]

Thanks peter, you could be right.

It is a new machine that I have built just now.

I have not set the LAN card in it yet … will check that and come back.

I will also try connecting from some code.

[peterlaursen]

Yes …

and you are perfectly sure that you specify the correct port?

also try disabling firewall. some firewalls block connection with TCP even to 'localhost'

If you are good at Belgian-Flemish then there is something here:

http://forum.kuleuven.ac.be/read.php?f=31&i=884&t=884

(no solution, but same problem)

This error 2003 is an error that is generated by the mysql client code (the C-API) that is compiled into sqlyog. MySQL and not Webyog is responsible for that code – just for clarity! But this is no help either, I know!

hmmm …

* check port is correct

* disable firewall and any similar sort of network security. Is there a built-in firewall in WinXP-64 like in XP ?

* try another client using same client code (Administrator, Query Browser)

[peterlaursen]

Yes .. of course that too.

If network protocol never was installed you can't connect with TCP as SQLyog does!

[puneet]

The problem is resolved.

I am not sure which step resolved it.

After trying to connect from code . ..i was getting an error about problem with the socket.

I played around with TCP-IP, network card config, reinstalled MySQL-5 . ..and one of these seems to have resolved it.

It certainly was not SQLYog problem … coz I didn't touch SQL Yog installation at all.

thanks a lot for the help !

Puneet

[Author]

Posts