How to reset mysql root password.
Use “mysqladmin” command line tool
Login with root user and use update statement
- First login to mysql db with mysql-workbench
- Go to “Management” tab
- Select “Users and Privileges”
- Select “root” user and set password at “login” tab