Connecting to mysqlserver on LAN

[Steve Torrefranca]

>"... is not allowed to connect to this MySQL serverConnection closed by
>foreign host"
>
>The /etc/hosts and /etc/hosts.allow file contains the corect information, so
>I guess this may be a firewall problem. Any ideas on how to connect?

this is more than a firewall problem.

You have to comment out this line
bind-address           = 127.0.0.1
from /etc/mysql/my.cnf

then that will allow remote connections.  But this allows everyone 
remote access to your mysql.  I would suggest you also  install mysqlcc 
or mysql-admin.  play around with user settings and limit users to 
access mysql from specific machines like root at 10.0.0.1 and/or 
root at 10.0.0.2 instead of having root@%


steve

-- 
Steve Ong Torrefranca
http://www.on-tvmall.com.tw