SOLVED Enabling Log Bin

[Kalladeron]

Hi!

I am trying to enable Log Bin in my WHM server, but doenst matter what I add to my "my.cnf", every single time my msql crash.

Someone already was able to enale log bin for mysql and can share the information used? I am running MYSQL 5.7.

I tried to use as variable:

log_bin=/var/lib/mysql/binlog
log-bin=/var/lib/mysql/binlog

The error that appear when I update the my.cnf with any of the code above in engintron is this:

Waiting for “mysql” to start ………Unrecognized configuration options may have caused the MySQL startup errors.

The system has attempted to auto-update your MySQL configuration file for your MySQL version.

This should resolve any errors that stem from an outdated MySQL configuration file.

…Unrecognized configuration options may have caused the MySQL startup errors.

The system has attempted to auto-update your MySQL configuration file for your MySQL version.

This should resolve any errors that stem from an outdated MySQL configuration file.

…failed.

 

[cPRex]

Hey there! I did some research on this and found I had to do the following:

In SSH:

touch /var/lib/mysql/mysqlbin.log
chown mysql. /var/lib/mysql/mysqlbin.log

In my.cnf:

server-id=1
log_bin=/var/lib/mysql/mysqlbin.log

Then restart the MySQL service.

Can you try that and see if you get better results?

 

[Kalladeron]

Sorry the delay!

Awesome, this solved my problem

 

[cPRex]

You're welcome!!! I'm glad that helped!