Set Up MySQL

This updates the MySQL setup to the project configuration as of September 2020.

The database configuration, user login and password, must match that in .../src/main/resources/application.properties or the Java Data Base Connection will fail.

The Schema Name (MySQL term for a database) is nist-cts-eml; the user name is eml, and the password is as shown. (In a deployment there are ways to avoid clear text for passwords).

Creating the Database

Database initialization was done using MySql Community Edition and Workbench 8.0.18 on Mac OS X 10.15.2. SpringTool Suit 4 and JDBC will initialize the database with no manual intervention when using the development environment mentioned before., but the schema/database itself and use need to be created first.

If you are not using this environment, you may have to create the database and schemas manually.

Manual Database Initialization:

1. In MySql Workbench, create a new user eml with the password capstone@123.
2. Create a new "Schema" (database shows with the disk icon) called nist_cts_eml
3. Give user eml permission to access nist_cts_eml from localhost
4. Remember to apply all changes and refresh the nist_cts_eml schema.
5. Run the project application in SpringToolSuite4
6. In MySql Workbench, refresh all for the schema nist_cts_eml.

Instructions for the creation using the command line are as follows. The MySQL root password was set on initialization. Remember that semicolon is the terminator for mysql commands, not a separator.

NOTE: These instructions set user name to eml@localhost and eml@localhost's password to capstone@123 as above

    mysql --user=root --password 
    create database nist_cts_eml;
    create user eml@localhost identified by "";
    grant all on nist_cts_eml.* to eml@localhost;

Notes

Some systems do not follow standards on use of localhost. If the user is not on localhost, the above instructions may require some care so the database runs, root works, and user eml work correctly.

The only use of MySQL as of June 2020 is for the Position Manager. The other tables have been retained for simplicity of development.