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 vote292 views1 answer
Sql from null to not null
SQL
3 votes312 views2 answers
Truncate all tables
SQL
13 votes369 views3 answers
Mysqldump structure only
SQL
-2 votes312 views1 answer
Remove root password mysql
SQL
0 vote416 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
9 votes304 views2 answers
Mysql change value
SQL
2 votes338 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
13 votes330 views2 answers
Sql join 3 tables
SQL
0 vote302 views1 answer
Sql gap missing values
SQL
22 votes333 views4 answers
Mysql date_format
SQL