MySQL Multiple Choice 1. Both Linux and Windows contain the following databases

Question

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.

Explanation / Answer

2. Answer is option (a) True

The default authentication plugin of mysql 8 is mysql_native_password.

3. Answer is option (a) True

It is true that MySQL's caching_sha2_password authentication plugin is more secure than the mysql_native_password plugin. It is better to use caching_sha2_password for authentication, it provides better security than the other one.

4.answer is option (d) must be downloaded and installed as a separate package

The python mysql connector library should be downloaded and installed as seperate package. It is used to connect musql database from python.

5.answer is option (e) In Linux you can run MySQL in 'safe mode' (which doesn't require a password to login) to reset your password.

After stopping mysql server system, you have to start mysql in safe mode using the command - - skip-grant-tables. Linux will not ask for password in safemode, after login to mysql you can changr the password.

END, PLS GIVE ME GOOD RATING

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.