469,267 Members | 979 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,267 developers. It's quick & easy.

MySQL Setup Error

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.

RB
Jul 23 '05 #1
2 1232
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.
Jul 23 '05 #2
RB
Thanks for the help, that was exactly the problem and now everything
is working fine.

On Tue, 14 Jun 2005 16:11:49 -0700, Bill Karwin <bi**@karwin.com>
wrote:
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.


Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by dave | last post: by
14 posts views Thread by KnockKnock | last post: by
reply views Thread by Lenz Grimmer | last post: by
3 posts views Thread by Mark Adams | last post: by
4 posts views Thread by ImOk | last post: by
1 post views Thread by Steve Ametjan | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.