Choose all the correct options

Question

consider the mysql enterprise audit plugin.you are checking user accounts and attempt the following query:mysql> select user, host, plugin from mysql.users;error 1146 (42s02): table ‘mysql.users’ doesn’t existwhich subset of event attributes would indicate this error in the audit.log file?

Accepted Answer

NAME=”Query”
STATUS=”1146”
SQLTEXT=”select user,host from users”/>

Answer

NAME=”Error”
STATUS=”1146”
SQLTEXT=”Error 1146 (42S02): Table ‘mysql.users’ doesn’t exist”/>

Answer

NAME=”Query”
STATUS=”1146”
SQLTEXT=” Error 1146 (42S02): Table ‘mysql.users’ doesn’t exist”/>

Answer

NAME=”Error”
STATUS=”1146”
SQLTEXT=”select user,host from users”/>

Answer

NAME=”Error”
STATUS=”0”
SQLTEXT=”Error 1146 (42S02): Table ‘mysql.users’ doesn’t exist”/>

Consider the Mysql Enterprise Audit plugin.

0 Discussions

Trending Exams