Mysql identified by syntax error

# 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'@'%';

Similar codes

0 vote343 views1 answer
Utiliser sql ligne de commande
SQL
0 vote344 views1 answer
How to drop a trigger in postgresql
SQL
4 votes359 views3 answers
Sql drop primary key
SQL
2 votes385 views1 answer
Oracle Column Names of a table
SQL
0 vote310 views1 answer
Plsql trigger insert update
SQL
3 votes356 views1 answer
Oracle drop user
SQL
2 votes333 views2 answers
Postgres set user as superuser
SQL
0 vote359 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote355 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
0 vote368 views2 answers
Sql having multiple conditions
SQL