MySQL Forums
Forum List  »  MySQL Workbench

Protocol mismatch; server version = 11, client version = 10
Posted by: Pasha koz
Date: February 11, 2020 03:47AM

I ask for help!
Ubuntu server: version 19.10
MySQl: Server version: 8.0.19-0ubuntu0.19.10.3 (Ubuntu)
SHOW VARIABLES LIKE "%version%";
+--------------------------+-------------------------------+
| Variable_name | Value |
+--------------------------+-------------------------------+
| immediate_server_version | 999999 |
| innodb_version | 8.0.19 |
| original_server_version | 999999 |
| protocol_version | 10 |
| slave_type_conversions | |
| tls_version | TLSv1,TLSv1.1,TLSv1.2,TLSv1.3 |
| version | 8.0.19-0ubuntu0.19.10.3 |
| version_comment | (Ubuntu) |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
| version_compile_zlib | 1.2.11 |
+--------------------------+-------------------------------+

When connecting via MySQL Workbench, an error occurs:

[Window Title]
MySQL Workbench

[Main Instruction]
Cannot Connect to Database Server

[Content]
Your connection attempt failed for user 'user' to the MySQL server at 192.168.1.65:33060:
Protocol mismatch; server version = 11, client version = 10

Please:
1 Check that MySQL is running on address 192.168.1.65
2 Check that MySQL is reachable on port 33060 (note: 3306 is the default, but this can be changed)
3 Check the user rroott has rights to connect to 192.168.1.65 from your address (MySQL rights define what clients can connect to the server and from which machines)
4 Make sure you are both providing a password if needed and using the correct password for 192.168.1.65 connecting from the host address you're connecting from

[Close]

Someone was able to fix this error?

Options: ReplyQuote


Subject
Views
Written By
Posted
Protocol mismatch; server version = 11, client version = 10
33188
February 11, 2020 03:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.