Configure MySQL

To configure MySQL for your Web Help Desk deployment, use MySQL Workbench to connect to the MySQL database server and set up the database. To preserve your system resources, disable the PostgreSQL service on the Web Help Desk server.

1. Start MySQL Workbench and connect to the MySQL database server.
2. If you are running MySQL 5.7, create a new schema with the following settings:
• Name: WHD
• Collation type: utf8 - utf8_general_ci

If you are running MySQL 8, create a new schema with the following settings:

• Name: WHD

• Collation type: utf8mb4 - utf8mb4_general_ci

3. Open the Configuration > Options File.
4. Configure the following settings:
• Networking - Port: 3306
• General - default-storage-engine: InnoDB
• Misc - init_connect: SET NAMES utf8
5. Stop and then restart the server.
6. Configure the Users and Privileges settings with the following: 
• Login Name: WHD
• Password: <your_password>
• Limit Connectivity to Hosts Matching: localhost
7. Configure your Schema Privileges.
1. Select the WHD user.
2. Add a new entry with your host in the Host box.
3. In the Schema box, select Selected Schema and WHD and click OK.
4. Select all Object, DDL, and Other rights check boxes.
8. Save your changes.

(Optional) Enable SSL encryption

See Enable SSL encryption for a MySQL database for details.

Disable the PostgreSQL service

If you are using MySQL as your Web Help Desk database, disable the PostgreSQL service in the Windows Server operating system. This will preserve your system resources and prevent users from setting PostgreSQL as your primary database.

1. Log in to the Web Help Desk server as an administrator.

2. Go to Services.

3. Locate the following service:

   Web Help Desk PostgreSQL Embedded Database

4. Right-click the service and select Properties.

5. Set the Status type to Disabled.

6. Set the Service status to Stopped.

7. Click Apply, and then click OK.