The Ultimate Guide to High Availability with MariaDB

Comments - Authentication from MariaDB 10.4

 
3 years, 10 months ago Basil Hendroff
Re: Authentication from MariaDB 10.4

Is there a test from the command line to determine which authentication method(s) are active?

 
4 years, 3 months ago Testing User A Test
Re: Authentication from MariaDB 10.4

May I use the following to disable unix_socket authentication?

[mysqld] unix_socket=OFF

Does it do any harm to other db functions, or only affect CLI login authentication?

 
4 years, 3 months ago Sergei Golubchik
Re: Authentication from MariaDB 10.4

It will disable a plugin. Any user accounts that are configured to use *only* unix_socket authentication will not be able to login anymore.

If an account uses unix_socket OR mysql_native_password as in the examples above, the password will still work.

 
4 years, 11 months ago Wagner Bianchi
Authentication from MariaDB 10.4

Sergei gives a little bit more details on the below blog post about using more than one authentication plugin for users (root is created with two plugins): https://mariadb.org/authentication-in-mariadb-10-4/

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.