MYSQL 5.7 Windows FailOver Cluster gives Format of the initialization string does not conform to specification starting at index 68 error on Service Start (Doc ID 2107830.1)

Last updated on MARCH 28, 2017

Applies to:

MySQL Server - Version 5.7 and later
Microsoft Windows x64 (64-bit)
This only appears to affect Windows Server 2012 R2 version.

Symptoms

On : 5.7 version, Installation and Upgrading

MYSQL 5.7 Windows FailOver Cluster

- Running into troubles configuring MYSQL in a server 2012 R2 failover cluster. Following the attached documentation I edited the my.ini file to point to the binaries clusterd shared volume but the resource group doesn't start the service.


ERROR
-----------------------
Format of the initialization string does not conform to specification starting at index 68


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Setup Windows Cluster on hosts
2. Install MySQL on Windows Cluster hosts
3. Attempt to start the service.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot effectively start the mysqld service.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms