how to grab temp passwor dmysql code example

Example 1: how to enable mysql 5.7 root user password on linux

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'SOME_NEW_ROOT_PASSWORD';

Example 2: 2020-07-12T22:14:08.819617Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: sYotK!Dzg8uk

UPDATE user SET authentication_string = PASSWORD('YourNewPassword'), password_expired = 'N' WHERE User = 'root';