From owner-freebsd-questions@FreeBSD.ORG Sun Apr 2 22:52:06 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 55B6216A420 for ; Sun, 2 Apr 2006 22:52:06 +0000 (UTC) (envelope-from gerard@seibercom.net) Received: from smtp4.suscom.net (smtp4.suscom.net [64.78.119.249]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8749343D46 for ; Sun, 2 Apr 2006 22:52:05 +0000 (GMT) (envelope-from gerard@seibercom.net) Received: from localhost (unknown [127.0.0.1]) by smtp4.suscom.net (Postfix) with ESMTP id 909C415005C for ; Sun, 2 Apr 2006 18:52:03 -0400 (EDT) Received: from smtp4.suscom.net ([127.0.0.1]) by localhost (smtp4.suscom.net [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 07308-01-87 for ; Sun, 2 Apr 2006 18:51:51 -0400 (EDT) Received: from localhost.www2.seibercom.net (ip148.217.45.216.suscom.net [216.45.217.148]) by smtp4.suscom.net (Postfix) with SMTP id B93471500D9 for ; Sun, 2 Apr 2006 18:51:51 -0400 (EDT) Received: from localhost.www2.seibercom.net (localhost [127.0.0.1]) by localhost.www2.seibercom.net (8.13.4/8.13.4) with ESMTP id k32MpqAM027169 for ; Sun, 2 Apr 2006 18:51:52 -0400 (EDT) (envelope-from gerard@seibercom.net) Received: from localhost (localhost [[UNIX: localhost]]) by localhost.www2.seibercom.net (8.13.4/8.13.4/Submit) id k32MpqWs027168 for freebsd-questions@freebsd.org; Sun, 2 Apr 2006 18:51:52 -0400 (EDT) (envelope-from gerard@seibercom.net) From: Gerard Seibert Organization: Seibercom,net To: freebsd-questions@freebsd.org Date: Sun, 2 Apr 2006 17:51:50 -0500 User-Agent: KMail/1.9.1 References: <20060403001830.4ca28857@khumuleka> <200604021822.01679.nb_root@videotron.ca> In-Reply-To: <200604021822.01679.nb_root@videotron.ca> X-Face: "\j?x](l|]4p?-1Bf@!wN<&p=$.}^k-HgL}cJKbQZ3r#Ar]\%U(#6}'?<3s7%(%(=?utf-8?q?gxJxxc=0A=09RnSNPNr*/=5E=7EStawWU9KDJ-CT0k=24f=23?=@t2^K&BS_f|?ZV/.7Q MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200604021851.51547.gerard@seibercom.net> X-Virus-Scanned: amavisd-new at suscom.net Subject: Re: phpmyadmin and Access denied X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: gerard@seibercom.net List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 02 Apr 2006 22:52:06 -0000 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. -- Gerard Seibert gerard@seibercom.net PGP: http://www.seibercom.net/sig/gerard.asc