I have a weird problem when trying to connect to a new MySQL Server (8.0.28 on Ubuntu 20.04). I'm using HeidiSQL 22.214.171.12495 via Wine on Ubuntu 20.04 and trying to connect via a SSH Tunnel.
The tunnel seems to be working, but I can't get a connection to MySQL. The error messages vary depending on the library used:
libmariadb.dll: Unknown MySQL error libmysql-6.1.dll: SSL connection error: unknown error number libmysql.dll: Access denied for user (the credentials are working fine with "mysql -p -u")
But now comes the weird part. I noticed I sometimes can connect to the server, when I'm also logged in as root via a seperate SSH connection. I'm not using root in HeidiSQL btw. Might also be a coincidence, as I'm currently not able to reproduce it.
I also am running a local server with the same config and have no issues connecting to that.