Connecting to mysqlserver on LAN
smartssa at gmail.com
Sat Jul 30 16:38:13 UTC 2005
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?
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.
~ Darryl ~ smartssa at gmail.com
http://smartssa.com / http://darrylclarke.com
More information about the ubuntu-users