[IAG] Failed to start MySQL service in secondary development of database — configuration file encoding problem

Problem Description

The data center needs to configure secondary development and install MySQL software. After configuring the MySQL configuration file according to the secondary development document, it is found that the service cannot be started.
When starting the MySQL service from the command line, the message "error: Found option without preceding group in config file: D:\mysql-5.7.27-win64\my.ini at line: 1  Fatal error in defaults handling. Program aborted”

Process——

1. Using the default my.ini file, the service can be started
2. After replacing the my.ini file, the service cannot be started

Root cause

The my.ini file format is utf-8

solution

Save the my.ini file as an ANSI format file and restart the MySQL service to normal

179045d53aeea295b1.png (65.8 KB)

Original Link

https://support.sangfor.com.cn/cases/list?product_id=22&type=1&category_id=7063&isOpen=true