From owner-freebsd-questions@FreeBSD.ORG  Fri Dec 10 19:13:49 2004
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 1ADD316A4CE
	for <freebsd-questions@freebsd.org>;
	Fri, 10 Dec 2004 19:13:49 +0000 (GMT)
Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.203])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 919B243D70
	for <freebsd-questions@freebsd.org>;
	Fri, 10 Dec 2004 19:13:48 +0000 (GMT)
	(envelope-from john.destefano@gmail.com)
Received: by rproxy.gmail.com with SMTP id z35so466709rne
	for <freebsd-questions@freebsd.org>;
	Fri, 10 Dec 2004 11:13:41 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
	s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references;
	b=keANesbOgIhoHZj8Uzb3SzygOwfiNvLMgt7CBRBPvEBwdtqCMGG0NsCWBT8Ds8r0jtzyAIPhyaovtaifHjagaaviwhrybiqr9AEdVUtltFhP0Qi3z03gm2HhHIMkYDEuY8MelwaAbko4WEdYkTnE4TPYl/VfJWC2P1akNxevBiM=
Received: by 10.38.163.80 with SMTP id l80mr184230rne;
        Fri, 10 Dec 2004 11:13:40 -0800 (PST)
Received: by 10.38.99.32 with HTTP; Fri, 10 Dec 2004 11:13:40 -0800 (PST)
Message-ID: <f2160e0d04121011134308085a@mail.gmail.com>
Date: Fri, 10 Dec 2004 14:13:40 -0500
From: John DeStefano <john.destefano@gmail.com>
To: Jorn Argelo <jorn@wcborstel.nl>
In-Reply-To: <20041210165849.M9090@wcborstel.nl>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
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>
cc: freebsd-questions@freebsd.org
Subject: Re: mysql connect problems
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
Reply-To: John DeStefano <john.destefano@gmail.com>
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 10 Dec 2004 19:13:49 -0000

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.