Luckly, you're absolutely wrong!
What you might have experienced is a permision problem. In mysql you can limit users from certain IP/hostsnames. This is done via the user table in the mysql dbase.
You'll find a series of rows like these
host user password %other columns%
localhost root %hahaha% %other data%
just set something like
192.168.0.12 %your user name% %your password%
where 192.168.0.12 is the fix IP of the windows client
or if you have DHCP and a DNS or using the hosts file
%yourWINSLOTHmachine% %your user name...etc.
You have to set the ODBC client with the IP/host of the mysql server and a valid username and password. For valid username and password you must understand one such pair that holds an entry in the user table with the same IP/hostname as the machine the user will be on.
OH, and remember to restart mysql after editing the user table!!!
as root
/etc/init.d/mysql stop
/etc/init.d/mysql start
or in some systems
service mysql stop
service mysql start
I have done this succesfully with a linux/mysql and an win98/access97 box pair. Its pretty nice to se a copy paste from one dbase (true access) to the other (access with linked tables via odbc to mysql). Saved me a whole lot of time to insert info from some old access apps we are moving to php/mysql.
Saludos
Gerardo
