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?
A.
CREATE USER ‘admin’ @’%’;
B.
GRANT USAGE ON *.* TO ‘admin’@’%’;
C.
FLUSH PRIVILEGES;
D.
FLUSH HOST CACHE;
E.
FLUSH HOST CACHE;
Explanation:
C
c