nerdexam
Oracle

1Z0-883 · Question #69

A Mysql Server has been running an existing application successfully for six months. The my.cnf is adjusted to contain the following additional configuration: [mysqld]…

The correct answer is D. They all connect via the secure sha256_password algorithm without any configuration change. See the full explanation below for the reasoning.

Question

A Mysql Server has been running an existing application successfully for six months. The my.cnf is adjusted to contain the following additional configuration:

[mysqld] Default-authentication-plugin=sha256_password The Mysql Server is restarted without error. What effect will the new configuration have in existing accounts?

Options

  • AThey will have their passwords updated on start-up to sha256_password format.
  • BThey will have to change their password the next time they login to the server.
  • CThey are not affected by this configuration change.
  • DThey all connect via the secure sha256_password algorithm without any configuration change.

How the community answered

(42 responses)
  • A
    14% (6)
  • B
    7% (3)
  • C
    2% (1)
  • D
    76% (32)

Community Discussion

No community discussion yet for this question.

Full 1Z0-883 Practice