This is apparently a known bug that has been ongoing the past few years:
Access denied for 'none'. Trying to access a MySQL Workbench database via SSH using RStudio
In order to connect, you should either use an RSA key with a passphrase or an ed25519 without one