|
Documentation for ALTER USER says
ALTER USER [IF EXISTS]
|
user_specification [,user_specification] ...
|
[REQUIRE {NONE | tls_option [[AND] tls_option] ...}]
|
[WITH resource_option [resource_option] ...]
|
and even explains what effect IF EXISTS is supposed to have. Only the syntax does not work:
MariaDB [test]> CREATE USER foo@bar;
|
Query OK, 0 rows affected (0.09 sec)
|
|
MariaDB [test]> ALTER USER IF EXISTS foo@bar REQUIRE SSL;
|
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 'IF EXISTS foo@bar REQUIRE SSL' at line 1
|
I'm not sure if it's an omission in the code or a mistake in documentation.
|