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.
UPDATE mysql.user SET Create_user_priv = ‘Y’ WHERE user= ‘admin’;

Explanation:
Reference: http://lists.mysql.com/mysql/218268



Leave a Reply 3

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


Vince

Vince

C. FLUSH PRIVILEGES;