11 lines
202 B
Markdown
11 lines
202 B
Markdown
# mysql操作记录
|
|
```shell
|
|
# 添加用户
|
|
CREATE USER 'username'@'host' IDENTIFIED BY 'password';
|
|
|
|
# 授权
|
|
GRANT ALL PRIVILEGES ON db.* TO 'username'@'host';
|
|
|
|
# 刷新权限
|
|
FLUSH ALL PRIVILEGES;
|
|
``` |