Bug #118910 Authentication to host 'localhost' for user 'root' using method 'mysql_native_password'

• Submitted: 28 Aug 12:03
• Modified: 28 Aug 17:04
• Reporter: Stephen A
• Status: Not a Bug
• Category: MySQL Workbench
• Severity: S2 (Serious)
• Version: Workbench 8 CE
• OS: Windows (2019)
• CPU Architecture: Any

[28 Aug 12:03] Stephen A

Description:
Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed with message: Reading from the stream has failed.
It was working fine until one day when it started to give this error.
Telnet to localhost/ 127.0.0.1 on the port works fine from the command line. When attempting to do the same from the exe with connection string this error is reported - string MyConnection2 = "datasource=localhost;port=3306;username=<>;password=<>";. Have tried rebuilding the exe forcing the TCP protocol args while making connection but no result. We are stuck here. Need some suggestions.The same userid works fine when attempting a manual login to the application or via CMD to the application but not working with the exe.

How to repeat:
When we run the exe, it is giving the same error.

[28 Aug 17:04] MySQL Verification Team

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

For details on getting support for MySQL products see http://www.mysql.com/support/
You can also check our forums (free) at http://forums.mysql.com/

Thank you for your interest in MySQL.