Database Fundamentals — Question 151

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?

Answer options

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

Correct answer: B

Explanation

The correct answer is B, as starting the server with the --secure-auth option enforces the use of new-format passwords and disallows legacy clients that use old password formats. Option A is incorrect because using --old-password would allow connections from both old and new clients, which is not the goal. Options C and D are unrelated to password formats and do not affect client authentication methods.