mysql8创建新用户和数据库并授权

```

create database 数据库名 character set utf8;

create user '用户名'@'%' identified with mysql_native_password by '密码';

create user '用户名'@'localhost' identified with mysql_native_password by '密码';

grant all privileges on 数据库名前缀.* to '用户名'@'%';

```

© 本文著作权归作者所有。转载请联系授权，禁止商用。