sl***@albertaimit.ca wrote:
While installing mysql server on a windows 2000 machine without a
firewall, I get an error numbered 1045. Access is denied for user
'root'@'localhost' (using password: NO). If anyone has any ideas of
how to solve it, it would be much appreciated.
Here's my educated guess:
Recent versions of the MySQL Windows installer encourage the user to
specify a root password to use for local access. This is a good policy.
So this means you can't connect to MySQL locally without specifying a
password (that's what "using password: NO" means). Whomever installed
MySQL chose a root password, and you aren't using that password.
Regards,
Bill K.