Authentication with mysql_native_password for MariaDB Xpand

Overview

For MariaDB Xpand, mysql_native_password is the default authentication method.

Compatibility

  • MariaDB Xpand 5.3

  • MariaDB Xpand 6.0

  • MariaDB Xpand 6.1

Create

To create a database user account that uses the mysql_native_password authentication method, the method can be omitted in the CREATE USER statement:

CREATE USER 'USER'@'192.0.2.%'
   IDENTIFIED BY 'PASSWD';

Switch to mysql_native_password

If a database user account is configured to use the sha256_password authentication method, the ALTER USER statement can switch the user account to the mysql_native_password authentication method:

ALTER USER 'USER'@'192.0.2.%'
   IDENTIFIED WITH mysql_native_password BY 'PASSWD';