...

• Check whether your version of MySQL is supported
• If you are upgrading from Zephyr Enterprise 4.7, a MySQL Database will already be present, so you won't need to install this again
• Have an installation of MySQL ready
• Ensure the JDBC driver is stored locally on the Application Server where Zephyr Enterprise will be installed

Configure the MySQL Database

...

The following steps will need to be followed:

• Step 1: Login to your MySQL Server
  
• Step 2: Create a new user for Zephyr
  
• Step 3: Set permissions for remote access
• Step 4: Set Memory and Max Connections
• Step 5: Install Zephyr Enterprise and Connect to the Database

Anchor
step1 step1

Step 1: Login to your MySQL Server

...

Create a new database user which Zephyr Enterprise will connect as. The command to create a new user is seen below:

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.

...

zephyrDBuser represents the username and ZephyrDBuserPass is the password for the newly created user from Step 2.

The '*.*' is granting permissions to all databases. Replace 127.0.01 with the IP address of the server Zephyr Enterprise will be installed on. This command will grant access to ALL databases for the IP addresses given. The minimum permission requirement are the privileges to create and populate tables.

...

Set the following values for the parameters:

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

...

SELECT @@innodb_buffer_pool_size;

SHOW VARIABLES LIKE 'query_cache_size';

SHOW VARIABLES LIKE ' key_buffer_size ';

SHOW VARIABLES LIKE 'max_connections';

Anchor
step5 step5

Step 5: Install Zephyr

...

and Connect to the Database

Now the MySQL database is ready, open the Zephyr Enterprise installer. The wizard will take you through the setup steps.

...

Back to Top ^