walinejs / waline

💬 A Simple, Safe Comment System
https://waline.js.org/en/
GNU General Public License v2.0
2.27k stars 397 forks source link

[Bug]: 连接mysql8.4客户端异常 || [Bug]: Exception when connecting to mysql8.4 client #2640

Closed wxywizard closed 3 months ago

wxywizard commented 3 months ago

问题描述 | Describe the bug

连接mysql8.4客户端异常

CleanShot 2024-08-01 at 18 17 48@2x 希望升级下客户端

问题网站 | Website URL

https://togowill.com

服务部署在哪里? | Where your waline deploy?

Self Host

数据存储在哪里?| Where your comment data store?

MySQL


Problem description | Describe the bug

Abnormal connection to mysql8.4 client

CleanShot 2024-08-01 at 18 17 48@2x Hope to upgrade the client

Question Website | Website URL

https://togowill.com

Where is the service deployed? | Where your waline deploy?

Self Host

Where is the data stored? | Where your comment data store?

MySQL

lizheming commented 3 months ago

https://github.com/walinejs/waline/issues/2119

wxywizard commented 3 months ago

2119

为什么不能更换模块适配mysql8呢? 并且mysql8官方文档说明mysql_native_password这种加密方式已经过时了

下面这个示例不行吗?

npm un mysql && npm i mysql2  

// 导入myslq模块
const mysql = require('mysql2')

2119

Why can't the module be replaced to adapt to mysql8? And the official documentation of mysql8 states that the encryption method mysql_native_password is obsolete.

Doesn’t the following example work?

npm un mysql && npm i mysql2

//Import the myslq module
const mysql = require('mysql2')
lizheming commented 3 months ago

https://github.com/thinkjs/thinkjs/issues/1354 我们使用的底层框架还不支持这块,底层框架使用的场景比较多,不太好贸然更换底层连接器。之后我们按照你的建议处理下。


https://github.com/thinkjs/thinkjs/issues/1354 The underlying framework we use does not support this yet. The underlying framework is used in many scenarios, so it is not easy to replace the underlying connector rashly. Then we will deal with it according to your suggestions.