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.
<?php
$i=0;
$i++;
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = 'true';
?>
More information about the freebsd-questions
mailing list