1Z0-908: MySQL 8.0 Database AdministratorDemo

Question

Examine the following statements and output:

Question Image

Which statement is correct?

A The user is logged in with --user=accounting as an option.
B The user is authenticated as the anonymous proxy user ‘’@’%’.
C The user is authorized as the accounting@localhost user.
D The user is authorized as the rsmith@localhost user.
E The user failed to define a username and the connecting username defaulted to ‘’@’%’.

Explanation

During MySQL proxying, USER() identifies the connecting user, whereas CURRENT_USER() identifies the proxied account whose privileges apply to the session. Here, CURRENT_USER() is accounting@localhost; @@proxy_user identifies the anonymous proxy account used in the mapping.

Learn more

MySQL Reference Manual — Proxy Users

1Z0-908: MySQL 8.0 Database AdministratorDemo

AstroTutor

Notes

Readiness

QuestionQ44

Community Discussion