"Greg Noss" <ss*****@earthlink.net> wrote in message
news:zv****************@newsread2.news.pas.earthli nk.net...
I'm trying to install MySQL. During the security settings portion fo the
setup. I keep getting a Connection Error.
Error Nr. 1045
Access denied for user'root'@'localhost'(using password:YES)
Well, for what it's worth, in that error message, it does not mean that the
root password is literally "YES" -- it means that you did give a password.
In MySQL, it is possible to configure accounts that do not have a password.
It's even possible for the same account to have different privileges
depending on whether you supply a password or not. So in this error, the
fact that you were attempting to supply a password when it failed is
actually a relevant detail (though I have always thought that this error is
confusing for new users).
The first thing I'd check is if the MySQL service is running. You could get
this error in the client if there is no service for the client to talk to.
You can check the service by opening Control Panel -> Administrator Tools ->
Services.
Check the error log for clues. On my Windows machine, the error log is
location in C:\Program Files\MySQL\MySQL 5.0 Server\data\<hostname>.err
(where <hostname> is the name of my Windows machine).
Read the following page for many more tips on resolving "access denied"
errors:
http://dev.mysql.com/doc/refman/5.0/...ss-denied.html
Regards,
Bill K.