MYSQL 导不进去

来源:2-2 初始化数据库

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;



    qq_31画...

    这个确实可以,感谢分享

    2023-04-13 18:37:13

    共 2 条回复 >

MyBatis-Plus + SpringBoot实现简单权限管理

通过实战项目掌握MyBatis-Plus应用!

12728 学习 · 133 问题

查看课程

相似问题