introduction screenshots faq forum blog modules components download
Please use the search function and/or read the FAQ first.

Go to Topic: PreviousNext
Go to: Message ListNew TopicSearchLog InPrint View

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



Posted by: aj
June 02, 2010 06:10AM
I installed EasyPHP today and saw a message telling me to change my root password.
As soon as I did, I now get the message:

#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 have tried uninstalling, removing all registry entries, etc. but this problem still persists even with a fresh reinstall. Modifying config.inc.php does not help.

Any help would be much appreciated.
AJ
Options: ReplyQuote
Posted by: mcduff21543
June 02, 2010 06:58AM
Take a look at my thread (posts) about the same thing. "Root Password" If any of it helps you good, if not keep waiting like me. If you find the answer before me PLEASE let me know.

I did the same thing you did but it took me 3 years to finally decide to change the password while I was updating easyPHP, curse you mySQL for suggesting changing the password for 'root'.

The only thing I didn't do is remove the registry entries because I don't know where they are, a link to the info would be appreciated. I was also thinking it might be stored somewhere in the C://WINDOWS folder but couldn’t find anything with my limited knowledge of said folder.
Options: ReplyQuote
Posted by: AJ
June 02, 2010 09:27AM
I now get the message "Enexpected end of Apache" and the whole thing doesn't even start up. I might try an older, hopefully more stable build of this package, but I will probably just move to a non-shit one instead. At this point I would also accept instructions on how to remove this crap permanently from my computer so I can attempt to install something else.

@mcduff: I just searched the registry for EasyPHP and deleted everything I found. To access the registry just go to Start->Run and type "regedit" without the quotes and click OK.
Options: ReplyQuote
Posted by: AJ
June 03, 2010 02:17AM
Well, this isn't going to help anyone, but all of a sudden everything started working again. Both Apache and phpMyAdmin work, and it accepts my new password without any problems. Let's hope it lasts.
Options: ReplyQuote
Posted by: mcduff21543
June 03, 2010 03:26AM
What did you do, you had to have done something for it to start working right.
Options: ReplyQuote
Posted by: AJ
June 03, 2010 08:40AM
To fix my Apache problem I followed the advice of another thread in this forum:

Go to the apache configuration file by right clicking the icon and selecting it.
Change 'listen 127.0.0.1:80'
to 'listen 127.0.0.1:8080'
save it and restart apache.

After that it worked. I didn't touch anything else, my computer hasn't even been restarted since this whole thing began.

Once I was able to access PhpMyAdmin again, I once again attempted to change the password and this time I was able to do so with no problems. I'm sorry I can't be of more help; I'm as surprised as you are that this problem fixed itself while I was sleeping.
Options: ReplyQuote
Posted by: Thierry
June 03, 2010 10:32AM
You probably have another WAMP running.
Options: ReplyQuote
Posted by: calculus
June 24, 2010 01:33AM
An "aha" moment, and a solution...or at least something that worked for me. I had this mystery and found out what was going on after hours of frustration...changing config files only to find no changes reflected...uninstalling and reinstalling only to find the problem persisted. The problem began, unknown to me and perhaps to many others, because I installed to C:\program files. Microsoft doesn't like applications to be installed with user configurable files in the same directory as the program, and especially not in the c:\program files folder. Therefore, without telling you, Bill creates a new directory tree called "virtual store", which is pretty hard to find. There you'll find your whole installation mirrored, and the config files which do not get cleaned out on reinstallation. Also, the config files you think you change in c:\program files\easyPhp are not even looked at by Windows as it's looking in virtual store at the hard-to-find mirror copies of your config files, which of course you have no idea exist. Google "windows virtual store" for lively debate for and against application writers who choose to write software with user-configurable files in the same directory. Microsoft claims to have been telling writers not to do this for ten years or more.

Solution that worked for me, assuming you installed in c:\program files:
Uninstall easyPhp. If you have any databases or websites, the uninstall will leave these. So after installation, look in your easyPhp\mysql folder for any of your databases and move them somewhere else safely, look also in your easyPhp\www folder and move them out safely. Keep anything else you changed. Then delete the easyPhp folder so nothing remains in c:\program files. Then find your virtual store directory with the mirrored installation of parts of easyPhp and look for any content that was created by your activities while you used easyPhp (for example, "lost" files that your php code wrote to your www directory may be there, too). Once you have moved or copied any file you need, then delete the easyPhp directory tree entirely from virtual store.

Specify a different directory for the fresh installation (something other than c:\program files). I used d:\program files location, but I think any folder other than c:\program files may work OK (perhaps someone more knowledgeable about virtual store can verify that, as I'm only guessing).

Everything worked like a dream after that. Big thanks to Thierry and his two colleagues for a great program suite easyPhp.
Options: ReplyQuote
Posted by: Thierry
June 25, 2010 12:12PM
Thanks a lot for your feedback. I begin to understand the problem, probably linked to UAC and ACL on program files directory.
Options: ReplyQuote
Posted by: mcduff21543
June 04, 2010 12:37AM
Don't ask me why this worked but it worked for me too.

Go to the apache configuration file by right clicking the icon and selecting it.
Change 'listen 127.0.0.1:80'
to 'listen 127.0.0.1:8080'
save it and restart apache.
Options: ReplyQuote
Posted by: Selassie
July 19, 2010 05:50PM
Same problem and same solution.
Don't know why but it works.
Thanks so much 'cause I wouldn't have found without you.
Options: ReplyQuote
Posted by: cayriel
July 24, 2010 08:49PM
ACCESS DENY FOR USER ROOT AND TRY TO FIX
Options: ReplyQuote
Posted by: parthiban
July 19, 2010 07:08PM
pls help to solve the problem
Options: ReplyQuote


Go to: Message ListSearchLog In
Your Name: 
Your Email: 
Subject: 
Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.