mysql my.cnf file but in that file there were no options are available like server-id,bind-address,log-bin.

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