mysql5.6
```
CREATE USER '用户名'@'localhost' IDENTIFIED BY '密码';（创建用户）
```
```
grant select,update on 数据库.表名 to 用户名 identified by '密码';（给账户赋权限）
```
mysql8.0.13
```
create user 'mayiic_dev'@'%' identified by 'mayiic123';
```
```
grant insert,select,update on test01.* to 'mayiic_dev'@'%';
```
修改用户密码
···
ALTER USER 'newuser'@'%' IDENTIFIED WITH mysql_native_password BY '1qaz@WSX';
···
权限有create,select,insert,update,delete。
表名可以用*，表示数据库下的全部表
