Configure MySQL
- Start MySQL Workbench and connect to the MySQL database server.
- Create a new schema with the following settings:
- Name: whd
- Collation type:
utf8 - utf8_general_ci
- Open the Configuration > Options File.
- Configure the following settings:
- Networking - Port:
3306
- General - default-storage-engine:
InnoDB
- Misc - init_connect:
SET NAMES utf8
- Stop and then restart the server.
- Configure the Users and Privileges settings with the following:
- Login Name: whd
- Password:
<your_password>
- Limit Connectivity to Hosts Matching:
localhost
- Configure your Schema Privileges.
- Select the whd user.
- Add a new entry with your host in the Host box.
- In the Schema box, select
Selected Schema
andwhd
and click OK. - Select all Object, DDL, and Other rights check boxes.
- Save your changes.
(Optional) Enable SSL encryption
See Enable SSL encryption for a MySQL database for details.