MySQL parameter file and parameter modification method

MySQL parameter file:

MySQL database initialization parameters are set by the parameter file, and if no parameter file is set, MySQL starts with the default values of the parameters in the system.

On Windows and Linux, parameter files can be placed in multiple locations, the database starts in a different order to search, if multiple locations have parameter files, the search order parameters in the parameter file will overwrite the previous parameters.

Parameter file read order on Windows

Parameter file read order on Linux

Modify MySQL method of the parameter:

MySQL parameter file and parameter modification method