### [Navicat连接MySQL-插件密码报错](https://www.isearch.life/article/411)

**Published:** 2026-03-02T09:10:31

**Author:** tearell

**Excerpt:** 切换mysql_native_password插件 终端登录mysql mysql -h localhost -u root -p 查看用户以及密码插件 mysql> SELECT Host, User, plugin from us

## 切换mysql\_native\_password插件

### 终端登录mysql

```
mysql -h localhost -u root -p
```

### 查看用户以及密码插件

```
mysql> SELECT Host, User, plugin from user;
+-----------+------------------+-----------------------+
| Host      | User             | plugin                |
+-----------+------------------+-----------------------+
| %         | root             | caching_sha2_password |
| localhost | mysql.infoschema | caching_sha2_password |
| localhost | mysql.session    | caching_sha2_password |
| localhost | mysql.sys        | caching_sha2_password |
| localhost | root             | caching_sha2_password |
+-----------+------------------+-----------------------+
5 rows in set (0.00 sec)
```

### 还原插件

```
mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
```

**Tags:** 教程, 知识, 软件开发

**Categories:** 精选

---