title: MySQL 8.0.11 error connecting due to caching_sha2_password
body: <p>When I try to connect to server on MySQL Workbench, I get the error saying</p>
  <blockquote>
  <p>Your connection attempt failed to user 'root' from your host to server as localhost:3306:</p>
  <p>Authentication plugin <code>caching_sha2_password</code> cannot be loaded:</p>
  <p>The specified module could not be found.</p>
  </blockquote>
  <p>It seems like I do not have the module for <code>caching_sha2_password</code> installed. How do I install this plugin?</p>
  <p>I tried to follow steps provided <a href="https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html" rel="nofollow noreferrer">here</a>. But this is my first interaction with MySQL, so I did not understand the steps.</p>
  <p>For example, under Using SHA-2 Pluggable Authentication, it says</p>
  <blockquote>
  <p>&quot;storing those values in the <code>plugin</code> and <code>authentication_string</code> columns of the      &gt; <code>mysql.user</code> system table.&quot;</p>
  </blockquote>
  <p>But where is the <code>mysql.user</code> system table and how do I access it and store the values?</p>
  <p>Any help would be greatly appreciated!</p>