Can't enable log_bin for MariaDB

blackjack

New member
Joined
May 23, 2020
Messages
2
Hi All,
my configuration is:

- Debian 9
- DirectAdmin 1.60.4
- MariaDB 10.2.6

I've been trying for last 2 days to enable log_bin and create replication.
I added to my /etc/my.cnf

Code:
[mysqld]
bind-address = MY_SERVER_ADDRESS
server_id=1
log-basename=master
log-bin
binlog-format=row
binlog-do-db= MY_DB_NAME

I restart mysql and always when I check mysql variables through "SHOW VARIABLES LIKE 'log_bin'" my log_bin value is "OFF".
I'm not sure if this section (I mean "[mysqld]") is even working.
I have only two my.cnf files:
/etc/my.cnf
/usr/local/directadmin/conf/my.cnf

Any ideas?
 
Last edited:
I've read this article. Maybe it's a stupid question but usually I start mysql
Code:
service mysqld start
how to start it with an option?

I tried to start mysql by
Code:
mysqld --log-bin=PATH_TO_FILE
but then I got the message that mysqld shouldn't be run as root.
 
Back
Top