You are the database administrator of a MySQL database server. Your network contains a combination of new
and old (pre-4.1) MySQL clients.
You are configuring a new server for testing purposes. You want to allow connections only by the clients that
have new-format passwords.
Which of the following steps will you take to accomplish the task?
A.
Start the server with the –old-password option.
B.
Start the server with the –secure-auth option.
C.
Start the server with the –enable-named-pipe option.
D.
Start the server with the –shared-memory option.
Explanation:
According to the question, the network contains both new and old clients and you have to allow only the new
clients that support new-format
passwords. In order to accomplish the task, you will have to start the server with the –secure-auth option. This
will cause the server to
reject connection attempts from any client that hasa password in the old format. Answer D and C are incorrect.
These options enable shared memory and named-pipe connection protocols, so that in a Windows
server the local clients can use either of these connections to connect with the server. Answer A is incorrect.
This option will provide support for the older clients.