title: MySQL 8.0.11 error connect to caching_sha2_password the specified module could not be found
body: <p>I've tried to connect to the latest MySQL server 8.0.11 from MySQL workbench, but the error keeps popping up: Cannot connect to MySQL server, authentication plugin: caching_sha2_password: the specified module could not be found.</p>
  
  <p>I tried looking at MySQL server installation videos online and replicated every step accurately, but the error persists.</p>
  
  <p>Any help is greatly appreciated.</p>