From owner-freebsd-questions@FreeBSD.ORG Mon Apr 3 00:07:08 2006 Return-Path: X-Original-To: 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 8C3AA16A401 for ; Mon, 3 Apr 2006 00:07:08 +0000 (UTC) (envelope-from reinhold@violetlan.net) Received: from scurvy.violetlan.net (d463ce08.datahighways.de [212.99.206.8]) by mx1.FreeBSD.org (Postfix) with SMTP id CDF3A43D45 for ; Mon, 3 Apr 2006 00:07:07 +0000 (GMT) (envelope-from reinhold@violetlan.net) Received: from scurvy.violetlan.net (localhost.violetlan.net [127.0.0.1]) by scurvy.violetlan.net (Postfix) with SMTP id D5B8E33C12; Mon, 3 Apr 2006 01:12:03 +0200 (CEST) Received: from khumuleka (unknown [192.168.100.199]) by scurvy.violetlan.net (Postfix) with ESMTP id 95A3533C0F; Mon, 3 Apr 2006 01:12:03 +0200 (CEST) Date: Mon, 3 Apr 2006 02:07:27 +0200 From: Reinhold Platzoeder To: freebsd-questions@freebsd.org Message-ID: <20060403020727.7978e3db@khumuleka> In-Reply-To: <200604021851.51547.gerard@seibercom.net> References: <20060403001830.4ca28857@khumuleka> <200604021822.01679.nb_root@videotron.ca> <200604021851.51547.gerard@seibercom.net> Organization: Violetlan X-Mailer: Sylpheed-Claws 2.0.0 (GTK+ 2.8.16; i386-portbld-freebsd6.1) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Cc: Subject: Re: phpmyadmin and Access denied X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 03 Apr 2006 00:07:08 -0000 On Sun, 2 Apr 2006 17:51:50 -0500 Gerard Seibert wrote: > Nicolas Blais wrote: > > > On Sunday 02 April 2006 18:18, Reinhold Platzoeder wrote: > > > Hi > > > > > > I have a weird problem here > > > > > > I have installed phpMyAdmin 2.8.0.2 from port > > > > > > Apache version = apache-2.2.0_7 > > > PHP version = php5-5.1.2_1 > > > MySQL version = mysql-server-5.0.19 > > > > > > > > > When I go to the index page I get the following error > > > > > > #1045 - Access denied for user 'root'@'localhost' (using password: > > > NO) > > > > > > I have configured the config.inc.php file and this is whats in it > > > > > > > cat config.inc.php > > > > > > > > /* $FreeBSD: > > > ports/databases/phpmyadmin/files/config.inc.php.sample,v 1.1 > > > 2005/12/05 11:37:27 garga Exp $ * > > > * Skeleton configuration file -- this file is empty on a fresh > > > * installaton of phpmyadmin. > > > * > > > * Copy any settings you want to override from config.defaults.php > > > * > > > */ > > > $cfg['PmaAbsoluteUri'] = 'http://www.violetlan.net/phpmyadmin/'; > > > > > > $cfg['blowfish_secret'] = 'whatever'; > > > > > > $cfg['Servers'][$i]['host'] = 'localhost'; > > > > > > $cfg['Servers'][$i]['auth_type'] = 'cookie'; > > > > > > $cfg['Servers'][$i]['user'] = 'root'; > > > > > > $cfg['Servers'][$i]['password'] = ''; > > > > > > $cfg['Servers'][$i]['connect_type'] = 'socket'; > > > > > > $cfg['Servers'][$i]['socket'] = '/tmp/mysql.sock'; > > > > > > ?> > > > > > > Now the funny thing is that when I change the root password to > > > having no password I can get into phpmyadmin > > > > > > Any ideas as to how I can fix this? > > > > > > Thanks > > > > Try generating your config.inc.php from > > http://www.violetlan.net/phpmyadmin/scripts/setup.php > > > > instead of making one. I had the same problem after an update from > > 2.7 to 2.8 and this fixed it. > > > > Nicolas. > > Make this change: > > $cfg['Servers'][$i]['auth_type'] = 'http'; > > I have that in my config file with a blank password field. It works > fine. > Thanks I was not aware of the setup script That worked for me -- Reinhold Platzoeder