MySQL Forums
Forum List  »  Newbie

Can't reset password
Posted by: Corey Woodfield
Date: February 01, 2016 04:06PM

Hi, I'm trying to learn SQL, and I was able to install and get a server running, but it won't let me do anything until I reset my password (it says "must reset password with ALTER USER before performing this). I tried to use ALTER USER to reset my password, and it gave me the same message, basically that I can't reset my password until I reset my password. Following is the exact text:

mysql> ALTER USER root IDENTIFIED BY 'newpassword';
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

So my question is, am I doing something wrong? How am I supposed to change the password? If it's important, I'm using a mac.

Options: ReplyQuote


Subject
Written By
Posted
Can't reset password
February 01, 2016 04:06PM


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.