1. 创建用户并授权

1.1 创建用户

create user test@'%' identified by '123456';

1.2 授权

# 只读用户授权
GRANT SELECT ON `test`.* TO 'test'@'%';
# 业务用户授权
GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE ON `test`.* TO 'test'@'%';

2. 创建数据库，表

CREATE TABLE student (
    id int UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(20) NOT NULL,
    age tinyint UNSIGNED,
    gender ENUM('M','F') default 'M'
)ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

3. 表操作