Enabling Log Bin

Kalladeron

• July 23, 2021 10:35

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 Jurassic Moderator

  • July 23, 2021 18:25

  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?

  0
• 

  Kalladeron

  • August 06, 2021 12:24

  Sorry the delay! Awesome, this solved my problem :)

  0
• 

  cPRex Jurassic Moderator

  • August 06, 2021 13:05

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

  0

Please sign in to leave a comment.