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

2 votes108 views1 answer
How to search table name in stored procedure in sql server
SQL
18 votes104 views4 answers
Foreign key mySql
SQL
0 vote117 views1 answer
Mysql check if lowercase
SQL
0 vote145 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
0 vote102 views1 answer
Flask sqlalchemy update row
SQL
0 vote132 views1 answer
Sql tablo sp
SQL
2 votes113 views3 answers
Copy data from one table column to another table column in sql
SQL
9 votes108 views2 answers
Sql limit order by
SQL
0 vote357 views1 answer
How to connect .sql data set to powerbi
SQL
0 vote112 views1 answer
Initcap in mysql
SQL