Vidyalelo
MySQL · Q57

MySQL

Programming · MySQL · question 57

Q57

The server listens on a network port for TCP/IP connections unless started with the option . . . . . . . .

A.
-networking
B.
-skip-networking
Answer
C.
-skip-networks
D.
-quit-networking

Answer: Option B

Solution

Answer: Option B
Solution:
-skip-networking: This option is used to instruct the MySQL server not to listen for TCP/IP network connections. When this option is specified during server startup, the MySQL server does not open the network port for incoming connections, effectively preventing remote clients from connecting via TCP/IP. This option is typically used in scenarios where local access to the MySQL server is sufficient, and there's no need for remote connections.
-networking: This option is not correct. There is no option named -networking in MySQL that controls whether the server listens on a network port for TCP/IP connections.
-skip-networks: This option is not correct. The correct option to skip networking is -skip-networking, not -skip-networks.
-quit-networking: This option is not correct. There is no option named -quit-networking in MySQL that controls networking behavior.

Therefore, the option used to prevent the MySQL server from listening on a network port for TCP/IP connections is Option B: -skip-networking.