Submit a ticketCall us

whitepaperYour VM Perplexities Called, and They Need You to Read This.

Virtualization can give you enormous flexibility with future workloads and can be a key enabler for other areas, like cloud computing and disaster recovery. So, how can you get a handle on the performance challenges in your virtual environment and manage deployments without erasing the potential upside? Learn the four key areas you need to be focusing on to help deliver a healthy and well-performing data center.

Get your free white paper.

Home > Success Center > Web Help Desk (WHD) > Web Help Desk (WHD) Documentation > Web Help Desk Administrator Guide > Set up the application > Configure MySQL

Configure MySQL

Table of contents
No headers
Created by Steve.Hawkins, last modified by Anthony.Rinaldi_ret on Jul 18, 2016

Views: 864 Votes: 0 Revisions: 3
  1. Start MySQL Workbench and connect to the MySQL database server.
  2. Create a new schema with the following settings:
    • Name: whd
    • Collation type: utf8 - utf8_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.
 
Last modified

Tags

Classifications

Public