Bug #98110 MySQL WB known_hosts path described in doc is incorrect for Windows10

• Submitted: 2 Jan 2020 17:39
• Modified: 17 Jan 2020 22:51
• Reporter: Tsubasa Tanaka (OCA)
• Status: Closed
• Category: MySQL Workbench: Documentation
• Severity: S3 (Non-critical)
• Version: 8.0.18
• OS: Windows (10.0.19041)
• CPU Architecture: x86

[2 Jan 2020 17:39] Tsubasa Tanaka

Description:
Document says 

> On Microsoft Windows, they are stored in a file created by MySQL Workbench under the user's application data folder (%appdata%), such as C:\Users\[username]\AppData\Roaming\MySQL\Workbench\known_hosts.

in https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-methods-ssh.html

But actually, (at least) MySQL Workbench 8.0.18 uses C:\Users\[username]\.ssh\known_hosts ''by default''

https://github.com/mysql/mysql-workbench/blob/8.0.18/library/ssh/SSHSession.cpp#L529-L551

1. Default known_hosts place is wrong.
2. known_hosts place is configurable. This should be described in doc.

How to repeat:
1. Make new connection that using connection method "Standard TCP/IP over SSH"
2. Find your known_hosts in C:\Users\[username]\AppData\Roaming\MySQL\Workbench\known_hosts.
3. Find your known_hosts in C:\Users\[username]\.ssh\known_hosts

Suggested fix:
1. Fix description in https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-methods-ssh.html

2. Add message like a "This known_hosts path is configurable. Please see https://dev.mysql.com/doc/workbench/en/wb-preferences-ssh.html in details." around known_hosts sentence.

[16 Jan 2020 6:51] MySQL Verification Team

Hello tsubasa tanaka,

Thank you for the bug report and feedback.
Verified as described.

Regards,
Ashwini Patil

[17 Jan 2020 22:51] Christine Cole

Posted by developer:
 
Fixed and online.
Thank you for the report.