MySQL Forums
Forum List  »  Install & Repo

(Solved) Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO)
Posted by: Vadim Z
Date: April 22, 2009 06:24PM

Had the same error... Turned out that some internal SQL Table (grant tables) had not been initialized, so SQL Server had no account and only accepted connections as root with no (empty) password, but GUI config was trying to send PW to SQL server.
So try to set up root password in CLI first as root. Connect to SQL as root with blank PW, use SET command, and then re-run GUI config again with the new password. Should work.

To use SET 'root' PASSWORD on Windows, do this in CMD terminal:

1. check that SQL is running. (Can use "services" in Windows to check status, or just try to telnet on port 3306 from CMD if will get any prompt. c:\\ telnet localhost 3306)

2. Then:

c:\\.....> mysql -u root
mysql> SET PASSWORD FOR root@'localhost' = PASSWORD('newpwd');

(see http://dev.mysql.com/doc/refman/5.1/en/default-privileges.html for more details)



Edited 2 time(s). Last edit at 04/22/2009 06:32PM by Vadim Z.

Options: ReplyQuote


Subject
Written By
Posted
August 23, 2010 05:37AM
October 08, 2010 02:25PM
(Solved) Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO)
April 22, 2009 06:24PM
October 15, 2011 11:03PM


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.