---
title: "Mysql Commands"
date: 2021-06-08T17:45:30+07:00
draft: false
tags: []
---

### 

```shell
mysql> DESCRIBE business.student;
mysql> DESC business.student;
mysql> show create table business.student;
```

### 用户和授权

```shell
CREATE USER 'username'@'host' IDENTIFIED BY 'password';
GRANT privileges ON database.table TO 'username'@'host';

# 举例

CREATE USER 'admin'@'localhost' IDENTIFIED BY '123456';
GRANT all ON *.* TO 'admin'@'localhost'

CREATE USER 'admin'@'%' IDENTIFIED BY '123456';
GRANT SELECT,INSERT ON test.user TO 'admin'@'%'
```