MySQL 8.0 Database Administrator — Question 62

You must configure the MySQL command-line client to provide the highest level of trust and security when connecting to a remote MySQL Server.
Which value of --ssl-mode will do this?

Answer options

• A. PREFERRED
• B. VERIFY_CA
• C. REQUIRED
• D. VERIFY_IDENTITY

Correct answer: D

Explanation

The correct answer is D, VERIFY_IDENTITY, as it not only requires SSL encryption but also verifies the server's certificate against a trusted certificate authority and checks the hostname. The other options, while providing varying levels of security, do not meet the same stringent requirements for identity verification as VERIFY_IDENTITY.