```
use mysql;

UPDATE user SET authentication_string=PASSWORD("securepassword") where User='root';

UPDATE user SET plugin="mysql_native_password";

FLUSH PRIVILEGES;

quit;
```