~/.my.cnf not read in Ubuntu 20.04 and MariaDB 10.3.22

[Lentes, Bernd]

Hi,

i want to edit a .my.cnf file in /root for dumping the database with cron and not being
asked for user and password.
For that i need a user and a password entry in /root/.my.cnf
That's what i have:

[client]
user=root
password=**********

But it seems that mysql does not read the file.
mysql --help shows that the cnf files should be read:
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Usage: mysql [OPTIONS] [database]

Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf  <===============

But when i start mysql i'm still asked for user and password.
And "stat" shows that the .my.cnf has not been touched.
I mounted that partition with strictatime so each read should update the time of an access.

Any ideas ?

Thanks.

Bernd

-- 

Bernd Lentes 
Systemadministration 
Institute for Metabolism and Cell Death (MCD) 
Building 25 - office 122 
HelmholtzZentrum München 
bernd.lentes at helmholtz-muenchen.de 
phone: +49 89 3187 1241 
phone: +49 89 3187 3827 
fax: +49 89 3187 2294 
http://www.helmholtz-muenchen.de/mcd 

stay healthy
Helmholtz Zentrum München

Helmholtz Zentrum München