The Bitnami paths are not the same as standard Ubuntu linux and as such the MySQL 8 documentation is not help for bitnami specific paths.
You are right about the paths, however my point was that the guide you were following can be outdated and you should check one that matches the version of the application you are trying to tailor.
Bitnami MySQL’s files are set to exist in the
/opt/bitnami/mysql path, but let’s check your items:
binlog_do_db --> This is NOT a path, but the name of the database you would like to record binary logs. Additionally, it seems this is no longer a a conf. option but a command line flag Reference here.
log_bin --> As per reference in MySQL
8.0 this should be a boolean (Reference here). Having said that, the path where binary log files are stored is
$ ls -la /opt/bitnami/mysql/data | grep binlog
-rw-r----- 1 mysql mysql 1816 Jan 18 10:09 binlog.000001
-rw-r----- 1 mysql mysql 179 Jan 18 10:09 binlog.000002
-rw-r----- 1 mysql mysql 200 Jan 18 10:33 binlog.000003
-rw-r----- 1 mysql mysql 156 Jan 18 10:33 binlog.000004
-rw-r----- 1 mysql mysql 64 Jan 18 10:33 binlog.index
As you can see, the base name for binlogs is the default one
binlog, reference here
relay-log --> As per reference in MySQL
8.0, this should be
relay_log (reference here). We are not setting this option, but I recommend you specify it to be under the
Jose Antonio Carmona
Was my answer helpful? Click on