Date: Thu, 26 Sep 2002 15:23:11 +0200 From: Roman Neuhauser <neuhauser@bellavista.cz> To: Carl-Johan Kihlbom <div@newcode.se> Cc: Duncan Anker <d.anker@au.darkbluesea.com>, freebsd-questions@FreeBSD.ORG Subject: Re: Connecting to mysqld Message-ID: <20020926132311.GK30361@freepuppy.bellavista.cz> In-Reply-To: <06A5CE3D-D152-11D6-8506-00039363CBAA@newcode.se> References: <1033001025.31183.11.camel@duncan> <06A5CE3D-D152-11D6-8506-00039363CBAA@newcode.se>
next in thread | previous in thread | raw e-mail | index | archive | help
# div@newcode.se / 2002-09-26 15:15:28 +0200:
> On torsdag, sep 26, 2002, at 02:43 Europe/Stockholm, Duncan Anker wrote:
> >On Thu, 2002-09-26 at 07:06, Kirk Strauser wrote:
> >>At 2002-09-25T20:49:20Z, Carl-Johan Kihlbom <div@newcode.se> writes:
> >>>I created the users with "GRANT ALL ON *.* TO kihlbom IDENTIFIED BY
> >>>'password';". The users show up fine in the mysql.user table.
> >>
> >>Did you "FLUSH PRIVILEGES" after the addition?
> >
> >You don't need to do this if you use GRANT to set privileges.
> >
> >What else do you have set in your User table? What about the Db and
> >Host tables?
>
> It worked when i specified the host, as in: GRANT ALL ON *.* to
> kihlbom@localhost. So now the user kihlbom can connect from localhost.
> But I would prefer it if that user could connect from any host. How do
> I do that?
you already did, and your question reveals that you didn't bother
reading the mysql manual.
--
begin 666 nonexistent.vbs
FreeBSD 4.7-RC
3:22PM up 8 days, 22:36, 17 users, load averages: 0.25, 0.17, 0.10
end
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?20020926132311.GK30361>