I set up a small LAN with 2 machines (acer.loc IP:192.168.1.33 and
hppav.loc IP: 192.168.1.34) for test purposes. Each client can access
its own MySQL db w/o problems either via the cmd prompt or MyODBC:
acer: mysql -h192.168.1.33 -u<usr> -p<pwd>
or
hppav: mysql -h192.168.1.34 -u<usr> -p<pwd>
The problem arises when trying to access the MySQL db from the other
client. For example, if I want to connect to the hppav db from
'acer.loc' via:
mysqL -h192.168.1.34 -u<usr> -p<pwd>
I get the following error message:
'ERROR 1130: Host 'acer23555' is not allowed to connect to this MySQL
server'.
The listening port ...
Bookmarks