This is one of the cases where MySQL documentation doesn't apply directly to MariaDB. No version of MariaDB ever read .mylogin.cnf

On Windows libmariadb reads my.cnf and my.ini in C:\, current directory, %WINDOWS% and %HOMEPATH%.

Thx! Where do I find the docs on this? And in what file do I find the code?
I've now moved the file to "C:\Users\Olaf\my.cnf" but it still seems to be ignored.

https://mariadb.com/kb/en/mariadb/configuring-mariadb-with-mycnf/ — it's about the server, but the client library is using similar rules.

https://github.com/MariaDB/mariadb-connector-c/blob/master/libmariadb/ma_default.c

1. I can't find HOMEPATH @ https://mariadb.com/kb/en/mariadb/configuring-mariadb-with-mycnf/
2. HOMEPATH=\Users\Olaf so I think you need to combine it with HOMEDRIVE.
3. Still doesn't work.

4.
> MariaDB will look in all of the above locations, in order, even if has already found a my.cnf file, and it's possible for more than one my.cnf file to exist.

_mariadb_get_default_file seems to return the first file it finds only.

yes, I've noticed that too, this looked strange to I asked the author for the confirmation. it's MDEV-12965 now.

Thanks, what about the other points?

What I told about paths (including %HOMEPATH%) was, basically, directly copied from ma_default.c.

When MDEV-12965 is fixed, libmariadb should do what https://mariadb.com/kb/en/mariadb/configuring-mariadb-with-mycnf/ says.

But https://mariadb.com/kb/en/mariadb/configuring-mariadb-with-mycnf/ says nothing about HOMEPATH on Windows does it? So IMO that page should be updated as well.
Then there's item 2, which is separate from item 4. And there's item 3.

Yes, I took HOMEPATH from ma_default.c. KB doesn't say anything about HOMEPATH because the server and libmysqlclient don't look there. After MDEV-12965, libmariadb will be doing the same. That is, it will do what KB page says.

It'd actually be nice if the client did, to mimic the behaviour on Linux.
An unprivileged user might not have write access to the other locations.

I can't get this to work.. I've tried both my.cnf and my.ini in c:\ and c:\windows
libmariadb:x86-windows 3.0.2

my.ini:
[client]
host = debian
user = root
password = 123

C:\vc\vcpkg\buildtrees\libmariadb\src\mariadb-connector-c-3.0.2\libmariadb\ma_default.c: 275:
set_option(mysql, "host ", "ebian");

The trailing space and the missing first char are NOT typos..