[thelist] connecting to MySQL on WinXP
Jeremy Weiss
eccentric.one at gmail.com
Sun Jun 25 08:42:55 CDT 2006
It was option three. XP's firewall was blocking port 3306. I had listed
MySQL in the exceptions list thinking that would allow incoming traffic, but
it didn't. Had to go back and specifically list the port.
Thanks,
-jeremy
> -----Original Message-----
> From: thelist-bounces at lists.evolt.org
> [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Hershel Robinson
> Sent: Sunday, June 25, 2006 4:15 AM
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] connecting to MySQL on WinXP
>
> Jeremy Weiss wrote:
> > I've just set up my first MySQL server for a desktop
> application at work.
> > I've got it up and the desktop app works fine from the
> computer MySQL is on.
> > However, I can't for the life of me get a DSN connection (ODBC) to
> > work from the other computers on the LAN.
> >
> > I've tried using all the following as the Server in the ODBC box.
> >
> > 192.168.1.136
> > 192.168.1.136\mysql
> > \\D7s54y91
> > \\D7s54y91\mysql
> >
> > And the error I get everytime is "Unknown MySQL server host"
>
> 1 What app are you using?
>
> 2 What dsn works on the server machine?
>
> 3 Are you certain that the server allows outside connections
> to the MySQL server? 3306 is the default port for MySQL
> (AFAIK). Perhaps there's a firewall there?
>
> Hershel
>
> --
> Gallery Robinson Web Services
> http://galleryrobinson.com/
> --
>
> * * Please support the community that supports you. * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip
> Harvester and archives of thelist go to:
> http://lists.evolt.org Workers of the Web, evolt !
More information about the thelist
mailing list