Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > linux.debian.user > #189305

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

Show all headers | View raw

Hello,

I get (daily :-) mails from my cron.daily with the content

Cron <root@scw> test -x /usr/sbin/anacron || ( cd / && run-parts --report /
etc/cron.daily )


/etc/cron.daily/logrotate:
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 '
run-parts: /etc/cron.daily/logrotate exited with return code 1

When I run it locally

root@scw:~#  test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/
cron.daily )
root@scw:~# 

I do not hit the same issue.

Do I need to specify

       ·   --password[=password], -p[password]

           The password to use when connecting to the server. If you use the 
short option form (-p), you cannot have a space between the option and the 
password. If you omit
           the password value following the --password or -p option on the 
command line, mysqladmin prompts for one.

           Specifying a password on the command line should be considered 
insecure.

to get rid of the issue?

Many thanks
Rainer




-- 
Rainer Dorsch
http://bokomoko.de/

Back to linux.debian.user | Previous | Next — Next in thread | Find similar | Unroll thread

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