How do I ensure that MySQL is writing out its error log as the correct user?
0
votes
1
answer
43
views
I have a development Airflow server. It uses MySQL as its database. In the mysqld settings, I have the user set to mysql.
However, the log is being written out as a different user named adm whenever the log is rolled over. I have confirmed I have set the desired user to mysql in the config, restarted the MySQL service to pick up this change, but it is still changing daily to adm. How can I make it so that the mysql user writes out the error log file after rolling over?
[mysqld]
#
# * Basic Settings
#
user = mysql
...
# Error log - should be very few entries.
#
log_error = /var/log/mysql/error.log
Sample current directory:
drwxr-x--- 2 mysql mysql 4096 Oct 23 13:37 .
drwxrwxr-x 13 root syslog 4096 Oct 23 00:00 ..
-rw-r----- 1 adm adm 0 Oct 23 00:00 error.log
Desired directory:
drwxr-x--- 2 mysql mysql 4096 Oct 23 13:37 .
drwxrwxr-x 13 root syslog 4096 Oct 23 00:00 ..
-rw-r----- 1 mysql mysql 0 Oct 23 00:00 error.log
Asked by Zack
(121 rep)
Oct 24, 2024, 04:19 PM
Last activity: Oct 24, 2024, 06:15 PM
Last activity: Oct 24, 2024, 06:15 PM