Which of following list the default order in which option files are read on UNIX?

The correct answer is B. /etc/my.cnf, $MYSQL_HOME/my.cnf, and ~/.my.cnf. On Unix, the search order includes two general option files, /etc/my.cnf and $MYSQL_HOME/my.cnf. The second file is used only if the MYSQL_HOME environment variable is set. Typically, you set it to the MySQL installation directory. (The mysqld_safe script attempts to set…

MySQL Configuration

Question

Options

A~/.my.cnf, $MYSQL_HOME/my.cnf, and /etc/my.cnf
B/etc/my.cnf, $MYSQL_HOME/my.cnf, and ~/.my.cnf
C$MYSQL_HOME/my.cnf, /etc/my.cnf, and ~/.my.cnf
D~/.my.cnf, /etc/my.cnf, and $MYSQL_HOME/my.cnf
E/etc/my.cnf, ~/.my.cnf, and $MYSQL_HOME/my.cnf

How the community answered

(31 responses)

A
3% (1)
B
84% (26)
C
10% (3)
E
3% (1)

Explanation

On Unix, the search order includes two general option files, /etc/my.cnf and $MYSQL_HOME/my.cnf. The second file is used only if the MYSQL_HOME environment variable is set. Typically, you set it to the MySQL installation directory. (The mysqld_safe script attempts to set MYSQL_HOME if it is not set before starting the server.) The Unix option file search order also includes ~/.my.cnf, that is, the .my.cnf file located in the home directory of the person running the program.

Topics

#option files#my.cnf#configuration order#UNIX

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice