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.
UPDATE mysql.user SET Create_user_priv = ‘Y’ WHERE user= ‘admin’;
Explanation:
Reference: http://lists.mysql.com/mysql/218268
C. FLUSH PRIVILEGES;
C
C