Dependencies
Build
To test the project, you are supposed to execute the command on your shell.Login your own mysql DBMS.
mysql -uroot -p
Then input your password.
create a user named workstationManager and set password with 1234.Then exit.
CREATE USER 'workstationManager'@'localhost' IDENTIFIED BY '1234';
create a new database.
create database workstationManagement;
grant privileges to user.
grant all privileges on workstationManagement.* to workstationManager;
reload
exit;
mysql -uworkstationManager -p1234
create a new table.
use workstationManagement;
CREATE TABLE Account(
userName VARCHAR(10) primary key,
password VARCHAR(32) NOT NULL
);