Change MySQL 5.7 Password and Server authentication plugin for root user

query.sql

SELECT user,authentication_string,plugin,host FROM mysql.user;
UPDATE mysql.user SET plugin = 'mysql_native_password', authentication_string = PASSWORD('mypassword') WHERE User = 'root';
FLUSH PRIVILEGES;