非你网

操作吧

create database shenqi_db default character set utf8mb4 collate utf8_general_ci;

create database 数据库名 default character set utf8mb4 collate utf8mb4_unicode_ci;

### 添加用户
// 用户名@连接ip  localhost为本地  %为任意ip
create user '用户名'@'localhost' identified by '密码'
create user '用户名'@'%' identified by '密码'
create user '用户名'@'111.111.111.111' identified by '密码'

### 授权
grant all on 数据库名.* to '用户名'@'localhost';
//localhost根据需求进行更改