Reset MySQL root password on Windows

Stop MySQL service
Give user full access to /data folder

Command line:

mysqld --skip-grant-tables
mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('new_password') where USER='root'; 

mysql> FLUSH PRIVILEGES;

HPE advanced CLI

_cmdline-mode on

1910 password: 512900

1920 password: Jinhua1920unauthorized