Examice

Exam 1z0-908 All QuestionsBrowse all questions from this exam

Go to Exam

Question 134

You recently upgraded your MySQL installation to MySQL 8.0.

Examine this client error:

Which option will allow this client to connect to MySQL Server?

[mysqld]

default_authentication_plugin=sha256_password

ALTER USER user -

IDENTIFIED WITH mysql_native_password

BY 'password';

[mysqld]

default_authentication_plugin=caching_sha2_password

ALTER USER user -

IDENTIFIED WITH caching_sha2_password

BY 'password';

ALTER USER user -

IDENTIFIED WITH sha256_password -

BY 'password';

[mysqld]

default_authentication_plugin=mysql_native_password

Correct Answer: B

The error message indicates that the authentication plugin 'caching_sha2_password' cannot be loaded because the required shared object file is missing. To resolve this, you can change the authentication plugin for the user to one that is available. Using the command 'ALTER USER user IDENTIFIED WITH mysql_native_password BY 'password';' will change the authentication method to 'mysql_native_password', which is a commonly supported and available plugin, allowing the client to connect to the MySQL Server.

Discussion

marklvOption: A

A. F is kinda valid, but it doesn't to current accounts, which is this one.

marklv

Sorry meant B. you have to use mysql native passwords. F only applies to new accounts.