Hi,
I upgraded my PHP / MySQL with AppServ 2.5.6. nfor Windows.
it contains Apache 2.2.2, PHP 5.1.4, MySQL 5.0.22.
Starting PHPMyAdmin it asks for a username and a password. Installing it I
was not not asked for that.
Does anyone know How I can find the right password and username?
How can I disable the question for a username and password? I am a single
user on a stand alone system.
Piet
Piet wrote:
> Hi,
>
> I upgraded my PHP / MySQL with AppServ 2.5.6. nfor Windows.
> it contains Apache 2.2.2, PHP 5.1.4, MySQL 5.0.22.
> Starting PHPMyAdmin it asks for a username and a password. Installing
> it I was not not asked for that.
>
> Does anyone know How I can find the right password and username?
It's your MySQL user/root
> How can I disable the question for a username and password? I am a
> single user on a stand alone system.
Edit config.inc.php
Grtz,
--
Rik Wasmus
It seems not to be as simple as that. In config.inc.php user='root',
password=' '. But when I give it in access is denied.
Changing user (line 64) and pass (line 66) does not influence this (strange)
behaviour.
"Rik"
news:5c3ba$44d1d3d1$8259c69c$999@news2.tudelft.nl...
> Piet wrote:
>> Hi,
>>
>> I upgraded my PHP / MySQL with AppServ 2.5.6. nfor Windows.
>> it contains Apache 2.2.2, PHP 5.1.4, MySQL 5.0.22.
>> Starting PHPMyAdmin it asks for a username and a password. Installing
>> it I was not not asked for that.
>>
>> Does anyone know How I can find the right password and username?
>
> It's your MySQL user/root
>
>> How can I disable the question for a username and password? I am a
>> single user on a stand alone system.
>
> Edit config.inc.php
>
> Grtz,
> --
> Rik Wasmus
>
>
Piet wrote:
>
Do not toppost please. Google netiquette.
> "Rik"
> news:5c3ba$44d1d3d1$8259c69c$999@news2.tudelft.nl...
>> Piet wrote:
>>> Hi,
>>>
>>> I upgraded my PHP / MySQL with AppServ 2.5.6. nfor Windows.
>>> it contains Apache 2.2.2, PHP 5.1.4, MySQL 5.0.22.
>>> Starting PHPMyAdmin it asks for a username and a password.
>>> Installing
>>> it I was not not asked for that.
>>>
>>> Does anyone know How I can find the right password and username?
>>
>> It's your MySQL user/root
>>
>>> How can I disable the question for a username and password? I am a
>>> single user on a stand alone system.
>>
>> Edit config.inc.php
> It seems not to be as simple as that. In config.inc.php user='root',
> password=' '. But when I give it in access is denied.
> Changing user (line 64) and pass (line 66) does not influence this
> (strange) behaviour.
Password should be '', not ' ' if you're not using a password.
Snippet from my config.inc.php
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
Offcourse, this is only valid when:
- The user can connect with the database (in my instance, can connect with
localhost). Does your database run on the same server?
- There IS a user 'root', and the user doesn't require a password. (A
possible security risk, use only if you're very very very sure people cannot
remotely connect to your database.)
Grtz,
--
Rik Wasmus