MySQL - access denied until I connect via Workbench or CLI

[lviggiani]

I cannot connect to MySQL 8.x server via this module until I connect via Workbench or CLI. The error I get is Access Denied for 'root'@'localhost' (using password: YES).

As a workaround, I reconfigured mySQL server to use Legacy Authentication Method instead of Strong Password Encryption and now it works, but unfortunalelly this is a solution I cannot use on production.

How can I manage Strong Password Encryption correctly?