MySQL Multiple Choice

1. Both Linux and Windows contain the following databases (schemas) by default: information_schema, performance_schema, sys and mysql.

(a) True (b) False

2. As of MySQL 8, the default authentication plugin is mysql_native_password. (a) True (b) False

3. MySQL's caching_sha2_password authentication plugin is more secure than the mysql_native_password plugin. (a) True (b) False

4. The Python MySQL Connector library: (a) come pre-installed with Linux (b) comes pre-installed with the installation of MySQL8. (c) comes pre-installed with the installation of Python3. (d) must be downloaded and installed as a separate package.

5. What should you do if you forget your root password for MySQL? (a) Go to get a root canal. (b) You have to re-install MySQL with a new password. (c) You better hope you wrote it on a Post-It, because there is no way to recover or change the password. (d) Call the GeekSquad to help. (e) In Linux you can run MySQL in 'safe mode' (which doesn't require a password to login) to reset your password.

6. Which of the following is NOT a good idea to do after you change the root password? (a) Restart the MySQL Service. (b) Write down the new password in a safe place. (c) Keep the change password file on the server in case you need to change the password again.