Authentication for MariaDB Xpand
This page is part of MariaDB's Documentation.
The parent of this page is: Authentication
Topics on this page:
Overview
MariaDB Xpand 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 method configured for the account.
Change Password
The password for a database user account can be changed using the ALTER USER and SET PASSWORD statements.
With ALTER USER:
ALTER USER 'USER'@'192.0.2.%'
IDENTIFIED BY 'PASSWD';
With SET PASSWORD:
SET PASSWORD FOR 'USER'@'192.0.2.%'
= PASSWORD('PASSWD');
Authentication Methods
MariaDB Xpand supports a couple different authentication methods. The default authentication plugin is mysql_native_password.
Password Expiration
Xpand 6 supports password expiration.
For additional information, see "Password Expiration for MariaDB Xpand".
Password Validation
Xpand 6 supports can enforce password requirements with simple_password_check.
For additional information, see "Password Validation with simple_password_check for MariaDB Xpand".