Question 327008 in Mysql Question posted in
The official MySQL documentation can be found here.

mysql configuration file order of read

I was reading about my.cnf in mysql docs and I dont understand this part

On Unix and Unix-like systems, MySQL programs read startup options from the files shown in the following table, in the specified order (files listed first are read first, files read later take precedence).

I am in doubt if the meaning of this text is that configuration in later files overwrite the same configuration in first files read

Thanks

Tags:

2

Answers


  1. 0

    files read later take precedence

    means that if you have the same option in multiple files, the setting in the last file that’s read will be used.

    Login or Signup to reply.
  2. 0

    At startup, the server assigns default values to all option variables. Then it loads the option files one by one and analyzes them line by line. If the value in the current row sets the value of any variable, then this change is applied. Finally, the value of a variable is equal to the value that was specified in the row that was read most recently for that variable, or remains the default value if no row changes its value.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search