I am following this guide:
I needed to edit my.cnf file to set the values you will see below.
The steps I took were:
sudo cp -rp /etc/my.cnf /etc/my.cnf.bakup
sudo nano /etc/my.cnf
(added to the bottom)
server_id = 1
log_bin = /var/log/mysql-bin.log
log_bin_index = /var/log/mysql-bin.log.ind
relay_log = /var/log/mysql-relay-bin
relay_log_index = /var/log/mysql-relay-bin.i
expire_logs_days = 10
max_binlog_size = 100M
log_slave_updates = 1
auto-increment-increment = 2
auto-increment-offset = 1
I tried to reboot mysql using WHM but it always failed saying the four log files I had defined did not exist. So I manually used nano to create them but even now I am getting the same problem.
Could you please help me understand how to create these files so that might be able to reboot mysql successfully?