MySQL Forums
Forum List  »  Install & Repo

Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Posted by: congthanhgiong
Date: June 03, 2006 03:41AM


I have the same problem, i have tried the following >10 times


mysqld-nt --skip-grant-tables
update mysql.user set password=password('mypass') where user='root';
>> Query 0 rows affected ??? why no records are affted
flush privileges;

nothing works for me, what am i supposed to do now? don't know why mysql manages account so badly, many people have the same problem.

Edited 1 time(s). Last edit at 06/03/2006 03:42AM by congthanhgiong.

Options: ReplyQuote

Written By
June 27, 2009 08:29PM
December 16, 2007 02:18AM
Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
June 03, 2006 03:41AM
December 27, 2007 02:08PM
January 16, 2011 06:51AM
August 27, 2009 12:22AM

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.