ODBC in windows network

[madvalpreston]

Hi

We have set our Mysql server on a windows 7 machine and it works fine, we use access for front end. the aim is to link the Mysql tables and then use the rest of access forms etc... locally, which is a standard split databse set up.

we now want to link to it using ODBC on other machines on the network. I know we have to load the Mysql ODBC drivers on the machines that will link in. but I am not sure how to set it up so it can see the machine withe hte mysql server on it for the ODBC settings. I have looked at this link from the help in the ODBC

http://dev.mysql.com/doc/refman/5.1/en/connector-odbc-configuration-dsn-windows.html

But here it does not mention linking to another machine OR does the network recognise it as localhost.

I am trying this on Monday so just trying to prepare myself for any problems...

Any advice please would be welcome..

Thanks

 

[DonQuichote]

Localhost is always the local machine. In MySQL, localhost also means not to use the network. If you want to connect to the local machine using the network, use 127.0.0.1 instead as the host.

Make sure that you have the rights to connect to the database. Every user has a host name when you define the rights. So if you have granted rights to SomeUser@localhost, this user will not be able to connect from another machine unless you also grant access from there. You can give the host with wildcards. So if your network uses IP addresses in the range 192.168.0.*, you can grant SomeUser@'192.168.0.%' access rights.

Also, is it possible to configure MySQL to "skip networking". This is probably not the case, but it is a good thing to check if the server does not run in local-only mode (which is rare).

The best thing to do is to test with the mysql command-line client to see if you can connect, and if you cannot, post the error message. If you get an "access denied for SomeUser@SomeHost", you have connection to the server and it is the server who denied access by checking its GRANT tables.

Good luck!


+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)

 

[vacunita]

No need to post another thread.

Original Thread here:

thread436-1648569

----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

Behind the Web, Tips and Tricks for Web Development.

http://behindtheweb.blogspot.com/

 

[madvalpreston]

Hi Don

Sorry I have duplicated this thread earlier today, but I am interested in knowing how you set permissions....

I am very raw with Mysql and I ahve mainly used the workbench. from the other computert I am using ODBC connection with user name SA and the password. On the databse this is the only user I ahve set up. IOn this machine the only thing loaded is the ODBC software... Do I need somehting else?

Could you explain how I run a command from the command line and what command to run please.

Thanks