[Ade]

When I try to access phpMyAdmin on my local setup (using WAMPserver) I get a MySQL error, as follows:

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

I don't know enough about MySQL to figure the cause or any possible solution, apart from removing and re-installing the WAMPserver. But I did that recently when this problem first occurred (which was right after installing WAMP) and I'd prefer a more permanent fix if this is going to happen repeatedly.

I haven't really had a chance to do anything that might have screwed it up (as far as I know) and I just have a couple of CMS setups installed for testing. They are installed OK and still run OK, though I haven't started using them yet.

[Peartree]

Access denied means quite simply the user root has been disallowed access to the database - normally its if you have the wrong password set. The root user password for MySQL is usually left blank when you use sommet like WAMP.

[Ade]

Thanks for responding. I can see that it might be a password issue, but how can that affect an attempt to view the phpMyAdmin page? And how can it be fixed?

[BenTheDesigner]

Hi Ade

It looks like a password has been set in MySQL for the root user, hence "(using password: NO)". This may not have been changed in your config.inc.php - I've just tried to replicate your problem and it gives me the same error. Do you remember setting a password for root inside PHPMyAdmin? If so, you want to open up config.inc.php and look for:

$cfg['Servers'][$i]['password'] = '';

and set your password between the single quotes that are probably empty.

Let me know how you get on.

BenTheDesigner

[extranetworld]

BenTheDesigner, on 23 September 2009 - 09:44 AM, said:

Hi Ade

It looks like a password has been set in MySQL for the root user, hence "(using password: NO)". This may not have been changed in your config.inc.php - I've just tried to replicate your problem and it gives me the same error. Do you remember setting a password for root inside PHPMyAdmin? If so, you want to open up config.inc.php and look for:

$cfg['Servers'][$i]['password'] = '';

and set your password between the single quotes that are probably empty.

Let me know how you get on.

BenTheDesigner

Create a file named config.inc.php in phpmyadmin. Change blowfish secret, password and auth_type


<?php
// use here a value of your choice
$cfg['blowfish_secret'] = 'ba17c1ec07d61217';

$i = 0;
$i++;

// 'cookie' or 'http'
$cfg['Servers'][$i]['auth_type'] = 'cookie';

// or any existing user, change later to "pma"
$cfg['Servers'][$i]['controluser'] = 'root';

// with proper password
$cfg['Servers'][$i]['controlpass'] = '';
?>


Regards,
Puneet Verma
Extranet World