CREATE USER .. IDENTIFIED WITH .. BY .. is not supported

CREATE USER ... IDENTIFIED WITH ... BY ...

MariaDB [test]> create user foo@localhost identified with 'auth_socket' by 'abc';

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'by 'abc'' at line 1

MariaDB [test]> select @@version;

+----------------------+

| @@version            |

+----------------------+

| 10.2.3-MariaDB-debug |

+----------------------+

1 row in set (0.00 sec)

MySQL [test]> create user foo@localhost identified with 'auth_socket' by 'abc';Query OK, 0 rows affected (0.00 sec)

MySQL [test]> select @@version;

+--------------+

| @@version    |

+--------------+

| 5.7.16-debug |

+--------------+

1 row in set (0.00 sec)