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

4 votes329 views2 answers
Oracle drop job
SQL
0 vote306 views1 answer
Oracle temporary table
SQL
0 vote292 views1 answer
Use between operator in mysql
SQL
0 vote290 views1 answer
Google cloud sql postgres url example
SQL
5 votes308 views1 answer
Commentaire table oracle
SQL
0 vote347 views1 answer
Pl sql join 3 tables
SQL
3 votes311 views1 answer
Apex set debug level
SQL
0 vote294 views2 answers
Sql server select where date
SQL
0 vote312 views1 answer
Sql server list table sizes
SQL
0 vote334 views1 answer
Hue hive UploadingTextFiletoHive
SQL