Re: error: 'Access denied for user 'root'@'localhost' (using password: NO)'

From	Joe <joe@jretrading.com>
Newsgroups	linux.debian.user
Subject	Re: error: 'Access denied for user 'root'@'localhost' (using password: NO)'
Date	2017-11-26 18:10 +0100
Message-ID	<uQ8Bj-2cJ-1@gated-at.bofh.it> (permalink)
References	<uQ6zw-JC-9@gated-at.bofh.it> <uQ7cd-1dP-9@gated-at.bofh.it>
Organization	JRE Trading Ltd

Show all headers | View raw

On Sun, 26 Nov 2017 16:35:24 +0100
Ulf Volmer <u.volmer@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

Thread

error: 'Access denied for user 'root'@'localhost' (using password: NO)' Rainer Dorsch <ml@bokomoko.de> - 2017-11-26 16:00 +0100
  Re: error: 'Access denied for user 'root'@'localhost' (using  password: NO)' Ulf Volmer <u.volmer@u-v.de> - 2017-11-26 16:40 +0100
    Re: error: 'Access denied for user 'root'@'localhost' (using  password: NO)' Joe <joe@jretrading.com> - 2017-11-26 18:10 +0100
      Re: error: 'Access denied for user 'root'@'localhost' (using password: NO)' Rainer Dorsch <ml@bokomoko.de> - 2017-11-26 18:50 +0100
        Re: error: 'Access denied for user 'root'@'localhost' (using  password: NO)' Ulf Volmer <u.volmer@u-v.de> - 2017-11-26 19:20 +0100
          Re: error: 'Access denied for user 'root'@'localhost' (using  password: NO)' Joe <joe@jretrading.com> - 2017-11-26 20:50 +0100

csiph-web