How To Enable Binary Log in MariaDB 10

 in This Tutorial you will Learn " How To Enable Binary Log in MariaDB 10"
                           
MariaDB Server is one of the most popular open source relational databases.
The binary log contains a record of all changes to the databases, both data and structure.
_________________________________________________________________________________________
Server - Os:  Rocky Linux 8.5  64Bit      |    IP -192.168.1.20        |     Hostname - www.primaryhost.com
_________________________________________________________________________________________
cat /etc/system-release ; mysql -V
Verify Binary Log - show variables like '%bin%';
show binary logs;
Enable Binary Log  -  Mariadb - nano /etc/my.cnf.d/server.cnf

log-bin=bin.log
log-bin-index=bin-log.index
max_binlog_size=100M
binlog_format=row
socket=mysql.sock
systemctl daemon-reload ; systemctl restart mariadb
_________________________________________________________________________________________
Mysql  Ver 8.0.26 -
mysql -V

Verify Binary Log - show variables like '%bin%';
show binary logs;
Enable Binary Log  - nano /etc/my.cnf.d/mysql-server.cnf
log-bin=bin.log
log-bin-index=bin-log.index
max_binlog_size=100M
binlog_format=row
socket=mysql.sock
systemctl daemon-reload ; systemctl restart mysqld
mysql -u root -p
_________________________________________________________________________________________