From owner-freebsd-questions@FreeBSD.ORG  Thu Mar 19 11:26:00 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 939C91065670
	for <freebsd-questions@freebsd.org>;
	Thu, 19 Mar 2009 11:26:00 +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 7AC7D8FC18
	for <freebsd-questions@freebsd.org>;
	Thu, 19 Mar 2009 11:26:00 +0000 (UTC)
	(envelope-from fbsd1@a1poweruser.com)
Received: from [10.0.10.6] ([202.69.172.225]) by mail-03.name-services.com
	with Microsoft SMTPSVC(6.0.3790.3959); 
	Thu, 19 Mar 2009 04:25:47 -0700
Message-ID: <49C22BBA.3000002@a1poweruser.com>
Date: Thu, 19 Mar 2009 19:25:46 +0800
From: Fbsd1 <fbsd1@a1poweruser.com>
User-Agent: Thunderbird 2.0.0.17 (Windows/20080914)
MIME-Version: 1.0
To: FreeBSD Questions <freebsd-questions@freebsd.org>
References: <49BDE5CE.80905@a1poweruser.com>	<49BDF61F.8040204@infracaninophile.co.uk>
	<49BF616D.8070408@a1poweruser.com>
In-Reply-To: <49BF616D.8070408@a1poweruser.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-OriginalArrivalTime: 19 Mar 2009 11:25:47.0404 (UTC)
	FILETIME=[733994C0:01C9A885]
X-Sender: fbsd1@a1poweruser.com
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: Thu, 19 Mar 2009 11:26:02 -0000

Fbsd1 wrote:
> 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?
> 
> 
> 
> 
For the archives.
Figured it out for myself after much testing.

This is the contents of my working config.inc.php file.

  <?php
  $i=0;
  $i++;
  $cfg['Servers'][$i]['auth_type']    = 'config';
  $cfg['Servers'][$i]['user']         = 'root';
  $cfg['Servers'][$i]['AllowNoPasswordRoot'] = 'true';
  ?>