Connecting MySQL from another PC on the Network

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 . . .