Authentication for MariaDB Enterprise Server
This page is part of MariaDB's MariaDB Documentation.
The parent of this page is: Authentication
Topics on this page:
MariaDB Enterprise Server authentication is performed by database user accounts. Database user accounts are specified by user name, the host name from which the account is connecting, and the authentication plugins configured for the account, such as
The password for a database user account can be changed using the
ALTER USER and
SET PASSWORD statements.
ALTER USER 'USER'@'192.0.2.%' IDENTIFIED BY 'PASSWD';
SET PASSWORD FOR 'USER'@'192.0.2.%' = PASSWORD('PASSWD');
Password Validation Plugins
If your MariaDB Enterprise Server node has a password validation plugin installed, then the password should also meet the configured requirements. When you try to set or change a user's password and the password validation plugin rejects the password, the following error message will be shown:
ERROR HY000: Your password does not satisfy the current policy requirements
By default, MariaDB Enterprise Server installs the simple_
MariaDB Enterprise Server uses authentication plugins to support different authentication methods. The default authentication plugin is