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? To Unsubscribe: send mail to [EMAIL PROTECTED] with "unsubscribe freebsd-questions" in the body of the message
