new password system mysql code example

Example 1: how to change mysql localhost password

ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword'

Example 2: alter user root mysql

ALTER USER 'root'@'localhost' IDENTIFIED BY 'newPassword';