Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2016
196
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. mysql -u root -p
  2. Enter password: entered the temporary password here
  3. Welcome to the MySQL monitor. Commands end with ; or g.
  4. .......
  5. mysql> ALTER USER 'mynamehere'@'localhost' IDENTIFIED BY 'mynewpasswordhere';
  6. ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
  7. mysql> UPDATE user SET authentication_string = PASSWORD('mynewpasswordhere'), password_expired = 'that_temporary_password' WHERE User = 'mynamehere';
  8. ERROR 1046 (3D000): No database selected
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement