7.1 phpmyadmin skip logon screen?

Fbsd1 fbsd1 at a1poweruser.com
Thu Mar 19 04:26:02 PDT 2009

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.

  $cfg['Servers'][$i]['auth_type']    = 'config';
  $cfg['Servers'][$i]['user']         = 'root';
  $cfg['Servers'][$i]['AllowNoPasswordRoot'] = 'true';

More information about the freebsd-questions mailing list