From owner-freebsd-questions@FreeBSD.ORG  Tue Mar 17 08:38:09 2009
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id A794C1065670
	for <freebsd-questions@freebsd.org>;
	Tue, 17 Mar 2009 08:38:09 +0000 (UTC)
	(envelope-from fbsd1@a1poweruser.com)
Received: from mail-03.name-services.com (mail-03.name-services.com
	[69.64.155.195])
	by mx1.freebsd.org (Postfix) with ESMTP id 8D19A8FC14
	for <freebsd-questions@freebsd.org>;
	Tue, 17 Mar 2009 08:38:09 +0000 (UTC)
	(envelope-from fbsd1@a1poweruser.com)
Received: from [10.0.10.6] ([202.69.174.36]) by mail-03.name-services.com with
	Microsoft SMTPSVC(6.0.3790.3959); Tue, 17 Mar 2009 01:37:53 -0700
Message-ID: <49BF616D.8070408@a1poweruser.com>
Date: Tue, 17 Mar 2009 16:38:05 +0800
From: Fbsd1 <fbsd1@a1poweruser.com>
User-Agent: Thunderbird 2.0.0.17 (Windows/20080914)
MIME-Version: 1.0
To: Matthew Seaman <m.seaman@infracaninophile.co.uk>
References: <49BDE5CE.80905@a1poweruser.com>
	<49BDF61F.8040204@infracaninophile.co.uk>
In-Reply-To: <49BDF61F.8040204@infracaninophile.co.uk>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-OriginalArrivalTime: 17 Mar 2009 08:37:54.0042 (UTC)
	FILETIME=[AA3505A0:01C9A6DB]
X-Sender: fbsd1@a1poweruser.com
Cc: FreeBSD Questions <freebsd-questions@freebsd.org>
Subject: Re: 7.1 phpmyadmin skip logon screen?
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: Tue, 17 Mar 2009 08:38:10 -0000

Matthew Seaman wrote:
> Fbsd1 wrote:
>> In 7.1 phpmyadmin now drops you into a logon screen.
>> How do I stop this function and always go to main menu screen?
> 
> That's nothing to do with the FreeBSD version -- phpMyAdmin works the
> same on any platform.
> 
> To make phpMyAdmin auto-login to a DB, you need to use 'config'
> authentication mode.
> 
>   http://www.phpmyadmin.net/documentation/#authentication_modes
> 
> It's probably the least secure authentication mode provided, so you
> should take further steps in your Apache config to stop the world
> gaining access to your database.
> 
>     Cheers,
> 
>     Matthew
> 

Read the user id info on mysql and phpmyadmin. It's so much overkill. 
Don't need to secure then at all. I have inhouse development box on 
private lan and mysql has always worked just fine with superuser mysql 
id of root without password. In the previous version of phpmyadmin no 
login id was required and I was able to see my DB definitions. Tried to 
setup config.inc.php by adding statement
$cfg['Servers'][$i]['user']   = 'root';  but no joy.


What is needed in config.inc.php to allow the default mysql superuser 
user id root full access in phpmyadmin?