Heidisql: Problem with SSH tunnel and 64 bit version on Windows10 - caching_sha2_password' load failure

[Xtravaganz]

Describe the bug

• heidisql plugin 'caching_sha2_password' load failure

To Reproduce

* setup 64bit *

• Install HeidiSQLPortable 64bit
• Install plink.exe
• Create a ppk key with Putty
• Settings for SSH Tunnel
• try to connect with diffrent dlls (mariadb and mysql)
• both have as result the error : caching_sha2_password' load failure

* setup 32bit *

• same setup
• no error

Environment:

• OS: Windows 10
• newest HeidiSQL portable version
• mysql Ver 8.0.21 for Linux on x86_64 (MySQL Community Server - GPL)

[ansgarbecker]

Last portable is not really up-to-date. At least libmariadb.dll got an update after the v11.0 release. Please re-test once I released the next v11.1 version with a new portable package.

[ansgarbecker]

Ah, in what way is the SSH tunnel relevant? Doesn't that happen with a normal connection without a tunnel?

[Xtravaganz]

Ah, in what way is the SSH tunnel relevant? Doesn't that happen with a normal connection without a tunnel?

To be on the safe side, MySQL is only open via localhost, so you don't have to open the port for SQL and can conveniently use Mysql via the SSH service.

[Xtravaganz]

Last portable is not really up-to-date. At least libmariadb.dll got an update after the v11.0 release. Please re-test once I released the next v11.1 version with a new portable package.

Will test it tomorrow.

[ansgarbecker]

You cannot test tomorrow, you have to wait for me to release the v11.1 first.

Is the issue happening with a normal connection as well, without SSH tunnel? Or does it only occurr with an SSH tunnel?

[Xtravaganz]

You cannot test tomorrow, you have to wait for me to release the v11.1 first.

Is the issue happening with a normal connection as well, without SSH tunnel? Or does it only occurr with an SSH tunnel?

Yeah, i will wait.
When i remember correct, yes.

[ansgarbecker]

I release v11.1 in the meantime. Please update and retry.
Please note that this new release comes with its own plink.exe, which you should prefer over a separate one. To use HeidiSQL's own plink.exe, go to "SSH tunnel" tab and set it to just "plink.exe" without path:

[Xtravaganz]

No change in the 64 bit version:

32bit portable works fine:

Thanks:

this saves unnecessary downloading and clicking