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

3 votes210 views1 answer
Sql multi column index performance
SQL
8 votes214 views10 answers
Sql
SQL
0 vote204 views1 answer
Print mysql
SQL
4 votes219 views3 answers
Rename table column postgresql
SQL
2 votes227 views1 answer
Power query concatenate
SQL
0 vote206 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
1 vote209 views2 answers
Mysql update LAST_INSERT_ID()
SQL
-1 vote295 views5 answers
Left join
SQL
0 vote234 views1 answer
Mysql error codeigniter
SQL
2 votes233 views1 answer
Python sql
SQL