Installation using MySQL database

Proceed with the installation of the MySQL database

MySQL 8.0.x) Download the MSI installer: https://dev.mysql.com/downloads/installer/

Perform the installation of MySQL

MySQL Database Usage

• select Typical as type of setup
  
• select Detailed Configuration
  
• select Developer Machine
  
• select Multifunctional Database
  

Proceed to complete the installation

the most important thing in my opinion is set the usage of the database as Multifunctional.

Connect to the server and create the DB schema for LogicalDOC

launch the MySQL Command Line Client

connect as root with the password you previously asseigned to the user.

launch the following commands:

CREATE DATABASE logicaldoc;

GRANT ALL PRIVILEGES ON *.* TO 'logicaldoc'@'%' IDENTIFIED BY 'sa' WITH GRANT OPTION;
(this create a user 'logicaldoc' with password 'sa' that can access the db from every host)

FLUSH PRIVILEGES;

COMMIT;

EXIT;

Run the setup of LogicalDOC

Log on to the setup of your. application LogicalDOC
http://localhost:8080/logicaldoc/setup/

Select the MySQL DB

Database Configuration

enter the jdbc Connection Url for the database:
jdbc:mysql://localhost:3306/logicaldoc?allowPublicKeyRetrieval=true&useSSL=false&serverTimezone=UTC

specify "logicaldoc" as the Username, "sa" as the Password

Start the creation of tables and the population of the initial data by pressing the button on the right (Continue).