MySQL update password for root user

MySQL update password for root user

Go to mysql

sudo mysql -u root -p

Update password for root user

USE mysql;

UPDATE user SET authentication_string=PASSWORD("jundat95") WHERE User='root';

UPDATE user SET plugin="mysql_native_password" WHERE User='root';

quit;  

Kill mysqld


sudo pkill mysqld


Restart MySQL Service


sudo service mysql restart

Go to MySQL with password


sudo mysql -u root -p

Enter password

Thanks