DBeaver: Public Key Retrieval Is Not Allowed (MySQL 8 / 8.4 Fix)

Fix DBeaver's 'Public Key Retrieval is not allowed' error: set allowPublicKeyRetrieval=true, or use TLS. MySQL 8.0, 8.4 and 5.7 differences explained.