Which command will fix this issue?

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?

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:



Leave a Reply 2

Your email address will not be published. Required fields are marked *