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 vote282 views1 answer
Oracle sql procedure return value
SQL
0 vote274 views1 answer
How to save data in database in mysql node
SQL
0 vote338 views1 answer
Mysql streaming example
SQL
0 vote290 views1 answer
Oracle list of long running queries
SQL
2 votes291 views1 answer
Oracle percentage
SQL
1 vote297 views1 answer
Search for replace in mysql
SQL
0 vote273 views1 answer
Sql orcale i forgot what my name & password was
SQL
0 vote326 views1 answer
How to locate pg_hba.conf file
SQL
0 vote275 views1 answer
Add column not null with default value postgres
SQL
0 vote319 views1 answer
Sql cursor example multiple columns
SQL