Re: Error Number 1045 - I got it to work like this .....
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.
Subject
Written By
Posted
December 29, 2004 08:39PM
December 22, 2009 04:23AM
February 07, 2005 10:11AM
September 06, 2007 11:06PM
September 30, 2007 02:35PM
February 28, 2007 11:03AM
September 23, 2006 05:45PM
November 07, 2007 11:41PM
February 07, 2006 06:09AM
February 28, 2007 11:05AM
November 30, 2008 11:32PM
February 10, 2009 10:49AM
November 03, 2009 07:36AM
September 16, 2005 04:54PM
December 31, 2006 03:51PM
February 10, 2007 08:02AM
November 13, 2005 11:05AM
December 23, 2005 06:15PM
February 16, 2006 09:07PM
Re: Error Number 1045 - I got it to work like this .....
March 09, 2008 07:53AM
February 28, 2007 11:27AM
February 20, 2008 06:17AM
September 20, 2007 07:50AM
November 11, 2005 01:19PM
December 13, 2005 02:42PM
December 15, 2005 12:56AM
February 17, 2007 11:07AM
September 03, 2007 02:40PM
September 07, 2007 10:42AM
February 13, 2009 04:29PM
September 11, 2009 08:24AM
September 19, 2009 08:54AM
December 16, 2009 03:44AM
December 22, 2009 04:21AM
December 22, 2009 01:49PM