-
Type:
Bug
-
Status: Open (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 10.2, 10.3, 10.4
-
Component/s: Authentication and Privilege System, Documentation
-
Labels:None
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.