Can't connect to MySQL Host (CoLinux)

[wscrivens]

My setup is as follows:

MySQL is installed on Gentoo Linux running under CoLinux on an XP box.

On the Linux side I can use the built-in mysql application to connect to the database and do simple queries, but since this is text only it is very cumbersome to deal with long records or many records.

I have a game server application that runs on the Linux box and uses MySQL for its data; I can access this server from the Windows side just fine. I also have Apache on the Linux box and can access it from Windows. From that I assume the networking piece is set up OK.

When I try to connect with SQLyog, I enter the IP address of the Linux box, and the username, password and database name of the game server's database – and the game serrver is not running, so no conflict there – but I get error 2003, “Can't connect to MySQL server on '192.168.0.40'(10061).

I'm a Linux N00B, but no stranger to Windows, networking or Micro$oft databases, but I can't figure where to go from here.

Any help would be welcome!

Walt

[peterlaursen]

just one more question: the port number is standard 3306 ?

For a test you could try to use HTTP-tunnelling (uses HTTP-port 80)

And rememer that under Linux the letter case is sognifikant not only in password but everywhere.

[Ritesh]

The error usually occurs when MySQL is not running or you try to connect to the wrong port.

Quote:

I can access this server from the Windows side just fine

Do you mean you can access the MySQL server? If you can then provide the exact same details in SQLyog also.

[peterlaursen]

to clarify my point:

With this special setup of two OS's running simutaneously on the same machine, I don't know if the normal MySQL port 3306 is accessible for Linux or if it can be accessed “from outside”. But since you can connect til your Apache server running on Linux port 80 is accessible!!!

Therefore HTTP-tunnelling should work, if direct connection is not possible!

But of course I don't know this special configuration. Do the 2 OS's share an ip or not for instance …

[Author]

Posts