mysql ERROR 1064 (42000): You have an error in your SQL syntax;

You don’t use IDENTIFIED BY in GRANT queries, it’s used in CREATE USER.

CREATE USER 'root'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';

GRANT command reference

CREATE USER command reference