Here are quick steps to reset mysql root password in Ubuntu
1. Stop the mysql service instance by
1 | sudo service mysql stop |
2. Start mysqld daemon
1 2 | sudo mkdir -v /var/run/mysqld && sudo chown mysql /var/run/mysqld sudo mysqld –skip-grant-tables & |
3. Login as root
1 2 3 | mysql -u root UPDATE mysql.user SET authentication_string=PASSWORD(‘YOURPASSWORD’), plugin=’mysql_native_password’ WHERE User=’root’ AND Host=’localhost’; FLUSH PRIVILEGES; |
4. Kill the service and start
1 2 | sudo killall -9 mysqld sudo service mysql start |
Done, now you can login with a new password as root