MySQL Forums
Forum List  »  Newbie

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 .....

Options: ReplyQuote


Subject
Written By
Posted
Error Number 1045 - I got it to work like this .....
July 13, 2006 11:08AM
March 06, 2007 11:22PM
February 20, 2008 06:17AM
August 04, 2009 09:05PM
December 15, 2005 12:56AM
March 03, 2009 11:07PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.