tauri-apps / tauri-apps/plugins-workspace

[bug] mysql Using password: NO

Open
#2,899 0 comments 0 reactions 0 assignees View on GitHub
plugin: sql status: help wanted type: question
Dominant language
Rust
Stars
1.8k
Forks
602
Avg merge
4d 14h
Merged PRs (30d)
9

Description

### Describe the bug

1、使用文档中方式,创建最新的项目,按照:https://tauri.app/zh-cn/plugin/sql/ 文档完成了。
2、本地或远程搭建不通版本的 mysql 。能使用 `Navicat Premium 15`连接都能成功且看到数据库以及表。
3、tauri中的sql一直连不上,经过大量测试都出现以下结果:

```
error returned from database: 1045: Access denied for user: '�@localhost' (Using password: NO)
```

4、使用其他程序使用 .NET或node的都能连接上还能查询

### Reproduction

1. 创建项目

```bash
npm create tauri-app@latest
```

2. 通过文档 https://tauri.app/zh-cn/plugin/sql/ 开放权限以及安装 [crates.io](https://tauri.app/zh-cn/plugin/sql/#tab-panel-2200) 依赖。

```bash
npm add @tauri-apps/plugin-sql
```

3. src-tauri/src/main.rs 注册插件

```rs
fn main() {
tauri::Builder::default()
.plugin(tauri_plugin_sql::Builder::default().build())
.run(tauri::generate_context!())
.expect("error while running tauri application");
}
```

```js
import Database from '@tauri-apps/plugin-sql';

// 这里执行
const db = await Database.load('mysql://user:pass@host/database');
await db.execute('INSERT INTO ...');
```

### Expected behavior

能连接,新增、查询、删除数据

### Full `tauri info` output

```text
error returned from database: 1045: Access denied for user: '�@localhost' (Using password: NO)
```

### Stack trace

```text

```

### Additional context

_No response_

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.