Database Fundamentals — Question 143

You are the database administrator for a MySQL database server.
The network contains new and old (pre-4.1) clients.
You configure another database server on the network.
You allow the network clients to connect to the new server.
Some users complain that when they try to connect to the server, they receive the following error:
ERROR 1251: The client does not support authentication protocol requested by the server; consider upgrading MySQL client
You do not want to upgrade any client or server right now, and want to enable all clients to connect to the new server successfully.
Which of the following steps will you take to resolve the issue?

Answer options

• A. Run the server with the --secure-auth option.
• B. Run the server with the --old-password option.
• C. Run the server with the --allow-old option.
• D. Run the server with the --enable-old option.

Correct answer: B

Explanation

The correct answer is B because running the server with the --old-password option allows compatibility with older clients that use the pre-4.1 authentication protocol. The other options, such as --secure-auth, restrict older authentication methods, while --allow-old and --enable-old are not valid MySQL options for resolving the authentication issue.