Connecting to mysqlserver on LAN

Darryl Clarke smartssa at
Sat Jul 30 16:38:13 UTC 2005

On 7/30/05, Piltdownster <piltdownster at> 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

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. will accept any
connections from anhwyere in'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.


~ Darryl  ~ smartssa at /

More information about the ubuntu-users mailing list