Bug #108028 Access denied error when trying to connect to database

• Submitted: 29 Jul 2022 9:11
• Modified: 1 Aug 2022 19:02
• Reporter: Antoine Préveaux
• Status: Verified
• Category: Shell VSCode Extension
• Severity: S3 (Non-critical)
• Version: 1.3.1
• OS: MacOS (12.4)
• CPU Architecture: ARM (Apple M1 Chip)
• Tags: passphrase, ssh

[29 Jul 2022 9:11] Antoine Préveaux

Description:
When trying to connect to open a DB connection, I get an access denied error.

I connect to my DB using a SSH tunnel and my SSH key has a passphrase. I could not find how to enter, it's probably the reason why it does not work.

If I remove passphrase from my SSH key, it works but having no passphrase is not a secure option for me.

How to repeat:
- Configure a DB connection with a SSH tunnel and a SSH key having a passphrase
- Try to connect to DB

You get a connection error message "Access denied"

Suggested fix:
None

[1 Aug 2022 19:02] MySQL Verification Team

Hi,

I reduced the severity to S3 as this really is no S1 bug.

You can load they key with ssh-add before you start the VSCode and it should work.

Thanks for using VSCode Extension for MySQL Server