官术网_书友最值得收藏!

Step 3—MySQL database schema setup

Create a default database schema using the following scripts, and insert some users:

create table users(
username varchar(75) not null primary key,
password varchar(150) not null,
enabled boolean not null
);
create table authorities (
username varchar(75) not null,
authority varchar(50) not null,
constraint fk_authorities_users foreign key(username) references users(username)
);

Insert data into the preceding tables using the following scripts:

insert into users(username, password, enabled)
values('admin', '$2a$04$lcVPCpEk5DOCCAxOMleFcOJvIiYURH01P9rx1Y/pl.wJpkNTfWO6u', true);
insert into authorities(username, authority)
values('admin','ROLE_ADMIN');
insert into users(username, password, enabled)
values('user', '$2a$04$nbz5hF5uzq3qsjzY8ZLpnueDAvwj4x0U9SVtLPDROk4vpmuHdvG3a', true);
insert into authorities(username,authority)
values('user','ROLE_USER');

The password is one-way hashed using online tool http://www.devglan.com/online-tools/bcrypt-hash-generator. To compare the password we will use PasswordEncoder (Bcrypt).

Credentials are as follows:

  • User = admin and password = admin@password
  • User = user and password = user@password
It's important to note that, even though the role is named ROLE_ADMIN, the actual name is ADMIN, and this is what our code will be using while passing.
主站蜘蛛池模板: 柏乡县| 台湾省| 息烽县| 尉氏县| 兴国县| 喀喇沁旗| 乌海市| 新竹县| 平凉市| 玛多县| 长汀县| 金昌市| 万安县| 东丽区| 西林县| 营口市| 中江县| 安图县| 牟定县| 扎兰屯市| 浦东新区| 长宁县| 东辽县| 邵阳县| 元朗区| 泉州市| 株洲县| 曲麻莱县| 体育| 盐城市| 晋江市| 莆田市| 略阳县| 淳化县| 沙河市| 城固县| 曲水县| 宁晋县| 扎鲁特旗| 苗栗市| 涪陵区|