title: C# and EF Can not connect to remote MySql Server but MySql workbench connects
body: <p>I have this Mysql database on a remote hosting provider. I have MySql workbench installed and with the following information:</p>
  
  <pre><code>server,
  username,
  pw
  </code></pre>
  
  <p>it connects ok but when i try with visualstudio i get this error  <img src="https://i.stack.imgur.com/B8VGe.png" alt="enter image description here"></p>
  
  <p>i am using MySql connector from MySql's website. Also when trying to connect with the following connection string in EntityFramework </p>
  
  <pre><code>Server=tango.rdb.superhosting.bg;Database=ulprojec_weatheronmars;Uid=ulpro_georgi_it;Pwd=password;
  </code></pre>
  
  <p>i get the following error </p>
  
  <pre><code>An error occurred while getting provider information from the database. This can be caused by Entity Framework using an incorrect connection string. Check the inner exceptions for details and ensure that the connection string is correct.
  </code></pre>
  
  <p>And still through MySql workbench i can execute LINQ and etc.</p>