MySQL Change password on Ubuntu when default password not provided

Mysql Change password.md

MySQL Change password on Ubuntu when default password not provided

1. Open terminal and tyfollowing commands one by one. Do not close the terminal after you are done

sudo mysql
USE mysql;
UPDATE user SET authentication_string=PASSWORD('YOUR_PASSWORD') WHERE User='root';
UPDATE user SET plugin="mysql_native_password";
FLUSH PRIVILEGES;
quit;

2. Open new terminal and try to login with the following commad

mysql -u root -p
<Enter your new password>

3. If step 2 does not work, redo step1 on terminal1