UPDATE user SET password='*C563415623144561...' WHERE user='root';

set password for 'jeff'@'localhost' = PASSWORD('mypass'); // this automatically hashes the password

UPDATE user SET authentication_string='*C563415623144561...' WHERE user='root@localhost';

show variables like '%validate_password%';

set variable_name=new_value;

SET PASSWORD FOR 'user_name' = PASSWORD('new_password');

alter user 'user_name' identified by 'new_password';

The plugin 'auth_socket' used to authenticate user 'root'@'localhost' is not loaded. Nobody can currently login using this account.

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