Suppose you install a server with a service name of "MySQL5" rather than the default. What sections in the option files will the server use for configuration?

The correct answer is B. [MySQL5] D. [mysqld]. If you install a server using a service name other than MySQL and do not specify a --defaults-file option, the server reads options in the standard option files from the [my_service] group in addition to options from the [mysqld] group.

MySQL Configuration

Question

Options

A[service]
B[MySQL5]
C[service MySQL5]
D[mysqld]
E[mysqld MySQL5]

How the community answered

(37 responses)

A
14% (5)
B
78% (29)
C
5% (2)
E
3% (1)

Explanation

If you install a server using a service name other than MySQL and do not specify a --defaults-file option, the server reads options in the standard option files from the [my_service] group in addition to options from the [mysqld] group.

Topics

#option files#Windows service name#mysqld section#named service

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice