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

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.
主站蜘蛛池模板: 驻马店市| 鄢陵县| 万安县| 芜湖市| 北安市| 奈曼旗| 嘉兴市| 阜宁县| 衡水市| 富平县| 淮滨县| 揭西县| 闽清县| 武安市| 汕尾市| 苏尼特右旗| 茌平县| 若羌县| 龙门县| 丰镇市| 连江县| 娄底市| 卢龙县| 五指山市| 大余县| 磐石市| 南昌市| 英德市| 宣汉县| 离岛区| 富川| 沂源县| 安远县| 广州市| 安乡县| 辰溪县| 安福县| 临漳县| 揭阳市| 平阳县| 保靖县|