Date: Thu, 26 Sep 2002 15:15:28 +0200 From: Carl-Johan Kihlbom <div@newcode.se> To: Duncan Anker <d.anker@au.darkbluesea.com> Cc: freebsd-questions@FreeBSD.ORG Subject: Re: Connecting to mysqld Message-ID: <06A5CE3D-D152-11D6-8506-00039363CBAA@newcode.se> In-Reply-To: <1033001025.31183.11.camel@duncan>
next in thread | previous in thread | raw e-mail | index | archive | help
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? 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?06A5CE3D-D152-11D6-8506-00039363CBAA>