MySQL Answer as soon as possible Multiple Choice

1. The default my.ini and my.cnf files for Windows and Linux contain the same configuration parameters. (a) True (b) False

2. Both Linux and Windows contain the following databases (schemas) by default: information_schema, performance_schema, sys and mysql. (a) True (b) False

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

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

5. 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.

6. 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.

7. 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.