Bug #108857 workbench can't connect to server: conflicting client/server versions (10/11)
Submitted: 23 Oct 2022 15:41 Modified: 17 Nov 2022 12:45
Reporter: Hanan Rosemarin Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.31 OS:Windows (Windows-11)
Assigned to: CPU Architecture:x86

[23 Oct 2022 15:41] Hanan Rosemarin 
Description:
Running mysql in WSL2 / Ubuntu-20.04
Can connect to mysql server using command line clients as well as python and c++ api
When trying to connect from Workbench (running on the windows host), "test connection" fails with the following error message:
Failed to Connect to MySQL at localhost:<port> with user <user>
Protocol mismatch; server version = 11, client version = 10

I found a similar post: https://forums.mysql.com/read.php?152,684386

The advice given (changing the binding address from 127.0.0.1 to 0.0.0.0) did not solve the problem

How to repeat:
- create an Ubuntu (20.04) instance in WSL2
- start mysql (preferably changing the default port number to avoid conflicts)
- after verifying that mysql is working properly in ubuntu, download workbench for windows
- try connecting to localhost:port
[3 Nov 2022 12:46] MySQL Verification Team 
Hello Hanan Rosemarin,

Thank you for the bug report.
To investigate further this issue at our end, may I kindly request you to launch workbench under debug mode (--log-level=debug3) and provide unaltered workbench log file(more details about log are explained here - https://dev.mysql.com/doc/workbench/en/workbench-reporting-bugs.html)? Thank you.

Regards,
Ashwini Patil
[17 Nov 2022 12:45] MySQL Verification Team 
Hello Hanan Rosemarin,

Thank you for the bug report.
I tried to reproduce your issue on windows 10 with workbench 8.0.31 but I am not seeing any issues at my end.

Regards,
Ashwini Patil