Question
mysql my.cnf file but in that file there were no options are available like server-id,bind-address,log-bin.
Operating System : CentOS release 6.7 (Final)
I am new in mysql I have checked my.cnf file but in that file there were no options are available like server-id,bind-address,log-bin. Is it ok If I will add this parameters in my.cnf please assist me regarding this . Thanks
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Get our biweekly newsletter
Sign up for Infrastructure as a Newsletter.
Hollie's Hub for Good
Working on improving health and education, reducing inequality, and spurring economic growth? We'd like to help.
Become a contributor
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
I am new to Digital Ocean and have installed ubuntu 16.04, having configured LAMP seperatly, having cheched my.cnf in sudo nano /etc/mysql/my.cnf the only items available are !includedir /etc/mysql/conf.d and !includedir /etc/mysql/mysql.conf.d/
I am trying to ensure the blind-address, server-id, log_bin are configured, however these are not available, does anyone have any Ideas, please help!!
Hello,
If you do not see the options in your my.cnf file, then the system will use the default options for that particular option. If you need to add in options in the my.cnf file, then simply add them to the appropriate section. For more information, please check out:
http://serverfault.com/questions/347767/where-can-i-find-documentation-on-my-cnf-directives http://dev.mysql.com/doc/refman/5.7/en/option-files.html http://linux.die.net/man/1/mysql
Please let us know if there is anything else we can help you with.
Best, Mike DigitalOcean Support Check out our community for great tutorials, articles and FAQs! https://digitalocean.com/community
This comment has been deleted