From owner-freebsd-questions@FreeBSD.ORG  Fri Dec 10 21:09:07 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 C94D416A4CE
	for <freebsd-questions@freebsd.org>;
	Fri, 10 Dec 2004 21:09:07 +0000 (GMT)
Received: from www.wcborstel.nl (wcborstel.demon.nl [82.161.134.53])
	by mx1.FreeBSD.org (Postfix) with ESMTP id E7ED143D41
	for <freebsd-questions@freebsd.org>;
	Fri, 10 Dec 2004 21:09:06 +0000 (GMT)
	(envelope-from jorn@wcborstel.nl)
Received: from localhost (localhost [127.0.0.1])
	by www.wcborstel.nl (Postfix) with ESMTP id EDF9F4378;
	Fri, 10 Dec 2004 22:09:25 +0100 (CET)
Received: from www.wcborstel.nl ([127.0.0.1])
 by localhost (www.wcborstel.nl [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 41229-06; Fri, 10 Dec 2004 22:09:25 +0100 (CET)
Received: from www.wcborstel.nl (localhost [127.0.0.1])
	by www.wcborstel.nl (Postfix) with ESMTP id 777D3412D;
	Fri, 10 Dec 2004 22:09:25 +0100 (CET)
From: "Jorn Argelo" <jorn@wcborstel.nl>
To: John DeStefano <john.destefano@gmail.com>
Date: Fri, 10 Dec 2004 22:09:25 +0100
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>
X-Mailer: Open WebMail 2.41 20040926
X-OriginatingIP: 82.161.134.53 (jorn)
MIME-Version: 1.0
Content-Type: text/plain;
	charset=iso-8859-1
X-Virus-Scanned: by amavisd-new at mail.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
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 21:09:07 -0000

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.