mysql alter user identified with code example
Example: alter user mysql native password
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '<password>';
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '<password>';