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