Why did this error occur?
A. The host on the command line is not defined in the login path.
B. The mysqld instance has not been restarted after creating the login path.
C. There is no password defined in the login path.
D. The DNS is not configured correctly for slave1 host.
E. The .mylogin.cnf file is not readable.
Correct Answer: E
Section: (none)
Explanation
Explanation/Reference:
QUESTION 17
You are setting up a new installation of MySQL Server 5.7 (a GA release.) You have used a ZIP or TAR package to ensure that the mysqld binary, along with its
support files, such as plug-ins and error messages, now exist on the host. Assume that the default datadir exists on the host. You installed the binary in the default
location (the default --basedir value) for your operating system.
Which step should you perform before defining your own databases and database tables?
A. Execute a command with a minimal form of: mysql --initialize
B. Register mysqld as a service that will start automatically on this host machine.
C. Create a configuration file containing default-storage-engine=InnoDB.
D. Set an exception in the host machine’s firewall to allow external users to talk to mysqld.
E. Create additional login accounts (so that everyone does not need to log in as root) and assign them appropriate privileges.
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
QUESTION 18
Consider that local disk files are accessible via MySQL with commands such as:
mysql> LOAD DATA LOCAL INFILE ‘/etc/passwd’ INTO TABLE mypasswords;
What change could be made to stop any breach via this insecurity?