Write the Code. Change the World.

8月 29

操作吧

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根据需求进行更改

发表回复

您的电子邮箱地址不会被公开。 必填项已用*标注