title: Unable to connect to any specified mysql C#
body: <p>I can't connect to my sql server, i tried some fixes from stackoverflow and google and it didn't help me. Thanks.</p>
  
  <pre><code>  connString = "SERVER ='''myserverip''';PORT=3306;DATABASE=mydatabase;UID=myuser;PASSWORD=mypassword";
          try
           {
               conn = new MySqlConnection();
               conn.ConnectionString = connString;
               conn.Open();
               MessageBox.Show("Connection success");
  
           }
           catch (MySql.Data.MySqlClient.MySqlException ex)
           {
               MessageBox.Show(ex.Message);
           }
  </code></pre>
  
  <p>To configure myuser I used this on my linux vps.</p>
  
  <pre><code>CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypassword'; CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypassword'; GRANT ALL ON *.* TO 'myuser'@'localhost'; GRANT ALL ON *.* TO 'myuser'@'%';
  </code></pre>
  
  <p>i tried : <a href="https://stackoverflow.com/questions/17993657/unable-to-connect-to-any-of-the-specified-mysql-hosts-c-sharp-mysql">Unable to connect to any of the specified mysql hosts. C# MySQL</a> ( i tried to use MySqlConnectionStringBuilder, don't specify the port, instead of password in connection string i typed psw);
  Disable my pc firewall, disable linux server firewall</p>