[thelist] connecting to MySQL on WinXP

Hershel Robinson hershel at galleryrobinson.com
Sun Jun 25 04:15:29 CDT 2006


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/



More information about the thelist mailing list