Skip navigation links

MySQL Forums :: Newbie :: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)


Advanced Search

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Posted by: Andrew Brown ()
Date: October 13, 2011 03:10AM

I have been trying to perform the following command but I get an error:

GRANT ALL PRIVILEGES ON *.* TO 'usernamehere'@'localhost' WITH GRANT OPTION;

error is

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I am doing this via putty directly on the virtual machine logged in as root

I have tried the solution mentioned by others to stop mysql and start it with the skip grant table option, then changing the password, flushing priviledges and restarting mysql. Still same issue.

Any ideas?

Options: ReplyQuote


Subject Written By Posted
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Andrew Brown 10/13/2011 03:10AM
Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Rick James 10/16/2011 11:48AM
Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Jouni Väliaho 11/03/2011 02:10AM
Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) John Eckhardt 12/15/2011 10:22PM
Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Andrew Brown 12/15/2011 10:31PM
Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Howard Walker 12/20/2011 11:00AM
Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Peter Brawley 12/20/2011 11:03AM
Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) RUTENDO KUVAKA 12/18/2011 10:55AM
Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Peter Brawley 12/18/2011 11:10AM


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.