phpMyAdmin connect problem

[bissatch@yahoo.co.uk]

Hi,

I am trying to use phpMyAdmin but not getting past the start up screen.


I am getting the following error:

#1045 Access denied for user: root@localhost (Using Password: NO)

I have went through config.inc.php to ensure that I have entered the
correct host, username and password. It is the part in the error
message, 'Using password: NO', that I dont understand. How do I
configure it to use passwords if that is the problem?

Does anybody recognise this problem, it would be great to hear.

Cheers

Burnsy

[bissatch@yahoo.co.uk]

Re: phpMyAdmin connect problem

I'd also like to add that I am using Apache, PHP and MySQL from my home
computer. It is a pretty default installation of all.

Burnsy

[Jerry Stuckle]

Re: phpMyAdmin connect problem

bissatch@yahoo. co.uk wrote:[color=blue]
> Hi,
>
> I am trying to use phpMyAdmin but not getting past the start up screen.
>
>
> I am getting the following error:
>
> #1045 Access denied for user: root@localhost (Using Password: NO)
>
> I have went through config.inc.php to ensure that I have entered the
> correct host, username and password. It is the part in the error
> message, 'Using password: NO', that I dont understand. How do I
> configure it to use passwords if that is the problem?
>
> Does anybody recognise this problem, it would be great to hear.
>
> Cheers
>
> Burnsy
>[/color]

There are two passwords - see your config.inc.php file and look for the entires:

$cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user"
// and "mysql/db" tables).
// The controluser is also
// used for all relational
// features (pmadb)
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed


--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===

[Rincewind]

Re: phpMyAdmin connect problem

On 25 Aug 2005 16:03:26 -0700, bissatch@yahoo. co.uk wrote:
[color=blue]
> Hi,
>
> I am trying to use phpMyAdmin but not getting past the start up screen.
>
>
> I am getting the following error:
>
> #1045 Access denied for user: root@localhost (Using Password: NO)
>
> I have went through config.inc.php to ensure that I have entered the
> correct host, username and password. It is the part in the error
> message, 'Using password: NO', that I dont understand. How do I
> configure it to use passwords if that is the problem?
>
> Does anybody recognise this problem, it would be great to hear.
>
> Cheers
>
> Burnsy[/color]

First check your config.inc.php file to see what type of authentication is
used. look for $cfg['Servers'][$i]['auth_type'] you have three to choose
from, HTTP, cookie or config.

Because if you use HTTP or cookie authentication you don't need to put your
user/password in the config.inc.php file. you enter it when you start up
phpMyadmin.

If you use the config method you only need to enter your user/pass into the
following two fields $cfg['Servers'][$i]['user']= '';
$cfg['Servers'][$i]['password'] = '';
Check that the input is *Between* the two single quotes, I spent ages the
first time I set this up because I had brain fade and thought that they
were a single double quote :-0.

The other two areas that ask for authentication
$cfg['Servers'][$i]['controluser'] = '';
$cfg['Servers'][$i]['controlpass'] = ''; are only needed to open up
further features in phpMyadmin, check the documentation that comes with the
program to see if you want this activated, because if you do, you will need
to follow the instructions provided to create a number of tables.