Admin Beckspaced wrote:
Hello OpenSUSE users,
since recently upgrading from 42.2 to 42.3 I do receive an error with logrotate on the mariadb config.
2018-03-14T00:00:01.845385+01:00 cx20-2 logrotate[22165]: error: 'Access denied for user 'root'@'localhost' (using password: NO)' 2018-03-14T00:00:01.846915+01:00 cx20-2 logrotate[22165]: the root acount is protected by password. 2018-03-14T00:00:01.847363+01:00 cx20-2 logrotate[22165]: See comments in /etc/logrotate.d/mariadb on how to fix this 2018-03-14T00:00:01.849623+01:00 cx20-2 logrotate[22165]: error: error running non-shared postrotate script for /var/log/mysql/mysqld.log of '/var/log/mysql/mysqld.log '
yes, I did create the file /root/.my.cnf with read only permissions 0600 for root only
[mysqladmin] password = mysecretpassword user = root
but it doesn't help ;(
I use this: [client] password=mysecretpassword As root, I can enter 'mysql' or 'mysql -u root' or 'mysql -u root -h localhost' and log in. As for rotating mysqlk.log, I never bother. -- Per Jessen, Zürich (7.8°C) http://www.hostsuisse.com/ - virtual servers, made in Switzerland. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org