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) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Documentation Severity:S3 (Non-critical)
Version:8.0.18 OS:Windows (10.0.19041)
Assigned to: 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.