From owner-freebsd-questions@FreeBSD.ORG  Sun Apr  2 22:36:04 2006
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 9FD6D16A401
	for <freebsd-questions@freebsd.org>;
	Sun,  2 Apr 2006 22:36:04 +0000 (UTC) (envelope-from kdk@daleco.biz)
Received: from ezekiel.daleco.biz (southernuniform.com [66.76.92.18])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 3C19443D46
	for <freebsd-questions@freebsd.org>;
	Sun,  2 Apr 2006 22:36:04 +0000 (GMT) (envelope-from kdk@daleco.biz)
Received: from [192.168.2.2] ([69.27.149.254])
	by ezekiel.daleco.biz (8.13.4/8.13.1) with ESMTP id k32MYvSk057815;
	Sun, 2 Apr 2006 17:35:17 -0500 (CDT) (envelope-from kdk@daleco.biz)
Message-ID: <44305186.5070403@daleco.biz>
Date: Sun, 02 Apr 2006 17:34:46 -0500
From: Kevin Kinsey <kdk@daleco.biz>
User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.7.12) Gecko/20060127
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Reinhold Platzoeder <reinhold@violetlan.net>
References: <20060403001830.4ca28857@khumuleka>
In-Reply-To: <20060403001830.4ca28857@khumuleka>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Cc: "freebsd-questions@freebsd.org" <freebsd-questions@freebsd.org>
Subject: Re: phpmyadmin and Access denied
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
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: Sun, 02 Apr 2006 22:36:04 -0000

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
>>    
>>
><?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
>  
>

Run "mysql -u root" at the system's CLI, and you should get a clue.

My guess is that phpadmin is attempting to use "root" and "" as
its account name and pw for a MySQL login, and you have a password
for the root account other than "" (much as it should be).  Hence, when
you make the SQL root password into <NULL>, it works ....  

HTH,

Kevin Kinsey

-- 
Pure drivel tends to drive ordinary drivel off of the TV screen.