MYSQL 导不进去
weixin_慕斯卡2118945
2021-07-23 09:30
MYSQL 导不进去
2回答
-
- 老猿
- 2021-08-06 11:09:43
你使用的是mysql8.0吗，我使用的是mysql8.0？如果不行你参考留言的这位同学的语句试试。
-
- 慕尼黑2537140
- 2021-07-23 15:09:22
低版本 用这个文件 自动创建用户 用户名project 密码 project
CREATE DATABASE IF NOT EXISTS project;
use project;
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
CREATE USER 'project'@'%' IDENTIFIED BY 'project';
grant all privileges on project.* to 'project'@'%' identified by 'project';
flush privileges;
DROP TABLE IF EXISTS `account`;
CREATE TABLE `account` (
`account_id` bigint(0) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`role_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '角色id',
`username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户名',
`password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密码',
`salt` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '加密盐',
`real_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '真实姓名',
`sex` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '性别',
`email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`modified_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
`create_account_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '创建人',
`modified_account_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '修改人',
`deleted` tinyint(0) UNSIGNED NULL DEFAULT 0 COMMENT '逻辑删除标识(0、否 1、是)',
PRIMARY KEY (`account_id`) USING BTREE
) COMMENT = '账号表';
INSERT INTO `account` VALUES (1, 1, 'mp', '17a1640916cfa8356adc4336a72ac75d', 'ecbe5fac60d1499595fbb98dfa854501', '程序牛人', '男', 'mp@126.com', '2020-11-10 13:46:32', '2020-11-15 17:09:28', NULL, 1, 0);
DROP TABLE IF EXISTS `customer`;
CREATE TABLE `customer` (
`customer_id` bigint(0) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`real_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '真实姓名',
`sex` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '性别',
`age` tinyint(0) UNSIGNED NULL DEFAULT NULL COMMENT '年龄',
`email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱',
`phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号码',
`address` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地址',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`modified_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
`create_account_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '创建人',
`modified_account_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '修改人',
`deleted` tinyint(0) UNSIGNED NULL DEFAULT 0 COMMENT '逻辑删除标识(0、否 1、是)',
PRIMARY KEY (`customer_id`) USING BTREE
) COMMENT = '客户表';
DROP TABLE IF EXISTS `resource`;
CREATE TABLE `resource` (
`resource_id` bigint(0) UNSIGNED NOT NULL COMMENT '主键',
`parent_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '父id',
`resource_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资源名称',
`resource_type` tinyint(0) NULL DEFAULT NULL COMMENT '资源类型(0、目录 1、菜单 2、按钮)',
`url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求地址',
`code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限标识码',
`sort` int(0) UNSIGNED NULL DEFAULT NULL COMMENT '排序',
PRIMARY KEY (`resource_id`) USING BTREE
) COMMENT = '资源表';
INSERT INTO `resource` VALUES (1, NULL, '系统管理', 0, NULL, NULL, 1);
INSERT INTO `resource` VALUES (2, NULL, '客户管理', 0, NULL, NULL, 2);
INSERT INTO `resource` VALUES (11, 1, '角色管理', 1, 'role/toList', NULL, 1);
INSERT INTO `resource` VALUES (12, 1, '账号管理', 1, 'account/toList', NULL, 2);
INSERT INTO `resource` VALUES (21, 2, '客户管理', 1, 'customer/toList', 'customer', 1);
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
`role_id` bigint(0) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`role_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '角色名称',
`remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`modified_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
`create_account_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '创建人',
`modified_account_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '修改人',
`deleted` tinyint(0) UNSIGNED NULL DEFAULT 0 COMMENT '逻辑删除标识(0、否 1、是)',
PRIMARY KEY (`role_id`) USING BTREE
) COMMENT = '角色表';
INSERT INTO `role` VALUES (1, '练习角色', '练习角色', NULL, NULL, NULL, NULL, 0);
DROP TABLE IF EXISTS `role_resource`;
CREATE TABLE `role_resource` (
`role_resource_id` bigint(0) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`role_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '角色id',
`resource_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '资源id',
PRIMARY KEY (`role_resource_id`) USING BTREE
) COMMENT = '角色资源表';
INSERT INTO `role_resource` VALUES (1, 1, 1);
INSERT INTO `role_resource` VALUES (2, 1, 2);
INSERT INTO `role_resource` VALUES (3, 1, 11);
INSERT INTO `role_resource` VALUES (4, 1, 12);
INSERT INTO `role_resource` VALUES (5, 1, 21);
alter table account add constraint FK_account_role_id foreign key (role_id) references `role`(role_id);
alter table role_resource add constraint FK_role_resource_role_id foreign key (role_id) references `role`(role_id);
alter table role_resource add constraint FK_role_rerce_resourc_idD2D9 foreign key (resource_id) references `resource`(resource_id);
SET FOREIGN_KEY_CHECKS = 1;
MyBatis-Plus + SpringBoot实现简单权限管理
12697 学习 · 133 问题
相似问题