Which of the following steps will you take to accomplish the task?

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?

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?

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.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Lena

Lena

How Do I Enable Remote Access To MySQL Database Server?

Make sure line skip-networking is commented (or remove line)