As of version 14.1, PrizmDoc Server requires a connection to a Central Database. At this time, MySQL 8.0 is the only supported database.


On Windows using Docker


Installing and configuring MySQL Database

  1. Download and run MySQL Installer - https://dev.mysql.com/downloads/installer/
  2. Choose Setup Type: Full and click install
  3. Configure your MySQL Server in the installer:
    • Config Type: Choose "Development" if you are testing in a development environement, or "Server" for a production environment that will also be running PrizmDoc Server
    • Create a user with Admin access for PrizmDoc
    • Everything else can be left as default
  4. After installation is complete, open MySQL Workbench
  5. On the left side in the "Navigator" section, click on the "Schema" tab
  6. Left click anywhere in this tab and click "Create Schema"
  7. Name your schema and click apply (ex. "prizmdoc_server_db")
  8. Review and Apply SQL Script in the pop up menu


Configuring PrizmDoc Server connection to database

  1. We recommend you create a dedicated database for PrizmDoc and a restricted database user that only has permissions for this database. Make sure the PrizmDoc user has all privileges to this database.
  2. Provide the connection string in the PrizmDoc installer

  3. Post installation you can use the database.connectionString central configuration parameter to specify the connection string to the database.