MySQL refuses connection from phpMyAdmin

[shadow123763]

I cannot access phpMyAdmin it comes up with this....


Welcome to phpMyAdmin 2.10.1

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

Error
MySQL said:

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


How do I fix this problem (plz note im new so try to be as less complicated with the answer)

[Atli]

Hi Shadow. Welcome to The Scripts!

You have posted your question in the Articles section rather than the Forum section.
I have moved it across for you.

Also, I've changed the title of this thread to better describe it's topic.
Using good, descriptive titles that follow the Posting Guidelines will increase your chances of getting you questions answered!

Moderator

[Atli]

This means that MySQL rejected the user information phpMyAdmin used to connect to it.

You will have to insert the correct information. The info should be put inside the config.inc file in the directory phpMyAdmin is located, like the error says.

[shadow123763]

Sorry as i said I am new and I still dont get it I found config.inc but how do i edit it? And what do I change?


All your help very much appreicated.

=]

[Atli]

You need to open the file using notepad, or something similar.
Then you need to locate this line:

$cfg['Servers'][$i]['auth_type'] = 'config';
 

You can set this to 'http', in which case it asks you for your MySQL user information every time you open phpMyAdmin.

You can also set this to 'config'. This is more convenient because phpMyAdmin will never ask you for you user info if this is set correctly. Although, if you do this anybody can use phpMyAdmin without entering any user info.

To set this you need to put the MySQL user information into the file.
That would look something like this:

$cfg['Servers'][$i]['user'] = 'phpmyadminuser';
$cfg['Servers'][$i]['password'] = 'the_password';
 

If these lines don't exists, you can create them.