Oracle Exam 1Z0-909 Topic 1 Question 53 Discussion

Actual exam question for Oracle's 1Z0-909 exam

Question #: 53
Topic #: 1

[All 1Z0-909 Questions]

Your program which uses a MySQL connector receives this error:

Client does not support authentication protocol request by server

The account running the program uses caching_sha2_password.

Which two resolve this conflict?

ADisable TLS/SSL authentication.

BPlace this in the root directory of your shell account:
[mysqld] require__secure_transport=OFF

CUse blank RSA or SSL certificates.

DUpgrade the connector to a version that supports caching_sha2_password.

EChange the user account to use mysql_native_password.

Show Suggested Answer

Suggested Answer: D, E

by Vashti at Nov 15, 2024, 04:22 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-909 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Ricki

5 months ago

I think changing the user account to use mysql_native_password could also work as a solution.

upvoted 0 times

...

Marilynn

5 months ago

You know, this question reminds me of the time my grandpa tried to fix his old tractor with duct tape and a paperclip. Didn't work out too well, let me tell you.

upvoted 0 times

India

4 months ago

E) Change the user account to use mysql_native_password.

upvoted 0 times

...

Sue

4 months ago

D) Upgrade the connector to a version that supports caching_sha2_password.

upvoted 0 times

...

Fidelia

5 months ago

A) Disable TLS/SSL authentication.

upvoted 0 times

...

Louisa

5 months ago

Wait, what? Blank RSA or SSL certificates? I'm pretty sure that's not going to work. This question is a real head-scratcher.

upvoted 0 times

...

Kristeen

5 months ago

Disable TLS/SSL authentication? Are they serious? That's like trying to fix a flat tire by removing the entire wheel. Definitely not the answer.

upvoted 0 times

...

Annita

5 months ago

I agree with Katlyn, upgrading the connector seems like the most logical solution.

upvoted 0 times

...

Viola

5 months ago

Option E seems like the easiest fix. Just change the user account to use mysql_native_password and you should be good to go.

upvoted 0 times

Leonida

5 months ago

I had the same issue before and changing to mysql_native_password worked like a charm.

upvoted 0 times

...

Teresita

5 months ago

I agree, that's probably the quickest solution to resolve the conflict.

upvoted 0 times

...

Carlee

5 months ago

Option E seems like the easiest fix. Just change the user account to use mysql_native_password and you should be good to go.

upvoted 0 times

...

Katlyn

5 months ago

I think the best option is to upgrade the connector to support caching_sha2_password.

upvoted 0 times

...

Idella

6 months ago

Hmm, I think option D might be the way to go here. Upgrading the connector to a version that supports caching_sha2_password sounds like the most straightforward solution.

upvoted 0 times