mysql 备份用户_mysql用户管理与备份

用户管理

我们知道在Mysql中root用户是最高权限的用户，其他用户的创建和权限授予都是通过root用户来操作的

查看用户

在root用户界面下

select user,host,password from mysql.user;

```sql

+------+-----------+-------------------------------------------+

| user | host | password |

+------+-----------+-------------------------------------------+

| root | localhost | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |

| root | 127.0.0.1 | |

| root | ::1 | |

| | localhost | |

+------+-----------+-------------------------------------------+

```

## 创建用户

### 指定ip和用户名登录

指定ip为192.168.1.17的mm用户登录

create user 'mm'@'192.168.1.17' identified by '123';

identified by 'password'表示为创建的用户设置密码，可以省略

+------+--------------+-------------------------------------------+

| user | host | password |

+------+--------------+-------------------------------------------+

| root | localhost | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |

| root | 127.0.0.1 | |

| root | ::1 | |

| | localhost | |

| mm | 192.168.1.17 | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |

+------+--------------+-------------------------------------------+

### 指定ip地址段和用户名登录

指定ip地址段的mm用户登录

create user 'mm'@'192.168.1.%' identified by '123';

```sql

+------+--------------+-------