Posted by Rincewind on 08/27/05 15:33

On 25 Aug 2005 16:03:26 -0700, bissatch@yahoo.co.uk wrote:

> 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

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.

[Back to original message]