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?
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?
For the highest level of trust and security when connecting to a remote MySQL server using the command-line client, the --ssl-mode value should be VERIFY_IDENTITY. This mode requires SSL, verifies the certificate authority, and also checks that the server's identity matches the hostname, ensuring maximum security.
VERIFY_IDENTITY: Like VERIFY_CA, but additionally perform host name identity verification by checking the host name the client uses for connecting to the server against the identity in the certificate that the server sends to the client
Agreed - Answer D.
Agreed - Answer D.