Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 4 Feb 2003 18:38:24 +0530
From:      "Unix Tools" <unixtools@hotmail.com>
To:        "Brian Henning" <b1henning@hotmail.com>, "freebsd" <freebsd-questions@FreeBSD.ORG>
Subject:   Re: mysql add host
Message-ID:  <OE14bigPasSmz6UuEhj00003412@hotmail.com>
References:  <OE581JOMyQlmLFQG10100006553@hotmail.com>

next in thread | previous in thread | raw e-mail | index | archive | help
Hi,
Try this
update user set Host='%' where Host='foobar';
update db set Host='%' where Host='foobar';

Cheers






----- Original Message -----
From: "Brian Henning" <b1henning@hotmail.com>
To: "freebsd" <freebsd-questions@FreeBSD.ORG>
Sent: Monday, February 03, 2003 09:30 PM
Subject: mysql add host


> Hello,
> I just installed mysql and i would like to allow all hosts to acess the
> databases on my server.
>
> ERROR 1130: Host 'foobar' is not allowed to connect to this MySQL server
>
> what can i do to remedy this problem?
>
> thank,
> b
>
>
> ps.. the command:.
> >telnet foobar 3306
>
> Host 'trinity.the-matrix.net' is not allowed to connect to this MySQL
server
>
> Connection to host lost.
>
>
> To Unsubscribe: send mail to majordomo@FreeBSD.org
> with "unsubscribe freebsd-questions" in the body of the message
>

To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?OE14bigPasSmz6UuEhj00003412>