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 providesbetter 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 theserver with this option will provide support to the older
clients.
Answer A is incorrect. This option will enforce theserver 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.