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 vote185 views1 answer
How to set all the min and sec data to zero in sql server
SQL
28 votes182 views4 answers
Show tables mysql
SQL
0 vote179 views1 answer
Suse status MySQL
SQL
0 vote172 views1 answer
Deny select insert update delete sql
SQL
19 votes185 views6 answers
Laravel sql query
SQL
5 votes185 views1 answer
Commentaire table oracle
SQL
1 vote191 views1 answer
Clear screen command in psql
SQL
0 vote199 views1 answer
Mysql get nth highest
SQL
1 vote152 views1 answer
Unique vs distinct sql
SQL
0 vote204 views1 answer
This week mysql
SQL