how to reset the password for the root account in mysql code example
Example: how to change mysql localhost password
ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword'
ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword'