CODE EXAMPLE FOR SQL

reset mysql root password using alter user statement

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