Comments - Logration does not work
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
The DB user for the mariadb-admin in the context of the logrotate script has insufficient privs.
su doesn't apply to scripts.
ALTER USER 'root'@'localhost' IDENTIFIED VIA unix_socket
is a simple way or make a config file with credentials. And RELOAD privs are required.
Hi,
The DB user has the correct right. See bellow: [root@svx-mdb-04t 10.11]# !ma mariadb -u root Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 31031 Server version: 10.11.8-MariaDB-log MariaDB Server
Copyright © 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> select user,host,password,plugin,authentication_string from mysql.user where user = 'root'; +------+----------------+-------------------------------------------+-----------------------+-------------------------------------------+
+------+----------------+-------------------------------------------+-----------------------+-------------------------------------------+
+------+----------------+-------------------------------------------+-----------------------+-------------------------------------------+ 4 rows in set (0.001 sec)
MariaDB [(none)]>
I need more help Regards