0

Platform System: WSL(ubuntu 18.04).

when installed mysql-server 8.0 sucess, i try to start mysql. But it's fail to start.Then checked the error.log.

2019-02-26T03:13:51.609895Z 0 [ERROR] [MY-000067] [Server] unknown variable 'log-syslog=1'.

how to fix it ?

  • 1
    log_syslog Deprecated in 8.0.2, removed in 8.0.13. – Akina Feb 26 at 6:36
  • When you have a systemd like 18.04 and journalctl with it, you don't need the ugly hacks provided mysqld_safe in init scripts to get a syslog capture. – danblack Feb 26 at 9:48
0

I've run into the same problem as yourself and found this question while looking for solution. Eventually I found the culprit.

You will find that /etc/mysql/mysql.conf.d/mysqld_safe_syslog.cnf contains 2 rows:

[mysqld_safe]
syslog

The only thing you have to do is remove syslog. I just commented it out:

[mysqld_safe]
#syslog

And now it works. It is weird that it comes preconfigured like that since it is deprecated/removed (I did a clean install of v8.0.15).

0

From the Changelog:

----- 2018-10-22 8.0.13 General Availability -- -- Incompatible Change -----

The system variables have been removed that previously configured error logging to the system log (the Event Log on Windows, and syslog on Unix and Unix-like systems). Where appropriate, the removed system variables were replaced with new system variables managed by the log_sink_syseventlog error log component. The following table shows the old and new variable names.

Old System Variable New System Variable log_syslog_facility syseventlog.facility log_syslog_include_pid syseventlog.include_pid log_syslog_tag syseventlog.tag log_syslog None Important

Installations that used the old system variable names must update their configuration to use the new variable names. For more information, see Error Logging to the System Log.

References: See also: Bug #27534089.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.