I have just set up a new Ubuntu 10.10 box and tonight installed MySQL. The IP address of the box is:-
In my.cnf I have:-
bind-address = 192.168.0.118
Whenever I try to connect to MySQL I get a message like:-
"Host '220.127.116.11' is not allowed to connect to this server." (IP address depends on which box I'm trying from of course). From any of the other boxes telnet connects:-
telnet 192.168.0.118 3306 fine. I bet I'm missing something obvious but I could do with some help.