Authentication with mysql_native_password

Overview

The mysql_native_password authentication plugin is the default authentication plugin for MariaDB Enterprise Server.

Create User

To create a user account that uses the ed25519 authentication plugin, the plugin can be omitted from the CREATE USER statement:

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