MySQL Forums
Forum List  »  Install & Repo

Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Posted by: asfd asdf
Date: September 18, 2008 10:13AM

This may help some of you.

I stopped the mysqld daemon.

I navigated to the directory where my MySQL databases were stored:

/var/lib/mysql/mysql

I renamed the directory holding the DB's to mysql_old

/var/lib/mysql/mysql_old

I restarted the mysqld daemon.

Voila! I issued the mysql command and got right to a mysql> prompt

Options: ReplyQuote


Subject
Written By
Posted
June 27, 2009 08:29PM
December 16, 2007 02:18AM
December 27, 2007 02:08PM
January 16, 2011 06:51AM
Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
September 18, 2008 10:13AM
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.