How to install PrizmDoc version 14.1+ with database requirement?

Modified on Tue, Nov 26, 2024 at 10:25 AM

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.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article