SQL

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

DELETE FROM mysql.user WHERE user='root' AND host='localhost';
FLUSH PRIVILEGES;

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

GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.1.2.%'
IDENTIFIED BY PASSWORD '*fdfgdgdggfggfgfg' WITH GRANT OPTION;

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;