You install a copy of Mysql 5.6.13 on a brand new Linux server by using RPM packages. The server starts successfully as verified by the following commands:

$ pidof mysqld

3132

$tail - n2 /var/lib.mysql/hostname.err

2013-08-18 08:18:38 3132 [Note] /usr/sbin/mysqld: ready for connections.

Version: ‘5.6.13-enterprise-commercial-advaced’ socket: ‘/tmp/mysql.sock’ port;

3306 Mysql Enterprise Server – Advanced Edition (Commercial)

You attempt to log in as the root user with the following command:

$mysql –u root

ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO)

Which statement is true about this scenario?

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?

The validate_password plugin is loaded and displays the following settings in global variables:

Mysql> SHOW VARIABLES LIKE ‘validate_password%’;

When attempting to set your password, you get the following error:

Mysql> SET PASSWORD = PASSWORD (‘Hoverl@%’);

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

What is the cause of the error?