Connecting MySQL from another PC on the Network

On a simple Windows LAN the computer name NIPA-PC has the MySQL Database = Office and the rest of the computers on the network dont have the Database = Office: What I'm trying to do is to connect the other pc's without the Database = Office to the Computer "NIPA-PC" but
This connection string isn't working
"driver={mysql odbc 3.51 driver};server=NIPA-PC;database=Office;UID=root;pwd="

The Error says that: [MySQL][ODBC 3.51 driver] Host("Computer on the network connecting to NIPA-PC") is not allowed to connect to this MySQL Server..

thanks for your help.........

1 answer

I am not anywhere near an expert - but I received the same error when setting up my connections to a MySQL server. My first bet would be that you have not set-up the root user to receive connections from the other computers in your office. The default root username typically receives a connection from the computer MySQL is setup on -- either through the loop 127.0.0.1 or through localhost.

My first guess would be that you need to set-up MySQL to receive a connection from your other computers. An example would be if your LAN uses a DHCP server giving out IP addresses in the 192.168.0.XXX range (or 192.168.1.XXX) then I would set-up a root user in MySQL with a host of 192.168.0.0/255.255.255.0 - from what I learned trying to get my connection working - if you add the /255.255.255.0 at the end of the 192.168.0.0 then it tells MySQL to allow any computer on the LAN to connect as long as the IP address of the asking computer starts with 192.168.0 -- and is on the same LAN (or if you want the last two groups of numbers to be 'wild' then do 192.168.0.0/255.255.0.0).

The issue that took me a long time to figure out on my connection is that my MySQL server was sitting within the IP address range - but was actually on a different LAN (it was working off a different router that had acted as a DHCP server separate from the DHCP server for the rest of the LAN).

Hope this helps . . . without anyone else answering it kind of defaults to the blind leading the blind . . .