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 vote261 views1 answer
Authentication modes in sql server
SQL
2 votes236 views1 answer
Sql ends with string
SQL
2 votes243 views1 answer
Mysql last 7 days including today
SQL
1 vote244 views1 answer
T-sql find object by name
SQL
2 votes237 views2 answers
Mysql alter column default
SQL
3 votes229 views1 answer
MySQL DELETE JOIN
SQL
13 votes241 views4 answers
Mysql select last 10 rows
SQL
0 vote229 views1 answer
The local psql command could not be located
SQL
31 votes242 views4 answers
How to get duplicate records with multiple field in sql
SQL
11 votes243 views1 answer
Get ddl materialized view oracle
SQL