Home > Archive > PHP SQL > August 2006 > Password problem with PHPMyAdmin
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Password problem with PHPMyAdmin
|
|
|
| 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" <luiheidsgoeroe@hotmail.com> schreef in bericht
news:5c3ba$44d1d3d1$8259c69c$999@news2.tudelft.nl...
> Piet wrote:
>
> It's your MySQL user/root
>
>
> Edit config.inc.php
>
> Grtz,
> --
> Rik Wasmus
>
>
| |
|
| Piet wrote:
> <moved>
Do not toppost please. Google netiquette.
> "Rik" <luiheidsgoeroe@hotmail.com> schreef in bericht
> news:5c3ba$44d1d3d1$8259c69c$999@news2.tudelft.nl...
> 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
|
|
|
|
|