how to create mysql password for old mysql version code example
Example 1: how to change mysql localhost password
ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword'
Example 2: how to change mysql root password in windows 10
ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword';