setup a remote Db within a LAN

Thanks for your help and hard work for MySQL.

Within a LAN, not via Internet, I am trying to let PC2 running on Win2K
to access the database on a MySQL running on PC1 running on WinXP SP2.

I can ping and see PC1 on PC2 in Windows Explorer's My Network Places.
But I still cannot connect to MySQL. The Test Connection always fail.

I notice the DSN setup using MyODBC does not need me to login to PC1.
The User and Password is the login for MySQL only, NOT the windows login for PC1.
Do I need to have the same windows user ID & password on both PC's to work?

Thanks much.

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: setup a remote Db within a LAN

Do you have the XP firewall running? If so, does it allow the MySQL port
(3306 by default usually) through?

If that is OK, has the security (GRANT) been set up in the MySQL server
to allow connections from PC2?

I don't think the Windows login matters for this purpose.

John B.

-----Original Message-----
From: Cleary W [mailto:cleary_w@yahoo.com]=20
Sent: Thursday, 1 September 2005 6:09 PM
To: myodbc@lists.mysql.com
Cc: cleary_w@yahoo.com
Subject: setup a remote Db within a LAN

Thanks for your help and hard work for MySQL.

Within a LAN, not via Internet, I am trying to let PC2 running on Win2K=20
to access the database on a MySQL running on PC1 running on WinXP SP2.

I can ping and see PC1 on PC2 in Windows Explorer's My Network Places.
But I still cannot connect to MySQL. The Test Connection always fail.

I notice the DSN setup using MyODBC does not need me to login to PC1.
The User and Password is the login for MySQL only, NOT the windows login
for PC1.
Do I need to have the same windows user ID & password on both PC's to
work?

Thanks much.

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around=20
http://mail.yahoo.com=20


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg