title: my MYSQL my.cnf file doesnt contain bind address on it, and when i put it in the file, it wouldnt work
body: <p>My <code>/etc/mysql/my.cnf</code> file had no bind-address when i checked it. when i placed the bind-address, it wouldn't restart the process with an error.</p>
  <p>when i try the command mysql i get this:</p>
  <pre><code>ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
  root@vps687459:~#
  </code></pre>
  <p>when i try to restart the service, it gives me this:</p>
  <pre><code>Sep 02 13:14:34 vps687459 systemd[1]: mysql.service: Control process exited, code=exited status=1
  Sep 02 13:14:34 vps687459 systemd[1]: mysql.service: Failed with result 'exit-code'.
  Sep 02 13:14:34 vps687459 systemd[1]: Failed to start MySQL Community Server.
  Sep 02 13:14:35 vps687459 systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
  Sep 02 13:14:35 vps687459 systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
  Sep 02 13:14:35 vps687459 systemd[1]: Stopped MySQL Community Server.
  Sep 02 13:14:35 vps687459 systemd[1]: mysql.service: Start request repeated too quickly.
  Sep 02 13:14:35 vps687459 systemd[1]: mysql.service: Failed with result 'exit-code'.
  Sep 02 13:14:35 vps687459 systemd[1]: Failed to start MySQL Community Server.
  </code></pre>
  <pre><code>
  #
  # The MySQL database server configuration file.
  #
  
  # You can copy this to one of:
  # - &quot;/etc/mysql/my.cnf&quot; to set global options,
  # - &quot;~/.my.cnf&quot; to set user-specific options.
  # 
  # One can use all long options that the program supports.
  # Run program with --help to get a list of available options and with
  # --print-defaults to see which it would actually understand and use.
  #
  # For explanations see
  # http://dev.mysql.com/doc/mysql/en/server-system-variables.html
  
  #
  # * IMPORTANT: Additional settings that can override those from this file!
  #   The files must end with '.cnf', otherwise they'll be ignored.
  #
  
  !includedir /etc/mysql/conf.d/
  !includedir /etc/mysql/mysql.conf.d/
  
  
  </code></pre>
  <p>all i want is to be able to connect to my database from another machine. how can i fix my community server to do this</p>
  <p>EDIT: I got this error:</p>
  <pre><code>mysql: [ERROR] Found option without preceding group in config file /etc/mysql/my.cnf at line 23!
  </code></pre>
  <p>i Then checked my my.cnf:</p>
  <pre><code>#
  # The MySQL database server configuration file.
  #
  # You can copy this to one of:
  # - &quot;/etc/mysql/my.cnf&quot; to set global options,
  # - &quot;~/.my.cnf&quot; to set user-specific options.
  # 
  # One can use all long options that the program supports.
  # Run program with --help to get a list of available options and with
  # --print-defaults to see which it would actually understand and use.
  #
  # For explanations see
  # http://dev.mysql.com/doc/mysql/en/server-system-variables.html
  
  #
  # * IMPORTANT: Additional settings that can override those from this file!
  #   The files must end with '.cnf', otherwise they'll be ignored.
  #
  
  !includedir /etc/mysql/conf.d/
  !includedir /etc/mysql/mysql.conf.d/
  
  bind-address=0.0.0.0
  </code></pre>