title: Authentication method 'caching_sha2_password' not supported by any of the available plugins
body: <p>When I try to connect MySQL (8.0) database with Visual Studio 2018 I get this error message </p>
  
  <blockquote>
    <p>"Authentication method 'caching_sha2_password' not supported by any of the available plugins"</p>
  </blockquote>
  
  <p>Also I am unable to retrieve Database name.
  I use <code>mysql-for-visualstudio-1.2.7</code> and <code>mysql-connector-net-8.0.11</code> for connection.
  Is there any possible way to fix it.</p>