pingcap / pingcap/tidb

using MySQL 5.5 and 5.6 clients connecting with a passwordless account to tidb fail

Open
#32,334 7 comments 0 reactions 1 assignee Claimed by @dveeden View on GitHub
found/automation severity/minor sig/sql-infra type/bug
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Bug Report

Please answer these questions before submitting your issue. Thanks!

### 1. Minimal reproduce step (Required)

1. download 5.5 and 5.6 version MySQL client
dbdeployer downloads get-unpack mysql-5.5.62.tar.xz
dbdeployer downloads get-unpack mysql-5.6.44.tar.xz
2. create use nopw with no password,
CREATE USER 'nopw'@'%' IDENTIFIED WITH mysql_native_password
3. use 5.5 and 5.6 MySQL client connect to tidb nightly version(v5.5.0-nightly-20220208) with this "nopw" user

### 2. What did you expect to see? (Required)
connect successully
### 3. What did you see instead (Required)
root@wkload-0:/upgrade-test# /root/opt/mysql/5.5.62/bin/mysql -u nopw -h tiup-peer -P3390
ERROR 2012 (HY000): Error in server handshake

### 4. What is your TiDB version? (Required)

v5.5.0-nightly-20220208

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.