Error Number 1045 - I got it to work like this .....
Posted by:
glyn
Date: July 13, 2006 11:08AM
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';
obviously, enter your root password and not 'rootpwd'
don't ask me how this works, it seems to be letting me into mysql as root without a password, then requiring the password to run the operation, when it wouldn't let me into mysql as root with the password, but heh ... it did work.
I can now run MySQL Administrator and hopefully take it from there
hope this helps - I really don't think we should have to be hitting command lines in this day and age .....
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
Error Number 1045 - I got it to work like this .....
July 13, 2006 11:08AM
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