title: Mysql: Connection refused ERROR: 111
body: <p>I can't connect to my server when I use a remote IP address.</p>
  
  <p>Localhost is working fine.</p>
  
  <p><strong>Some info:</strong></p>
  
  <p>OS: Ubuntu 16.04</p>
  
  <p>Database: MariaDB</p>
  
  <p>Port 3306 is open</p>
  
  <p>User has remote (%) access.</p>
  
  <p>I've changed bind-address in 50-server.conf to bind-address = 0.0.0.0 and I tried commenting it out. none of them worked. Also tried putting bind-address = 0.0.0.0in my.conf under a [mysqld] grouptag. After every change I restarted Mysql and tried to connect with this command mrsql -u root -h xxx.xxx.xxx.xxx -p. It works fine for localhost, but does not work when I try my servers IP.</p>
  
  <p>How do I solve this problem?</p>