ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-908 All Questions

View all questions & answers for the 1z0-908 exam
Go to Exam

Exam 1z0-908 topic 1 question 135 discussion

Actual exam question from Oracle's 1z0-908
Question #: 135
Topic #: 1
[All 1z0-908 Questions]

You recently upgraded your MySQL installation to MySQL 8.0.
Examine this client error:

Which option will allow this client to connect to MySQL Server?

  • A. [mysqld]
    default_authentication_plugin=sha256_password
  • B. ALTER USER user -
    IDENTIFIED WITH mysql_native_password
    BY 'password';
  • C. [mysqld]
    default_authentication_plugin=caching_sha2_password
  • D. ALTER USER user -
    IDENTIFIED WITH caching_sha2_password
    BY 'password';
  • E. ALTER USER user -

    IDENTIFIED WITH sha256_password -
    BY 'password';
  • F. [mysqld]
    default_authentication_plugin=mysql_native_password
Show Suggested Answer Hide Answer
Suggested Answer: E 🗳️
by marklv at Sept. 6, 2023, 8:14 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
marklv
11 months ago
A. F is kinda valid, but it doesn't to current accounts, which is this one.
upvoted 1 times
marklv
7 months, 4 weeks ago
Sorry meant B. you have to use mysql native passwords. F only applies to new accounts.
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago