Starting with MariaDB 10.4 (released in June 2019), you can use the OR keyword with IDENTIFIED VIA to allow any-of several authentication methods:

	IDENTIFIED VIA unix_socket 
	            OR mysql_native_password USING PASSWORD("s3cr3tpasswvrd");

Even if your OS vendor kinda sucks at providing updates, MariaDB provides an official repository serving at least this version to distributions as old as Ubuntu 14.04, CentOS & RHEL 6, Debian 7, and Fedora 28 (all of which are already EOL), as well as up to current releases of each; this is by no means a "new, shiny, unsupported syntax feature". (For some of these [e.g. Fedora < 32], the URL isn't publicly listed, but it still exists.)

Leave a Reply

Your email address will not be published. Required fields are marked *

Warning: This site uses Akismet to filter spam. Until or unless I can find a suitable replacement anti-spam solution, this means that (per their indemnification document) all commenters' IP addresses will be sent to Automattic, Inc., who may choose to share such with 3rd parties.
If this is unacceptable to you, I highly recommend using an anonymous proxy or public Wi-Fi connection when commenting.