Exam 98-364 topic 1 question 223 discussion

Actual exam question from Microsoft's 98-364

Question #: 223
Topic #: 1

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.

Show Suggested Answer

Suggested Answer: B 🗳️

by rogeriosolano at June 28, 2022, 5:09 p.m.

Comments

Submit Cancel

rogeriosolano

2 years, 11 months ago

Selected Answer: B

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.

upvoted 1 times

...