From owner-freebsd-questions@FreeBSD.ORG Sat Dec 11 00:47:08 2004 Return-Path: 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 2BD1116A4CE for ; Sat, 11 Dec 2004 00:47:08 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.197]) by mx1.FreeBSD.org (Postfix) with ESMTP id C53E143D55 for ; Sat, 11 Dec 2004 00:47:07 +0000 (GMT) (envelope-from john.destefano@gmail.com) Received: by rproxy.gmail.com with SMTP id z35so489645rne for ; Fri, 10 Dec 2004 16:47:07 -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=qfUCjF0obMDYDFgQqU7neLM5VO09ddWE2dxYvwYbEfXEBQsZ85HrJLzbnMYSOK9fgaxFo0Nwa0sA5FXs1ddvdwYDcRtiw1ZFJO6IRHJ9zAs0u+4dH+TvJUlzMTqIH8CFGHTTuLBWNFLk3RGxPQ/Lpk3rrsG49hd13U5jE2DJtT8= Received: by 10.38.83.22 with SMTP id g22mr603888rnb; Fri, 10 Dec 2004 16:47:07 -0800 (PST) Received: by 10.38.99.32 with HTTP; Fri, 10 Dec 2004 16:47:07 -0800 (PST) Message-ID: Date: Fri, 10 Dec 2004 19:47:07 -0500 From: John DeStefano To: Peter Risdon In-Reply-To: <41BA1877.60203@circlesquared.com> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <20041209230429.M81198@wcborstel.nl> <20041210145930.M75908@wcborstel.nl> <20041210165849.M9090@wcborstel.nl> <20041210210712.M62103@wcborstel.nl> <41BA1877.60203@circlesquared.com> cc: Jorn Argelo 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 List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 11 Dec 2004 00:47:08 -0000 On Fri, 10 Dec 2004 21:43:19 +0000, Peter Risdon wrote: > > 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? > > I have found it's best to connect to the database you want to grant the > privileges on before issuing the GRANT command. This doesn't seem to be > the way it's documented, but it works for me. You might also consider > using passwords... > > mysql>\u wikidb > mysql>GRANT ALL on wikidb.* to wikiuser@localhost IDENTIFIED BY 'password'; > mysql>\u mtdb > mysql>GRANT ALL on mtdb.* to mtuser@localhost IDENTIFIED BY 'password'; > Thank you both. Certainly makes sense, but it didn't work (If it _had_ worked, I'd be suspicious as to why I needed to do this for MediaWiki, and not for Mobile Type (which works now).). When I specify a value for "MySQL server" and for "DB root password" on the MediaWiki 1.3.8 installation page, I get "Couldn't connect to database" with a script note "MySQL error 1250: Client does not support authentication protocol requested by server; consider upgrading MySQL client". When I omit the root password value, so it can connect with the user wikiuser, it says "Check name/pass or enter root password below", with notes "# MySQL error 1045: Access denied for user: 'root'@'localhost' (Using password: NO)" and "Trying regular user... need password."