Re: Error Number 1045 - I got it to work like this .....

[Magick Childe]

glyn Wrote:
-------------------------------------------------------
> sorry folks, this requires running up a command
> window, but it's not too complicated .... anyway
> ...
>
> run up a cmd window - (click start, click run,
> type cmd)
> I then started mysql as root, *WITHOUT* a
> password, as so ....
>
>
>
> mysql -u root (I was suprised this worked, but it
> did)
>
> then at the mysql prompt ...
>
> GRANT ALL ON *.* to root@localhost IDENTIFIED BY
> 'rootpwd';

I have tried this however this is all I got ( no surprise)
C:\Program Files\MySQL\MySQL Server 5\bin>mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: N
O)

Does anyone have a solution for this???? I have already spent the past 3 hours uninstalling and reinstalling and reading through this forum looking for an answer.