Bug #99088 unknown variable 'log_bin_basename=
Submitted: 26 Mar 2020 17:24 Modified: 26 Mar 2020 19:02
Reporter: Constantin Irimia Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Options Severity:S3 (Non-critical)
Version:8.0.19 OS:FreeBSD (11.2)
Assigned to: CPU Architecture:x86
Tags: log-bin-basename

[26 Mar 2020 17:24] Constantin Irimia
Description:
CONFIG:
log-bin                         = ON
log-bin-basename                = mysql-bin-log
log-bin-index                   = mysql-bin-index

LOG FILE:
2020-03-26T17:18:09.495689Z 0 [System] [MY-010116] [Server] /usr/local/libexec/mysqld (mysqld 8.0.19) starting as process 7448
2020-03-26T17:18:13.110511Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-03-26T17:18:13.153805Z 0 [ERROR] [MY-000067] [Server] unknown variable 'log-bin-basename=mysql-bin-log'.
2020-03-26T17:18:13.154241Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-03-26T17:18:15.242181Z 0 [System] [MY-010910] [Server] /usr/local/libexec/mysqld: Shutdown complete (mysqld 8.0.19)  Source distribution.
2020-03-26T17:18:15.6NZ mysqld_safe mysqld from pid file /var/db/mysql/mysql/Server-A.pid ended

The server don't recognize the variable log_bin_basename                

How to repeat:
Start the server with binary log active and a filename value for "log-bin-basename"
[26 Mar 2020 17:28] Constantin Irimia
Nor "log_bin_basename" or "log-bin-basename" is recognized as variable
[26 Mar 2020 19:02] MySQL Verification Team
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

For details on getting support for MySQL products see http://www.mysql.com/support/
You can also check our forums (free) at http://forums.mysql.com/

Thank you for your interest in MySQL.

See older bug: https://bugs.mysql.com/bug.php?id=71080

miguel@tikal:~/Downloads/mysql-8.0.19$ bin/mysqld --log-bin
2020-03-26T18:47:09.889509Z 0 [System] [MY-010116] [Server] /home/miguel/Downlo
ads/mysql-8.0.19/bin/mysqld (mysqld 8.0.19) starting as process 1953
2020-03-26T18:47:15.339481Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-03-26T18:47:15.521600Z 0 [System] [MY-010931] [Server] /home/miguel/Downloads/mysql-8.0.19/bin/mysqld: ready for connections. Version: '8.0.19'  socket: '/tmp/mysql.sock'  port: 3306  MySQL Community Server - GPL.
2020-03-26T18:47:15.834334Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060

Your MySQL connection id is 9
Server version: 8.0.19 MySQL Community Server - GPL

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SHOW VARIABLES LIKE 'log_bin%';
+---------------------------------+----------------------------------------------------------+
| Variable_name                   | Value                                                    |
+---------------------------------+----------------------------------------------------------+
| log_bin                         | ON                                                       |
| log_bin_basename                | /home/miguel/Downloads/mysql-8.0.19/data/tikal-bin       |