title: Error in Creating New Database User through MySQL Workbench in Ubuntu
body: <p>MySQL : 8.0.27
  MySQL Workbench : 6.3.8
  Ubuntu : 18.04.6 LTS</p>
  <p>Installed MySQL and MySQL Workbench - Was working with root and decided to create an admin user through Workbench - so I went into 'User and Privilege' option in MySQL Workbench - and given all the admin rights and then selected the authentication as 'caching_sha2_password' and provided password following all rules (8+ character, capital + small letters, symbols). Following error comes in creating user:</p>
  <p>Unhandled exception: 'caching_sha2_password'</p>
  <ol>
  <li><p>I tried changing authentication method.</p>
  </li>
  <li><p>I can create a user through Command Line logged in from root.</p>
  </li>
  </ol>