Yes, it's running on Windows XP, but the Windows Firewall has been
disabled.
Just figured it out... This was a version of MySQL bundled with an
application. I wrongly assumed that shutting down the application also
shut down the included MySQL server. The original my.cnf had a
bind-address of 127.0.0.1, which I'd removed, but since the MySQL server
wasn't actually being restarted, the new configuration was never picked
up.
----- Original Message -----
From: "Dan Buettner" <[EMAIL PROTECTED]>
To: "James Eaton" <[EMAIL PROTECTED]>
Cc: <mysql@lists.mysql.com>
Sent: Wednesday, August 23, 2006 3:07 PM
Subject: Re: Re: How to query bind address?
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]
