connection error - Githubissues

mtxr / vscode-sqltools

Database management for VSCode

https://vscode-sqltools.mteixeira.dev?utm_source=github&utm_medium=homepage-link

MIT License

1.48k stars 296 forks source link

connection error #990

Closed Anwen954 closed 1 year ago

Anwen954 commented 1 year ago

Describe the bug ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

To Reproduce Steps to reproduce the behavior:

MySQL版本 mysql Ver 8.0.28 for Win64 on x86_64 (MySQL Community Server - GPL)
操作系统名称 Microsoft Windows 11 专业版
操作系统版本 10.0.22000 版本 22000
报错信息 ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Expected behavior 测试连接成功

Screenshots

Desktop (please complete the following information):

SQLTools Version v0.25.1
VS Code Version: 1.71.2
OS: Windows
Driver:
- [ ] PostgreSQL/Redshift
- [x] MySQL/MariaDB
- [ ] MSSQL/Azure
- [ ] SQLite
- [ ] Other? Which...
Database version: MySQL Ver 8.0.28 for Win64 on x86_64 (MySQL Community Server - GPL)

gjsjohnmurray commented 1 year ago

Please see https://vscode-sqltools.mteixeira.dev/en/drivers/mysql/ where there is a section titled "MySQL 8 and ER_NOT_SUPPORTED_AUTH_MODE".