MyCATApache/Mycat-Server

2013-Lost connection to MySQL server at 'reading initial communication packet'

Open

#2913 opened on Jun 9, 2022

View on GitHub
 (3 comments) (0 reactions) (0 assignees)Java (9,451 stars) (3,886 forks)batch import
help wanted

Description

**描述你使用过程中遇到的问题: ** 使用navicat打开mycat连接提示以下截图信息，请问是什么问题！ mycat版本：8.0.20-mycat-1.6.7.6-release-20220119212903 image

Contributor guide

Tech stack
javasqlmysql
Domain
databasebackend
Issue type
bug
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
half day
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
stale
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
needs investigation
Prerequisites
MySQL connection basicsMycat configuration
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
25
Research direction
Review the three issue comments for any additional context or attempted solutions. Examine Mycat's MySQL connection handling code, particularly the handshake packet processing in the net module. Look for known compatibility issues between Mycat 1.6.7.6 and MySQL 8.0, especially regarding authentication methods like caching sha2 password. Check if the issue is related to missing or incorrect MySQL server configuration.