Date: Fri, 10 Dec 2004 22:09:25 +0100 From: "Jorn Argelo" <jorn@wcborstel.nl> To: John DeStefano <john.destefano@gmail.com> Cc: freebsd-questions@freebsd.org Subject: Re: mysql connect problems Message-ID: <20041210210712.M62103@wcborstel.nl> In-Reply-To: <f2160e0d04121011134308085a@mail.gmail.com> References: <f2160e0d041209141883a59af@mail.gmail.com> <20041209230429.M81198@wcborstel.nl> <f2160e0d04121006545c8e3dfb@mail.gmail.com> <20041210145930.M75908@wcborstel.nl> <f2160e0d04121008077e959232@mail.gmail.com> <20041210165849.M9090@wcborstel.nl> <f2160e0d04121011134308085a@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On Fri, 10 Dec 2004 14:13:40 -0500, John DeStefano wrote > On Fri, 10 Dec 2004 18:08:48 +0100, Jorn Argelo <jorn@wcborstel.nl> wrote: > > > "select user, password, host from user;" on 'mysql' returned 3 'root' > > > entries using 2 different passwords (localhost, %, and the actual > > > host name), 2 anon entries (localhost and host name), 2 'mtuser' entries > > > (one on localhost w/o pw, one on '%'), and one 'wikiuser' entry > > > (localhost w/o pw). I changed the root passwords so they all use the > > > same one, and changed the 'mtuser' entry that didn't have a password > > > so its password matches that of the other entry. > > > > Have you issued the command similair like GRANT ALL PRIVILEGES ON *.* TO > > 'youruser@localhost'; > > Yes: I ran both of these commands as root: > GRANT ALL ON wikidb.* TO wikiuser; > GRANT ALL ON mtdb.* TO mtuser; > FLUSH PRIVILEGES; AFAIK you must type 'wikiuser@localhost' (including the quotes). If that doesn't work, then I don't know it either. Perhaps somebody else on the list has an idea? Jorn.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20041210210712.M62103>