1Z0-908 practice question 18 of 25

Examine this MySQL client command to connect to a remote database: mysql -h remote.example.org -u root -p --protocol=TCP --ssl-mode= Which two --ssl-mode values will ensure that an X.509-compliant certificate will be used to establish the SSL/TLS connection to MySQL?

Full set: 140 questions
Answer options
A: REQUIRED
B: VERIFY_CA Correct answer
C: VERIFY_IDENTITY Correct answer
D: PREFERRED
E: DISABLED
Correct Answer:
B. VERIFY_CA; C. VERIFY_IDENTITY
Explanation

The VERIFYCA and VERIFYIDENTITY modes both mandate an encrypted SSL/TLS connection and perform validation of the server's X.509 certificate. VERIFYCA requires the connection to be encrypted and verifies the server certificate against a configured Certificate Authority (CA). VERIFYIDENTITY provides the highest level of security by performing the VERIFYCA checks and also verifying that the server hostname matches the identity in the certificate. These modes ensure the certificate is not only used but also authenticated, which is crucial for secure communication and preventing man-in-the-middle attacks.

Why Incorrect

A. REQUIRED: Forces encryption but performs no certificate validation, so the identity of the server is not authenticated.
D. PREFERRED: Does not ensure an encrypted connection, as it will fall back to an unencrypted one if SSL/TLS negotiation fails.
E. DISABLED: Explicitly disables SSL/TLS, resulting in an unencrypted connection where no certificate is used.

References

1. MySQL 8.0 Reference Manual, Section 6.3.1, "Configuring MySQL to Use Encrypted Connections". The documentation describes the behavior of each --ssl-mode value. It specifies that VERIFYCA will "verify the server CA certificate against the configured CA certificate" and VERIFYIDENTITY will "also verify that the server host name...matches the identity in the server certificate." This confirms that these two modes perform validation, which is a higher level of assurance than REQUIRED, which only forces encryption without validation.

Scroll to Top