Posted by Rik on 08/04/06 13:25

Piet wrote:
> <moved>

Do not toppost please. Google netiquette.

> "Rik" <luiheidsgoeroe@hotmail.com> schreef in bericht
> 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

[Back to original message]