Kalladeron

Registered
Jul 23, 2021
2
0
1
Brazil
cPanel Access Level
Root Administrator
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:

Code:
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:

Code:
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.
 
Last edited:

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
6,923
912
313
cPanel Access Level
Root Administrator
Hey there! I did some research on this and found I had to do the following:

In SSH:

Code:
touch /var/lib/mysql/mysqlbin.log
chown mysql. /var/lib/mysql/mysqlbin.log
In my.cnf:

Code:
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?