mysql password change(02/06/20 cudo notes 4)

sudo mysqld_safe --skip-grant-tables

mysql -u root -p

UPDATE mysql.user SET authentication_string=null WHERE User='root';

FLUSH PRIVILEGES;

exit;

mysql -u root

ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourpasswd';