When starting the mysqld program, which of the following statements are true?

The correct answer is E. Startup options can be given either in option files, or as parameters on the command line, except. The --install command does not actually start the server. It only tells Windows to handle the server as a service, so that when Windows starts up and shuts down, it starts and stops mysqld automatically. The service also can be started or stopped manually from the command line…

MySQL Server Administration

Question

Options

AStartup options can only be given in option files.
BStartup options can only be given on the command line.
CStartup options can only be given on the command line except for Windows Services.
DStartup options can be given either in option files, or as parameters on the command line.
EStartup options can be given either in option files, or as parameters on the command line, except

How the community answered

(50 responses)

A
2% (1)
B
4% (2)
C
2% (1)
D
12% (6)
E
80% (40)

Explanation

The --install command does not actually start the server. It only tells Windows to handle the server as a service, so that when Windows starts up and shuts down, it starts and stops mysqld automatically. The service also can be started or stopped manually from the command line. To do so, use these commands: shell> net start MySQL shell> net stop MySQL MySQL is the service name for MySQL. It can be given in any lettercase.

Topics

#startup options#option files#command line#mysqld configuration

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice