# [EMAIL PROTECTED] / 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 <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED]
with "unsubscribe freebsd-questions" in the body of the message
