phpMyAdmin

Joe a écrit :
> FreeBSD 7.1 box containing the following; php5.2.9 / mysql 5.0.67 / 
> Apache 1.3.41 / Phpmyadmin 3.1.3
> 
> Using mysql -u root from FreeBSD shell command line to add database def 
> statements works fine, so I know the mysql default root id is working as 
> expected. Can also run the php/mysql web application adding records to 
> mysql DB just fine. Phpmyadmin 2.11.2.2 works fine with the mysql 
> default root account.
> 
> When starting Phpmyadmin 3.1.3 from XP browser on Lan with 
> http://10.0.10.2/phpmyadmin/index.php I get logon screen in uppercase 
> mode. Entering lower case root gives access denied error. Entering upper 
> case root gives access but my database is not displayed.
> 
> Tried to setup config.inc.php by adding statement
> $cfg['Servers'][$i]['user']   =  'root';
> This had no effect. I though on browser accessing Phpmyadmin I would 
> bypass the login screen and have full access to Phpmyadmin and mysql 
> root account privileged functions?
> 
> What do I have to do to Phpmyadmin 3.1.3 to bypass the login screen and 
> gain full-unrestricted access to the default mysql superuser root 
> without password?

Maybe ... read the doc?


$cfg['Servers'][$i]['auth_type'] string 
['HTTP'|'http'|'cookie'|'config'|'signon']
     Whether config or cookie or HTTP or signon authentication should be 
used for this server.

         * 'config' authentication ($auth_type = 'config') is the plain 
old way: username and password are stored in config.inc.php.


$cfg['Servers'][$i]['AllowNoPasswordRoot'] boolean
     Whether to allow access to root user without password. The default 
value of false for this parameter prevents unintended access to a MySQL 
server with was left with an empty password for root.


> 
> 
> ------------------------------------------------------------------------------
> Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
> powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
> easily build your RIAs with Flex Builder, the Eclipse(TM)based development
> software that enables intelligent coding and step-through debugging.
> Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
> _______________________________________________
> Phpmyadmin-users mailing list
> Phpmyadmin-users@...
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-users
>

Marc Delisle wrote:
> Joe a écrit :
>> FreeBSD 7.1 box containing the following; php5.2.9 / mysql 5.0.67 / 
>> Apache 1.3.41 / Phpmyadmin 3.1.3
>>
>> Using mysql -u root from FreeBSD shell command line to add database 
>> def statements works fine, so I know the mysql default root id is 
>> working as expected. Can also run the php/mysql web application 
>> adding records to mysql DB just fine. Phpmyadmin 2.11.2.2 works fine 
>> with the mysql default root account.
>>
>> When starting Phpmyadmin 3.1.3 from XP browser on Lan with 
>> http://10.0.10.2/phpmyadmin/index.php I get logon screen in uppercase 
>> mode. Entering lower case root gives access denied error. Entering 
>> upper case root gives access but my database is not displayed.
>>
>> Tried to setup config.inc.php by adding statement
>> $cfg['Servers'][$i]['user']   =  'root';
>> This had no effect. I though on browser accessing Phpmyadmin I would 
>> bypass the login screen and have full access to Phpmyadmin and mysql 
>> root account privileged functions?
>>
>> What do I have to do to Phpmyadmin 3.1.3 to bypass the login screen 
>> and gain full-unrestricted access to the default mysql superuser root 
>> without password?
>
> Maybe ... read the doc?
>
>
> $cfg['Servers'][$i]['auth_type'] string 
> ['HTTP'|'http'|'cookie'|'config'|'signon']
>     Whether config or cookie or HTTP or signon authentication should 
> be used for this server.
>
>         * 'config' authentication ($auth_type = 'config') is the plain 
> old way: username and password are stored in config.inc.php.
>
>
> $cfg['Servers'][$i]['AllowNoPasswordRoot'] boolean
>     Whether to allow access to root user without password. The default 
> value of false for this parameter prevents unintended access to a 
> MySQL server with was left with an empty password for root.
>

Finally got it to work. Problem is documentation shows this statement

$cfg['Servers'][$i]['AllowNoPasswordRoot'] boolean;

And that is how i put it in my config.inc.php file. Kept getting sytax 
error.

What worked is
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = 'true';

No where did I read that boolean means = 'true' or = 'false'. Tried yes 
and no with no joy.

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

Joe a écrit :
> Marc Delisle wrote:
>> Joe a écrit :
>>> FreeBSD 7.1 box containing the following; php5.2.9 / mysql 5.0.67 / 
>>> Apache 1.3.41 / Phpmyadmin 3.1.3
>>>
>>> Using mysql -u root from FreeBSD shell command line to add database 
>>> def statements works fine, so I know the mysql default root id is 
>>> working as expected. Can also run the php/mysql web application 
>>> adding records to mysql DB just fine. Phpmyadmin 2.11.2.2 works fine 
>>> with the mysql default root account.
>>>
>>> When starting Phpmyadmin 3.1.3 from XP browser on Lan with 
>>> http://10.0.10.2/phpmyadmin/index.php I get logon screen in uppercase 
>>> mode. Entering lower case root gives access denied error. Entering 
>>> upper case root gives access but my database is not displayed.
>>>
>>> Tried to setup config.inc.php by adding statement
>>> $cfg['Servers'][$i]['user']   =  'root';
>>> This had no effect. I though on browser accessing Phpmyadmin I would 
>>> bypass the login screen and have full access to Phpmyadmin and mysql 
>>> root account privileged functions?
>>>
>>> What do I have to do to Phpmyadmin 3.1.3 to bypass the login screen 
>>> and gain full-unrestricted access to the default mysql superuser root 
>>> without password?
>> Maybe ... read the doc?
>>
>>
>> $cfg['Servers'][$i]['auth_type'] string 
>> ['HTTP'|'http'|'cookie'|'config'|'signon']
>>     Whether config or cookie or HTTP or signon authentication should 
>> be used for this server.
>>
>>         * 'config' authentication ($auth_type = 'config') is the plain 
>> old way: username and password are stored in config.inc.php.
>>
>>
>> $cfg['Servers'][$i]['AllowNoPasswordRoot'] boolean
>>     Whether to allow access to root user without password. The default 
>> value of false for this parameter prevents unintended access to a 
>> MySQL server with was left with an empty password for root.
>>
> 
> Finally got it to work. Problem is documentation shows this statement
> 
> $cfg['Servers'][$i]['AllowNoPasswordRoot'] boolean;
> 
> And that is how i put it in my config.inc.php file. Kept getting sytax 
> error.
> 
> What worked is
> $cfg['Servers'][$i]['AllowNoPasswordRoot'] = 'true';
> 
> No where did I read that boolean means = 'true' or = 'false'. Tried yes 
> and no with no joy.
> 
> 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';
> ?>

You should use libraries/config.default.php to look for examples.

Marc Delisle wrote:
> Joe a écrit :
>> Marc Delisle wrote:
>>> Joe a écrit :
>>>> FreeBSD 7.1 box containing the following; php5.2.9 / mysql 5.0.67 / 
>>>> Apache 1.3.41 / Phpmyadmin 3.1.3
>>>>
>>>> Using mysql -u root from FreeBSD shell command line to add database 
>>>> def statements works fine, so I know the mysql default root id is 
>>>> working as expected. Can also run the php/mysql web application 
>>>> adding records to mysql DB just fine. Phpmyadmin 2.11.2.2 works 
>>>> fine with the mysql default root account.
>>>>
>>>> When starting Phpmyadmin 3.1.3 from XP browser on Lan with 
>>>> http://10.0.10.2/phpmyadmin/index.php I get logon screen in 
>>>> uppercase mode. Entering lower case root gives access denied error. 
>>>> Entering upper case root gives access but my database is not 
>>>> displayed.
>>>>
>>>> Tried to setup config.inc.php by adding statement
>>>> $cfg['Servers'][$i]['user']   =  'root';
>>>> This had no effect. I though on browser accessing Phpmyadmin I 
>>>> would bypass the login screen and have full access to Phpmyadmin 
>>>> and mysql root account privileged functions?
>>>>
>>>> What do I have to do to Phpmyadmin 3.1.3 to bypass the login screen 
>>>> and gain full-unrestricted access to the default mysql superuser 
>>>> root without password?
>>> Maybe ... read the doc?
>>>
>>>
>>> $cfg['Servers'][$i]['auth_type'] string 
>>> ['HTTP'|'http'|'cookie'|'config'|'signon']
>>>     Whether config or cookie or HTTP or signon authentication should 
>>> be used for this server.
>>>
>>>         * 'config' authentication ($auth_type = 'config') is the 
>>> plain old way: username and password are stored in config.inc.php.
>>>
>>>
>>> $cfg['Servers'][$i]['AllowNoPasswordRoot'] boolean
>>>     Whether to allow access to root user without password. The 
>>> default value of false for this parameter prevents unintended access 
>>> to a MySQL server with was left with an empty password for root.
>>>
>>
>> Finally got it to work. Problem is documentation shows this statement
>>
>> $cfg['Servers'][$i]['AllowNoPasswordRoot'] boolean;
>>
>> And that is how i put it in my config.inc.php file. Kept getting 
>> sytax error.
>>
>> What worked is
>> $cfg['Servers'][$i]['AllowNoPasswordRoot'] = 'true';
>>
>> No where did I read that boolean means = 'true' or = 'false'. Tried 
>> yes and no with no joy.
>>
>> 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';
>> ?>
>
> You should use libraries/config.default.php to look for examples.
>
>
>
>
I did look at that file and it has no examples on this subject.

Joe a écrit :
> Marc Delisle wrote:
>> Joe a écrit :
>>> Marc Delisle wrote:
>>>> Joe a écrit :
>>>>> FreeBSD 7.1 box containing the following; php5.2.9 / mysql 5.0.67 / 
>>>>> Apache 1.3.41 / Phpmyadmin 3.1.3
>>>>>
>>>>> Using mysql -u root from FreeBSD shell command line to add database 
>>>>> def statements works fine, so I know the mysql default root id is 
>>>>> working as expected. Can also run the php/mysql web application 
>>>>> adding records to mysql DB just fine. Phpmyadmin 2.11.2.2 works 
>>>>> fine with the mysql default root account.
>>>>>
>>>>> When starting Phpmyadmin 3.1.3 from XP browser on Lan with 
>>>>> http://10.0.10.2/phpmyadmin/index.php I get logon screen in 
>>>>> uppercase mode. Entering lower case root gives access denied error. 
>>>>> Entering upper case root gives access but my database is not 
>>>>> displayed.
>>>>>
>>>>> Tried to setup config.inc.php by adding statement
>>>>> $cfg['Servers'][$i]['user']   =  'root';
>>>>> This had no effect. I though on browser accessing Phpmyadmin I 
>>>>> would bypass the login screen and have full access to Phpmyadmin 
>>>>> and mysql root account privileged functions?
>>>>>
>>>>> What do I have to do to Phpmyadmin 3.1.3 to bypass the login screen 
>>>>> and gain full-unrestricted access to the default mysql superuser 
>>>>> root without password?
>>>> Maybe ... read the doc?
>>>>
>>>>
>>>> $cfg['Servers'][$i]['auth_type'] string 
>>>> ['HTTP'|'http'|'cookie'|'config'|'signon']
>>>>     Whether config or cookie or HTTP or signon authentication should 
>>>> be used for this server.
>>>>
>>>>         * 'config' authentication ($auth_type = 'config') is the 
>>>> plain old way: username and password are stored in config.inc.php.
>>>>
>>>>
>>>> $cfg['Servers'][$i]['AllowNoPasswordRoot'] boolean
>>>>     Whether to allow access to root user without password. The 
>>>> default value of false for this parameter prevents unintended access 
>>>> to a MySQL server with was left with an empty password for root.
>>>>
>>>
>>> Finally got it to work. Problem is documentation shows this statement
>>>
>>> $cfg['Servers'][$i]['AllowNoPasswordRoot'] boolean;
>>>
>>> And that is how i put it in my config.inc.php file. Kept getting 
>>> sytax error.
>>>
>>> What worked is
>>> $cfg['Servers'][$i]['AllowNoPasswordRoot'] = 'true';
>>>
>>> No where did I read that boolean means = 'true' or = 'false'. Tried 
>>> yes and no with no joy.
>>>
>>> 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';
>>> ?>
>>
>> You should use libraries/config.default.php to look for examples.
> I did look at that file and it has no examples on this subject.
> 
I was talking about your "boolean" problem. This file has this line:
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = false;

that shows which value can be set for this parameter.