mysql accounts and roles current root password code example
Example 1: how to change mysql localhost password
ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword'
Example 2: where to locate set password for mysql
ALTER USER 'root'@'localhost' IDENTIFIED BY 'PASSWORD';