MySQL Forums
Forum List  »  Install & Repo

Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Posted by: risanecek
Date: November 18, 2005 08:29AM

>>># mysql -u root mysql
>>>mysql> UPDATE user SET Password=PASSWORD('your_new_password') where USER='root';
>>>mysql> FLUSH PRIVILEGES;
>>>
>>>Finally, restart the instance/daemon without the --skip-grant-tables option.

Doesn't work.

051118 14:20:48 [Warning] mysql.user table is not updated to new password format; Disabling new password usage until mysql_fix_privilege_tables is run

Then I try to run mysql_fix_privilege_tables:

BOOM!

mysql_fix_privilege_tables
This script updates all the mysql privilege tables to be usable by
MySQL 4.0 and above.

This is needed if you want to use the new GRANT functions,
CREATE AGGREGATE FUNCTION, or the more secure passwords in 4.1

Got a failure from command:
/usr/bin/mysql --no-defaults --force --user=root --host=localhost --database=mysql
Please check the above output and try again.

Running the script with the --verbose option may give you some information
of what went wrong.

If you get an 'Access denied' error, you should run this script again and
give the MySQL root user password as an argument with the --password= option

---

Very funny.

Options: ReplyQuote


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