Versions Compared

Old Version 2

changes.mady.by.user Kevin Pham

Saved on

compared with

New Version Current

changes.mady.by.user Kevin Pham

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
Top
Top

Column

This section applies specifically to the Zephyr Enterprise being able to connect to an external database. The information below is generally used to ensure that system administrators can connect their Zephyr Enterprise to a MySQL database.

The

database

for Zephyr Enterprise Data Center will be referenced as part of the installation of Zephyr Enterprise Data Center. It will need to be installed separately and prior to the installation of Zephyr Enterprise Data Center. These instructions will help you connect your Zephyr Enterprise Data Center installation to a Microsoft SQL Server Database

.


This guide is for setting up a instance of MySQL to allow use for Zephyr Enterprise Server and Data Center. This guide assumes MySQL is already present and in its desired root location

...

.

Supported Databases

...

MySQL Community Server

...

Code Block
languagejs
CREATE USER 'zephyrDBuser@'localhost' IDENTIFIED BY 'zephyrDBuserPass';


Anchor
step3
step3

Step 3: Set permissions for remote access

Now type the below command to make the Database accessible remotely.

...

Set the following values for the parameters:

ParameterMinimum value
innodb_buffer_pool_size=4096M
query_cache_size=1M
key_buffer_size=8M
max_connections=500

If no lines contain these parameters, then create new lines for them.

...

Info
titleNote

MySQL Logging

If you are having problems with your MySQL database after making these changes, please consult your OS's application logs for issue details.


Back to Top ^