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';
>>>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:


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

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