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

16 votes185 views4 answers
Ascending order mysql
SQL
0 vote186 views1 answer
Array aggre distinct postgres
SQL
0 vote178 views1 answer
Postgresql parse json array
SQL
0 vote178 views1 answer
Sql trim whitespace
SQL
0 vote209 views2 answers
Identity syntax in sql
SQL
2 votes192 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
4 votes223 views1 answer
Mysql delete last row
SQL
0 vote213 views1 answer
Oracle enable chain
SQL
1 vote184 views1 answer
Update from table tsql
SQL
7 votes190 views1 answer
Connect mysql docker
SQL