Database Fundamentals — Question 137

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 following steps will you take to accomplish the task?

Answer options

• 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.

Correct answer: C

Explanation

The correct answer is C, as starting the server with the --skip-networking option disables all TCP/IP connections, effectively preventing remote access. Option A is incorrect because --disable-networking completely shuts down all networking, including local client connections. Option B, --shared-memory, does not disable remote connections but instead allows for shared memory access. Option D, --secure-auth, deals with authentication methods and does not affect network connectivity.