MySQL Forums
Forum List  »  Newbie

Re: MySQL Error Number 1045 Access denied
Posted by: Eric Voisard
Date: March 05, 2007 09:29AM

> I have "password: =NO" and need to set it to "Yes"

That's what I wanted to do too because this looks being the problem!
I think removing the root password and/or other security features is more a bodge than a clever solution.....

Well, in my case, I just fixed the problem. It was a matter of which config.inc.php was used: for some reason, my phpMyAdmin package (unix) didn't include the setup.php script... My install was running on default values. I found back the config.inc.php and edited the values root/pass, thinking it was enough. But it didn't work and I got the error message until I copied the file in the phpMyAdmin root directory. I realised phpMyAdmin was not taking my values, when I changed 'root' for something random, but the error message was still about 'root@localhost'... duh...

And now I'm getting "password: =YES" (when I put a random username to make the authentication fail). That would mean there is no special setting to obtain YES, exept putting the password in the correct config.inc.php file...

Eric

Options: ReplyQuote


Subject
Written By
Posted
Re: MySQL Error Number 1045 Access denied
March 05, 2007 09:29AM
March 06, 2007 11:22PM
February 20, 2008 06:17AM
August 04, 2009 09:05PM
December 15, 2005 12:56AM
March 03, 2009 11:07PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.