CODE EXAMPLE FOR SQL

how to modify alter user root@localhost identified with mysql_native_password by properly

UPDATE mysql.user SET host='%'
WHERE user='root' AND host='localhost';
FLUSH PRIVILEGES;