MySQL said: Documentation #1045 - Access denied for user 'root'@'localhost' (using password: YES)
Posted by: johnno123 (---.lnk.telstra.net)
Date: September 20, 2012 12:05PM

Hi

I've been using Wampserver successfully for a long time now not really knowing how it works ... it just keeps working.

Yesterday noticed that there was an update for PHPmyAdmin so I updated it. After the update it suggested that I should use a root password. I entered one but now I get the following error when I try to access PHPmyAdmin.

MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: YES)
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've been trying all day to solve this unsuccessfully.

Any suggestions please Steve?

Options: ReplyQuote
Re: MySQL said: Documentation #1045 - Access denied for user 'root'@'localhost' (using password: YES)
Posted by: RiggsFolly (---.as13285.net)
Date: September 20, 2012 12:58PM

I assume you added a password to your 'root' user on the mysqlserver using phpMyAdmin.

edit this file

c:\wamp\apps\phpmyadminx.y.x\config.inc.php

Add your new password to

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

and possibly change this from true to
$cfg['Servers'][$i]['AllowNoPassword'] = false;

Options: ReplyQuote
Re: MySQL said: Documentation #1045 - Access denied for user 'root'@'localhost' (using password: YES)
Posted by: johnno123 (---.lnk.telstra.net)
Date: September 20, 2012 01:08PM

Thank you. thank you.

Changing True to False was the solution.

Options: ReplyQuote


Sorry, only registered users may post in this forum.