Why do I have to set MySQL user password with mysql_native_password to connect with Workbench?
MySQL Workbench 8 accepts, if mysql server is set to legacy mode, also native_passwords.
But it  also accepts users that use cashing_sha2_password or sh2 passwords.
So you must check the users roles and for which. first try to use % in LImit to host matching and DBA as role, so that your user has all privileges to test.