QuestionQ177

Database Security

Mary connects to a Linux MySQL Server from a client on a Windows machine.

Review this statement and its output:

Question Image

Which two statements are true?

Choose two
  • A Mary has the privileges of account mary@%.
  • B Mary connected to the database server whose IP address is 192.0.2.101.
  • C Mary connected from a client machine whose IP address is 192.0.2.101.
  • D Mary connected using a UNIX socket.
  • E Mary authenticated to the account [email protected].
Explanation

CURRENT_USER() identifies the MySQL account used to authenticate the client and determines that session’s privileges; here it is mary@%. USER() identifies the user name supplied by the client and the host from which the client connected; here it is mary@192.0.2.101.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!