Hands-On Spring Security 5 for Reactive Applications

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', ...