CREATE USER

USAGE

Common syntax:

CREATE USER [IF NOT EXISTS] <user_name> [ @ <host_name> ] [<authentication_option>]

Authentication option:

IDENTIFIED BY '<cleartext_password>'
IDENTIFIED BY PASSWORD '<password_hash>'
IDENTIFIED WITH {mysql_native_password | sha256_password} [{BY | AS} '<cleartext_password>']

DETAILS

MariaDB Xpand's CREATE USER statement has some differences from MariaDB Enterprise Server:

• The REQUIRE clause is not supported

• The following resource limit options are not supported and cause a syntax error to be raised:

  • MAX_QUERIES_PER_HOUR

  • MAX_UPDATES_PER_HOUR

  • MAX_CONNECTIONS_PER_HOUR

  • MAX_USER_CONNECTIONS

CHANGE HISTORY