Comments - mysql_config_editor compatibility

No, MariaDB doesn't support this feature. Because line of reasoning is, mysql_config_editor doesn't encrypt, but only obfuscates passwords, that might create a false sense of security. Better to put password in a separate file, give appropriate permission to that file so it can be accessible only by the specific user and use--defaults-extra-file option to use it with client. Check here for explanation by MariaDB here : https://jira.mariadb.org/browse/MDEV-20665

i.e

You can create a new options file in your home directory, readable only by you, like this:

vi .my.cnf OR vi .user.cnf

[client] host='<your-db-host>' port='<your-db-port>' socket='<your-db-socket>' database='<your-db-name>' user='<your-db-user>' password='<your-db-password>'

You can then use with a --defaults-extra-file= option when running one of the clients.

mysql --defaults-extra-file=.user.cnf

You can create different config files for each login path you would have created. https://mariadb.com/kb/en/configuring-mariadb-with-option-files/

Connection details should be like this in .cnf file.

[client] 
host='<your-db-host>' 
port='<your-db-port>' 
socket='<your-db-socket>' 
database='<your-db-name>' 
user='<your-db-user>' 
password='<your-db-password>'