Oracle
1Z0-883 · Question #104
1Z0-883 Question #104: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-883 to reveal the answer and full explanation for question #104. The question stem and answer options stay visible for context.
Question
You are creating a new server with the same accounts as an existing server. You do this by importing a mysqldump file of the mysql database. You test whether the import was successful by using the following commands: Mysql> select user, host, password from mysql.user; 9 rows in set (0.00 sec) Mysql> show grants for
admin'@'%'; ERROR 1141 (42000): There is no such grant defined for user admin' on host `%' Which command will fix this issue?Options
- ACREATE USER `admin' @'%';
- BGRANT USAGE ON . TO `admin'@'%';
- CFLUSH PRIVILEGES;
- DFLUSH HOST CACHE;
- EUPDATE mysql.user SET Create_user_priv =
Y' WHERE user=admin';
Unlock 1Z0-883 to see the answer
You've previewed enough free 1Z0-883 questions. Unlock 1Z0-883 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.