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.
Explanation:
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.