mysql添加用户并赋予权限

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。

表名可以用*，表示数据库下的全部表