Is it running on Windows, James? You may have to allow connections
through to MySQL in Windows Firewall.
Otherwise it seems like maybe it's been started with --skip-networking ?
Dan
On 8/23/06, James Eaton <[EMAIL PROTECTED]> wrote:
----- Original Message -----
From: "Dan Buettner" <[EMAIL PROTECTED]>
>I believe MySQL listens on all IPs ... what if any error message are
> you getting?
From SQLyog I get:
Error No. 2003
Can't connect to MySQL server on '192.168.9.2' (10061)
> Can you access other services (SSH, telnet, FTP) over the same routes?
Yes.
> Can you telnet to MySQL over those routes? If so you may have an
> authentication problem, not a connection problem. Here's a sample of
> what a telnet session might look like:
>
> % telnet 127.0.0.1 3306
> Trying 127.0.0.1...
> Connected to localhost.
> Escape character is '^]'.
> A
> 5.0.21-standard-log&6{-kS?!,$2lMx:Ty%I!d
>
> (I then pressed return and the connection closed)
I can telnet to MySQL from the localhost, but not from any other location.
> On 8/23/06, James Eaton <[EMAIL PROTECTED]> wrote:
>> Is there a way to query a MySQL (5.0.xx) server to find out which IP
>> address(es) it's listening on? It should be listening on all, but I'm
>> unable to connect from remote machines, so need to troubleshoot a bit.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
