Connecting to mysqlserver on LAN

[Darryl Clarke]

On 7/30/05, Piltdownster <piltdownster at gmail.com> wrote:
> If I telnet the mysqlserver using the command telnet server 3306 I get:
> 
> "... 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?
> 
> Thanks

mySQL handles it's own host controls.  It's done via the permissions
table using usernames and hostnames.

for example: username at remote.host.com

By default, only root is allowed to access the server via localhost
(but it will accept an initial connection from anywhere)

using % as the hostname is a whildcard.  %.host.com will accept any
connections from anhwyere in host.com's domain.

If you are not too familliar with mySQL's permissions, the
documentation is the best place to start.  If your server also has
apache/php enabled I recommend phpmyadmin.  If your server is capable
of running an X application over SSH I recommend mysql-admin.

HTH.

-- 
~ Darryl  ~ smartssa at gmail.com
http://smartssa.com / http://darrylclarke.com