Ryon`s Life

DataBase/MySQL +2
    

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.


<12 class="hx cmt">
    

* Mysql 서비스 등록 명령어

1. cmd 창에서 mysql 설치 디렉토리의 bin 디렉토리로 이동

2. mysqld --install [서비스명]

3. 2.번의 명령어 입력



* Mysql 서비스 삭제 명령어

1. cmd 창에서 

2. sc delete 서비스명

3. 2.번의 명령어 입력


<12 class="hx cmt">