title: Unable to connect with MySQL database with visual studio 2019
body: <p>I am trying to configure <code>MySQL</code> database into by <code>dot net</code> application. For this, I have installed it.</p>
  <ol>
  <li><a href="https://dev.mysql.com/downloads/windows/visualstudio/" rel="nofollow noreferrer">MySQL for Visual Studio 1.2.9</a></li>
  <li><a href="https://dev.mysql.com/downloads/connector/net/" rel="nofollow noreferrer">Connector/NET 8.0.22</a></li>
  <li>Entity Framework 6 (EF6)</li>
  <li><a href="http://nuget.org/packages/MySql.Data.EntityFramework" rel="nofollow noreferrer">MySql.Data.EntityFramework</a> version 8.0.22 via nuget</li>
  </ol>
  <p><strong>App.config</strong></p>
  <pre><code>&lt;entityFramework&gt;
  &lt;defaultConnectionFactory type=&quot;MySql.Data.Entity.MySqlConnectionFactory,  MySql.Data.Entity.EF6&quot; /&gt;
  &lt;providers&gt;
    &lt;provider invariantName=&quot;MySql.Data.MySqlClient&quot; type=&quot;MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6&quot; /&gt;
    &lt;provider invariantName=&quot;System.Data.SqlClient&quot; type=&quot;System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer&quot; /&gt;
  &lt;provider invariantName=&quot;MySql.Data.MySqlClient&quot; type=&quot;MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.EntityFramework, Version=8.0.22.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d&quot;&gt;
    &lt;/provider&gt;&lt;/providers&gt;
  </code></pre>
    
  <p>When I am trying to add the database I am getting below error</p>
  <p><a href="https://i.stack.imgur.com/jjNXQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jjNXQ.png" alt="enter image description here" /></a></p>
  <p>I have tried almost every solution on the stack but nothing solves the problem.</p>
  <p>Any help would be highly appreciated.</p>