Mysql zip package 설치시 설정파일(My.ini) 경로 설정 방법

2.3.4.14. The Location of the my.ini File

In MySQL installations prior to version 4.1.5 it was customary to name the server configuration file my.cnf ormy.ini and locate the file either at c:\my.cnf or c:\Windows\my.ini.

The new MySQL Configuration Wizard places the my.ini file in the installation directory of the MySQL server. This helps associate configuration files with particular server instances.

To ensure that the MySQL server knows where to look for the my.ini file, an argument similar to this is passed to the MySQL server as part of the service installation:

--defaults-file="C:\Program Files\MySQL\MySQL Server 4.1\my.ini"

Here, C:\Program Files\MySQL\MySQL Server 4.1 is replaced with the installation path to the MySQL Server. The --defaults-file option instructs the MySQL server to read the specified file for configuration options when it starts.