Date: Fri, 10 Dec 2004 14:13:40 -0500 From: John DeStefano <john.destefano@gmail.com> To: Jorn Argelo <jorn@wcborstel.nl> Cc: freebsd-questions@freebsd.org Subject: Re: mysql connect problems Message-ID: <f2160e0d04121011134308085a@mail.gmail.com> In-Reply-To: <20041210165849.M9090@wcborstel.nl> 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>
next in thread | previous in thread | raw e-mail | index | archive | help
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; It still didn't work in either case. However, I logged off as I had to leave for a bit, later opened a new SSH session, and now can log in to mysql as both users, AND Mobile Type is now working! I have no idea what changed. And MediaWiki is still saying "Couldn't connect to database". Running "show databases;" as 'wikiuser' shows the proper database (plus the 'test' database). I'm stuck.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?f2160e0d04121011134308085a>