On Sun, 26 Nov 2017 16:35:24 +0100 Ulf Volmer <u.vol...@u-v.de> wrote:
> On 26.11.2017 15:57, Rainer Dorsch wrote: > > > mysqladmin: connect to server at 'localhost' failed > > error: 'Access denied for user 'root'@'localhost' (using password: > > NO)' error: error running shared postrotate script for > > '/var/log/mysql/mysql.log / > > var/log/mysql/mysql-slow.log /var/log/mysql/mariadb-slow.log /var/log/mysql/ > > error.log ' > > did you have manual changes in /etc/logrotate.d/mysql-server or > /etc/mysql/debian.cnf? in the last file you will find the credentials > for the user debian-sys-maint who is used for maintenance tasks. > > i'm surprised that in the error message above the root user is used. > That may suggest a mismatch of versions: the logrotate script uses the mysqladmin --defaults-file option, which specifies debian-sys-maint in the /etc/mysql/debian.cnf file. Old versions of mysqladmin don't have the --defaults-file option defined, so may be looking for the root user. A check of man mysqladmin on the offending machine should confirm whether the options include --defaults-file. It does on my old mysql-client 5.5.58 installation and my shiny new mariadb-client 10.0.28 but does not on a mysql 5.5 man page found on the Net, and may not be in an early mariadb client, I don't know. -- Joe
