Exam 98-364 topic 1 question 184 discussion

Actual exam question from Microsoft's 98-364

Question #: 184
Topic #: 1

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?

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.

Show Suggested Answer

Suggested Answer: B 🗳️

by rogeriosolano at June 28, 2022, 2:42 p.m.

Comments

Submit Cancel

rogeriosolano

2 years, 11 months ago

Selected Answer: B

According to the question, you are receiving Error 1251. Servers from MySQL 4.1 and later, use an enhanced authentication mechanism for providing greater security. This mechanism provides better passwords than in the older version. When client programs try to connect to the server, they do not understand this mechanism and produce the above stated error. In order to resolve the issue, you will have to run the server with the –old-password option. Starting the server with this option will provide support to the older clients. Answer A is incorrect. This option will enforce the server to reject connection attempts for any client that has a password in the old format. Answer D and C are incorrect. No such options are available with the server.

upvoted 1 times

...