---
title: MySQL免密配置
description: "“username”为个人用户，“%”为多节点免密设置，“*.*”为个人用户赋予所有数据库权限。"
url: https://www.hikunpeng.com/document/detail/zh/kunpengdevkithistory/devkit_24/usermanual/kunpengoper_06_0031.html
sourcePath: /source/zh/kunpengdevkithistory/devkit_24/usermanual/kunpengoper_06_0031.html
indexId: b88427c5d52a59537cf80852e9418edcc8aeb18486dee855019982e6c7b0bf0177
---
# MySQL免密配置

“username”为个人用户，“%”为多节点免密设置，“*.*”为个人用户赋予所有数据库权限。


1. 如无使用的用户，创建免密用户。

```
mysql> CREATE USER 'username'@'%' IDENTIFIED BY '';
mysql> flush privileges;
```


2. 若已创建用户，修改其为免密用户。

```
mysql> ALTER USER 'username'@'%' IDENTIFIED BY '';
mysql> flush privileges;
```


3. 创建数据库,并赋予该用户权限

```
mysql> CREATE DATABASE test;
mysql> flush privileges;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'username'@'%';
mysql> flush privileges;
```