how to restore admin rights to root mysql 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';
Example 3: how to change mysql root password in windows 10
ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword';