Configure MySQL

  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.

(Optional) Enable SSL encryption

See Enable SSL encryption for a MySQL database for details.