List:General Discussion« Previous MessageNext Message »
From:Ed Keith Date:May 17 1999 3:50am
Subject:Re: help - not allowed to connect
View as plain text  
Thanks to every one for the quick response. This was it. I'm up and running

Sasha Pachev wrote:

> Ed Keith wrote:
> >
> > I need help. I just installed mySQL on FreeBSD. It appears to have built
> > and installed properly, but when ever I try to do anything with it
> > (issue a mysql or mysqladmin command) I get the following error message:
> >
> > error : 'Host '' is not allowed to connect to this
> > MySQL server'
> >
> > I am issuing the from the same computer that I did the install on. Can
> > anyone give me a hint as to what might cause this problem and how to
> > correct it?
> >
> > thank    you,
> >
> >     -EdK
> Looks like your record in the DNS server (or /etc/hosts
> entry) is confusing MySQL. When you establish a TCP/IP connection, MySQL
> will call gethostbyaddr() to figure out where you are coming from, then
> check for a match in the privilige tables. If you have not changed the
> defaults, localhost is allowed to connect, while anything else is not.
> is not the same as localhost. So if you have root
> access, fix /etc/hosts or the DNS server. Otherwise, start mysqld with
> --skip-grant-tables, edit the table 'host' in mysql database to allow
> connects from, then re-start mysqld normally.
> --
> Sasha Pachev
> ---------------------------------------------------------------------
> Please check "" before
> posting. To request this thread, e-mail mysql-thread3438@stripped
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.

help - not allowed to connectEd Keith17 May
  • Re: help - not allowed to connectPaul DuBois17 May
  • Re: help - not allowed to connectSasha Pachev17 May
  • Re: help - not allowed to connectEd Keith17 May