create user 'satoshi'@'localhost' identified by '150386';
grant all on *.* to 'satoshi'@'localhost';
CREATE DATABASE IF NOT EXISTS gengar DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
drop table if exists users;
CREATE TABLE IF NOT EXISTS `users`(
`id` INT UNSIGNED AUTO_INCREMENT,
`name` VARCHAR(30) NOT NULL,
`password` VARCHAR(60) NOT NULL,
`salt` VARCHAR(20) NOT NULL,
`status` TINYINT NOT NULL DEFAULT 0,
PRIMARY KEY ( `id` )
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
- Jwt 登陆验证
- 链接 Mysql 的 DAO 层
- 用户 CRUD
- 中间件拦截 request
- 拦截器拦截 response
- 拦截器规范化返回值结构
- 过滤器处理全局错误
- 日志记录系统
- Axios 请求
- Swagger UI
以管理员权限启动 cmd.exe,进入 mysql 中运行以下命令:
alter user 'satoshi'@'localhost' identified with mysql_native_password by '150386';
flush privileges;
去你妹的 windows