How create user with authentication plugin 'mysql_native_password' MariaDB server v10.3

Question

I want to create a new user in Azure MariaDB Server version 10.3 using the mysql_native_password authentication plugin, following the commands from the documentation:

CREATE USER 'test'@'%' IDENTIFIED WITH mysql_native_password USING 'test_password';

or

CREATE USER 'test'@'%' IDENTIFIED VIA mysql_native_password AS 'test_password';

However, the mysql_native_password plugin is not being applied. Is there a way to create a user with the mysql_native_password authentication plugin in Azure MariaDB Server?

Answer 1

HI @ Sniazhkou, Anton

Azure Database for MariaDB does not support configuring or changing the authentication plugin, such as mysql_native_password. This is by design in the managed Azure service to ensure security and compatibility. Even though the CREATE USER syntax with IDENTIFIED WITH/VIA may be valid in standard MariaDB, it is not supported on Azure’s platform. Instead, users should be created using the default method:

CREATE USER 'username'@'%' IDENTIFIED BY 'YourStrongPassword';

This automatically uses Azure’s secure built-in authentication method. There is no need to manually specify a plugin, and doing so will have no effect. If your application requires support for specific authentication plugins, you may consider using Azure Database for MySQL, which supports more flexible authentication configurations.

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.