MySQL Forums
Forum List  »  Newbie

set root password. now locked out.
Posted by: Stephen Richter
Date: January 21, 2017 10:18AM

I ran mysqladmin to set the root password. Since then I am locked out of MYSQL. What to do?

here is what I did. I am expecting to be prompted for the root password. But I do not get prompted. Only the message "access denied".

thanks,


mysqladmin -u root password steve ;
#
mysql -u root -p
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password
: NO)
#
mysql -u root -p steve
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password
: NO)
#
mysqladmin -u root password "steve" ;
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
#

Options: ReplyQuote


Subject
Written By
Posted
set root password. now locked out.
January 21, 2017 10:18AM


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.