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

5 votes292 views5 answers
Sqlite install python
SQL
1 vote302 views1 answer
Group_concat order by
SQL
51 votes470 views6 answers
Opera gx
SQL
0 vote292 views1 answer
QCompleter con sql
SQL
0 vote277 views1 answer
Oracle exchange partition
SQL
53 votes547 views6 answers
How to install mysql ubuntu
SQL
5 votes264 views1 answer
Migrate sql table another database
SQL
0 vote296 views1 answer
Mysql best varchar length size
SQL
0 vote258 views1 answer
How to insert same table data using mysql query
SQL
0 vote292 views1 answer
Sqlalchemy orm duplicate
SQL