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

13 votes147 views2 answers
Sql join 3 tables
SQL
0 vote134 views1 answer
Insufficient memory to excute the sql query
SQL
1 vote135 views1 answer
Drop function
SQL
0 vote136 views1 answer
Why mysql is used?
SQL
0 vote131 views1 answer
Best sql collation
SQL
0 vote134 views1 answer
Sql select with apostrohpe
SQL
0 vote147 views1 answer
Template MySQL Zabbix agent
SQL
-1 vote143 views2 answers
Installing mysql on centos 7
SQL
0 vote128 views1 answer
Mysql set column equal to another automatic
SQL
0 vote152 views1 answer
Default password for mysql_secure_installation in mac
SQL