~/.my.cnf not read in Ubuntu 20.04 and MariaDB 10.3.22
Lentes, Bernd
bernd.lentes at helmholtz-muenchen.de
Tue Sep 8 12:57:51 UTC 2020
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
More information about the ubuntu-users
mailing list