MySQL Forums
Forum List  »  MySQL Workbench

Re: Protocol mismatch; server version = 11, client version = 10
Posted by: marvin tang
Date: October 02, 2020 11:55AM

1. Usually it means you are on X protocol,
https://dev.mysql.com/doc/mysql-port-reference/en/mysql-ports-reference-tables.html

2. use [netstat -an|grep 3306] to check if 3306 port is opened.
you should get something likes below

tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN
tcp6 0 0 :::33060 :::* LISTEN

if you have 127.0.0.1 in front of 3306, then you need to disable the binding.

in mysql 8, it is
[sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf]

use # to disable the line of bind-address = 127.0.0.1, then save,
restart mysql and check port again.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Protocol mismatch; server version = 11, client version = 10
185
October 02, 2020 11:55AM


Sorry, only registered users may post in this forum.

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.