Re: MYSQl under YDL CS-1.2


Subject: Re: MYSQl under YDL CS-1.2
From: Michael A. Peters (Moonglue@141.com )
Date: Mon Aug 21 2000 - 23:20:39 MDT


>on 8/21/00 5:35 PM, Paul J. Lucas at pjl@best.com wrote:
>
> > On Mon, 21 Aug 2000, Morten Rønseth wrote:
> >
> >> Just finished compiling and installing PHP & MySQL under CS 1.2.
> >> I then try to connect to an MySQl server on a different machine, using the
> >> command './mysql -h xxx.coil.no -u root -p' and get the following:
> >>
> >> "ERROR 1130: Host '' is not allowed to connect to this MySQL server"
> >
> > MySQL is brain-damaged in that it doesn't permit spaces between
> > options and arguments (for some arguments). That's why you get
> > '' for the user. Try -uroot (no space).
> >
> > - Paul
> >
>
>
>Tried that too - and also, I *can* connect from other clients using the same
>syntax...I can't even connect from a PHP script which I know works on other
>servers.
>What bugs me here is that the MySQl server doesn't seem to think the client
>machine has a name, which it does, I've checked our DNS setup.

I've seen this very problem once before. Not me personally, but
posted on the MySQL list hosted by TcX

I *think* it was something funny about either /etc/hosts or
/etc/sysconfig/network where MySQL looked to those files before they
went to dns and saw something it didn't like.

I'm not positive, though- check the MySQL list.

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Michael A. Peters-- http://24.5.29.77/Linux_Pages/
                                http://www.omnilinux.com/
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  



This archive was generated by hypermail 2a24 : Tue Aug 22 2000 - 00:26:40 MDT