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 20:50 +0100
Message-ID	<uQb6a-3F5-13@gated-at.bofh.it> (permalink)
References	<uQ6zw-JC-9@gated-at.bofh.it> <uQ7cd-1dP-9@gated-at.bofh.it> <uQ8Bj-2cJ-1@gated-at.bofh.it> <uQ9e1-2rZ-7@gated-at.bofh.it> <uQ9H3-2Re-11@gated-at.bofh.it>
Organization	JRE Trading Ltd

Show all headers | View raw

On Sun, 26 Nov 2017 19:11:23 +0100
Ulf Volmer <u.volmer@u-v.de> wrote:

> On 26.11.2017 18:48, Rainer Dorsch wrote:
> 
> > root@scw:/etc/logrotate.d#  cat /etc/mysql/debian.cnf
> > # Automatically generated for Debian scripts. DO NOT TOUCH!
> > [client]
> > host     = localhost
> > user     = root
> > password = 
> > socket   = /var/run/mysqld/mysqld.sock
> > [mysql_upgrade]
> > host     = localhost
> > user     = root
> > password = 
> > socket   = /var/run/mysqld/mysqld.sock
> > basedir  = /usr  
> 
> That' not the content i expected. But explains you error message.
> 
> in my system looks like
> 
> # Automatically generated for Debian scripts. DO NOT TOUCH!
> [client]
> host     = localhost
> user     = debian-sys-maint
> password = long_random_string
> socket   = /var/run/mysqld/mysqld.sock
> [mysql_upgrade]
> host     = localhost
> user     = debian-sys-maint
> password = long_random_string
> socket   = /var/run/mysqld/mysqld.sock
> basedir  = /usr
> 
> so i think, you should change the user and password in this file. And
> also make sure that the user debian-sys-maint exists in the MySQL
> database and have the configured password.
> 

My guess is that this is a mariadb installation. Is that correct? If
so, check /usr/share/doc/mariadb-server-10.1/README.Debian.gz

"The credentials in /etc/mysql/debian.cnf specify the user which is
used by the init scripts to stop the server and perform logrotation.
This used to be the debian-sys-maint user which is no longer used as
root can run directly.

If you have start/stop problems make sure that
the /etc/mysql/debian.cnf file specifies the root user and no password."

Have you previously changed the password of mysql root?

-- 
Joe

Back to linux.debian.user | Previous | Next — Previous 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