mysql access with temporary password code example

Example: 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';