You are the database administrator of a MySQL server that runs on a Windows server. All clients are local
clients. For security, you want to disable connections from the remote clients. Which of the followingsteps will
you take to accomplish the task?
A.
Start the server with the –disable-networking option.
B.
Start the server with the –shared-memory option.
C.
Start the server with the –skip-networking option.
D.
Start the server with the –secure-auth option.
Explanation:
According to the question, all the clients are local and you want to disable connections from the remote clients.
In order to accomplish this
task, you will have to start the server with the –skip-networking option. This will disable the TCP/IP connections
(the only type of connection
that can be made by the remote clients).
Answer B and D are incorrect. These options will not disable remote connections. Answer A is incorrect. No
such option is available with a MySQL server.