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 votes232 views2 answers
Convert_tz mysql
SQL
0 vote217 views1 answer
Oracle last character of string
SQL
15 votes238 views4 answers
Mysql where value is null
SQL
0 vote230 views1 answer
Import big data to mysql
SQL
0 vote212 views1 answer
How to to get current date and time in sql
SQL
0 vote219 views1 answer
C# datetime to sql server datetime
SQL
0 vote278 views1 answer
Postgres docs /copy metacomand
SQL
0 vote230 views1 answer
Jdbc sql connection string
SQL
2 votes186 views4 answers
Mysql change database character set to utf8mb4
SQL
0 vote241 views1 answer
Sqlalchemy orm duplicate
SQL