MySQL Configuration Directions

[ghost]

In Method 4 using the WAR file, it would be nice to have some directions on how mySQL server needs to be installed and configured in order for the JDBC connection to work properly. I have spent a good 15-20 hours trying to get the install to work including attempting to debug the source code using Eclipse, but have not successfully gotten the db scripts to connect or run. I am running the application on the following:
Tomcat 8.5x - app is deployed and running successfully
Windows Server 2012
MySQL 5.5.62 - full install with all default values

The docker and VM methods work great, but I'd like to be able to show a full deployment of the application to new users.

[ghost]

LOL...literally 5 minutes after I wrote this...I got it working. For those of you struggling with method 4. Make sure to install mySQL 5.5.62 and change the jdbc url to jdbc:mysql://localhost:3306/

Also make sure if installing mySQL on Windows to change the service name to mysql instead of MYSQL55

You can leave everything else default and db scripts will run.

[nofacenonamedude]

Had the same issue with the Docker installation. The mysql version in the docker image is version: '8.0.17'

1- Simply change the pom.xml dependency for mysql-connector-java from version '5.1.26' to version '8.0.17' so that the JDBC driver can talk to the mysql service (they have to be the same version) and save the file.

2- rebuild the image using the command below
sudo docker-compose build

3- bring up the machine
sudo docker-compose up

PS: Do not change anything on the instal.jsp screen. eg: leave the JDBC URL as: 'jdbc:mysql://mysql:3306/'