On Sun, 26 Nov 2017 19:11:23 +0100 Ulf Volmer <u.vol...@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