I have a database on a machine with an ip address of 192.168.0.6. I have another machine with an ip address of 192.168.0.11 which has a program on it that uses the database on the 192.168.0.6 machine. I can ping from both machines to the other. The user on the .0.11 machine is 'auction' and the password is 'auction'. On the .0.6 machine I executed mysql as root and issued the command:
GRANT ALL ON auction6.* TO 'auction'@'192.168.0.11' identified by 'auction'.
When I execute the program on the .0.11 machine it gives me the following error:
MySQL error: Can't connect to MySQL server on '192.168.0.6' (110)
Any ideas anyone? Thanks!