use mysql;
update user set authentication_string=PASSWORD("newpassword") where User='root';
update user set plugin="mysql_native_password";
flush privileges;
use mysql;
update user set authentication_string=PASSWORD("newpassword") where User='root';
update user set plugin="mysql_native_password";
flush privileges;