How to reset mysql root password

Oct 30, 2016

How to reset mysql root password.

Use "mysqladmin" command line tool

$ mysqladmin -u root -pcurrentpassword password 'newpassword'

Login with root user and use update statement

UPDATE user SET password=PASSWORD('newpassword') WHERE user='root';

Use mysql-workbench

• 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

mysql database