[thelist] connecting to MySQL on WinXP

[Jeremy Weiss]

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 !