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?

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?

Accepted Answer

C. FLUSH PRIVILEGES;

Answer

A. CREATE USER `admin' @'%';

Answer

B. GRANT USAGE ON *.* TO `admin'@'%';

Answer

D. FLUSH HOST CACHE;

Answer

E. UPDATE mysql.user SET Create_user_priv = `Y' WHERE user= `admin';

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…

Question

Options

How the community answered

Community Discussion