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?

1. A. Execute a command with a minimal form of: mysql --initialize
2. B. Register mysqld as a service that will start automatically on this host machine.
3. C. Create a configuration file containing default-storage-engine=InnoDB.
4. D. Set an exception in the host machine’s firewall to allow external users to talk to mysqld.
5. E. Create additional login accounts (so that everyone does not need to log in as root) and assign them appropriate privileges.

Correct Answer: C

Which three allocate memory per thread in MySQL?

1. A. query cache
2. B. thread cache
3. C. read buffer
4. D. internal temporary table
5. E. sort buffer
6. F. InnoDB buffer pool instance

Correct Answer: CEF

After rebooting the host, you attempt to start the mysqld service. You get the following error: Can’t start the server: Bind on TCP/IP port: Address already in use
What is the most likely cause of this error?

1. A. The mysql service has already been started on the same port.
2. B. The network service process in the server is frozen, so all TCP/IP connections are paused and cannot be reused.
3. C. You failed to specify the port number 3306 to the command to start the server, so it is defaulting to port 80, which is in use by the built-in web server.
4. D. The /etc/hosts file does not have a valid IP entry for mysqld localhost, so it is binding to 127.0.0.1, which is already in use.
5. E. The mysql.sock file in the MySQL /tmp directory was not removed after the reboot, so mysqld still thinks there is an active server running.

Correct Answer: E