Unable to start mysqld service after enabling log_bin on MySQL 5.7

Kumar Manil's picture

Hi I am unable to start mysqld service after I make changes in my.cnf to enable log-bin.

After making changes the file looks like below:


# For advice on how to change settings please see
# <a href="http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
#">http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.htm...</a> Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#This is what I added to enable log-bin
#That was what I added to enable log-bin
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
# Disabling symbolic-links is recommended to prevent assorted security risks

I am using:

[<a href="mailto:ec2-user@pip">ec2-user@pip</a> my.cnf.d]$ cat /etc/redhat-release Red Hat Enterprise Linux Server release 7.3 (Maipo)

Following is the ownership and permissions:

d]$ ls -ld /var/log/mysql drwxrwxrwx. 2 mysql mysql 23 Sep 8 09:01 /var/log/mysql

Following is the error that I get:

[ec2-user@i.d]$ sudo service mysqld start Redirecting to /bin/systemctl start mysqld.service Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.

Please let me know if any other detail is required



This question hasn't been answered yet. Login or create an account to be the first to answer it!