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 has a 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.