|
Home > Archive > MySQL Server Forum > June 2005 > MySQL Setup Error
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| slush@albertaimit.ca 2005-06-14, 8:23 pm |
| 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
| |
| Bill Karwin 2005-06-14, 8:23 pm |
| slush@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.
| |
|
| 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 <bill@karwin.com>
wrote:
>slush@albertaimit.ca wrote:
>
>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.
|
|
|
|
|