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.
Enter your email to get $200 in credit for your first 60 days with DigitalOcean.
New accounts only. By submitting your email you agree to our Privacy Policy.
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